Report Generation tool kit for MS office (Opening an existing excel file and appending to the bottom)

[Todd at Ormec]

I don't have any problems creating and filling an excel sheet with data. I use the New Report.vi, Easy Title.vi, and Easy Text.vi to create the file. I then save and dispose properly.

What I don't seem to be able to do is open the exsting file and append data to the end of the sheet.

Thanks in advance for your help.

todd

[Chienwei]

Hi Todd,

You can do this by creating a new Excel report with the existing excel file path wired to the "template" input. Then use "Excel Get Last Row.vi" (located under Report Generation\Excel Specific\Excel General) to obtain the location of the last row. Then use that location to input new data into the file.

Hope this helps,
Dan