append data to an excel table

[Bruno Borba]

I want to append new numerical data to an existing excel table.

[Al_S]

See the Write Table to XL.vi example that ships with LabView. The Excel Macro example calls Open Specific Workbook.vi which lets you open an existing file. To find the examples, from any LabView window, goto Help >> Find Examples >> Search, then enter Excel in the box labeled Type a keyword to find.

[Michael_Munroe]

If you are using ActiveX to write to an open Excel document, you can ask Excel how many rows are currently in the document.

From the reference for WorkSheet, wire a property node and select UsedRange. Cascade that into another property node and select Rows. Cascade that into another property node and select Count.

This will return the number of rows that have been written. Just add 1 and use that number for your starting address.

Michael
ABCDEF