Adding rows to an existing Excel File.

[spaaw]

Hey,

I need to be able to add rows to an existing Excel File. I just wanted to know what are my options here.. any sample VIs already existing?

any help is appreciated.

Regars,

Pete

[smercurio_fc]

Have you tried a search? Reading/writing to Excel is a question that comes up like once a week. You need to use ActiveX. You can program it yourself (an example ships with LabVIEW), or you can buy the Report Generation Toolkit. Additional examples can be found in the Excel thread. NOTE: DO NOT POST QUESTIONS IN THE EXCEL THREAD.

[MoReese]

Yes, the Report Generation Toolkit works very well for this (active x underlies).  You can use the Write to Spreadsheet File.VI to append data to an Excel file.  But keep in mind this file is text-based and not a true Excel file.  That doesn't mean much unless you want manipulate the file with Active X, in which case you will have problems (such as col width, for instance).  If you have Report Generation Toolkit, use it.  It's very easy and flexible.