How can I write to multiple sheets in a single Excel spreadsheet?

[Elaine S]

I have a LARGE text file that I'd love to be able to run through a VI that breaks the data into blocks of about 65,000 line items and stores each block in an Excel workbook sheet. Any ideas?

Thanks in Advance,

Elaine

[RobertoBozzolo]

You can find some suggestion in the Excel Macro example, where vis to open a sheet and writne into cells are used. To create the necessary sheets you will need to create a new vi that uses method add on sheets collection (look at Open Specific Sheet subvi for an example of how to obtain and manipulate sheets collection).

If you have further doubts, I suggest you to post a new question in the labview forum: this one is dedicated to CVI.

Message Edited by Roberto Bozzolo on 05-28-2008 12:03 AM