How to write a new row in an existing excel file each time I run the VI?

[Aneece]

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

[MikeS81]

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

[GerdW]

Hi Aneece,

in case you speak of csv/tsv files as "Excel files" you should simply switch the "attach?" input of text write functions to TRUE...

[smercurio_fc]

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.

Message Edited by smercurio_fc on 06-21-2009 10:02 AM