06-21-2009 12:04 AM
Hi everyone,
is there any one tel me how I can store my data input in a new row of excel file each time i run the VI, in other words while iam running the VI there is a new data will be keyed in as a parameter and i need to save these parameters in a new raws of the same file.
thanks for any advice
06-21-2009 03:22 AM
Hi Aneece,
where do you have problems? Are you aware of Excel with ActiveX?
You can open your excel file each time you run your vi. You can then read how many rows are in there and write your new data in the row after the last used.
Mike
06-21-2009 04:57 AM
06-21-2009 10:01 AM - edited 06-21-2009 10:02 AM
I think Gerd means the "append to file?" input of the Write to Spreadsheet File VI if you use that to create text files that Excel can import.
If you absolutely, unequivocally, have to use ActiveX to write to an Excel file then you can use this bit of code to get the last used row:
Note that this assumes there's a value in each cell in the first column.