.CSV FILE PROGRAMMING

[systemcrash]

I'm using write to spreadsheet file for dumping the data of the test. I have 5-6 different variables each holding different kind of results (basically voltage values, time stamp). I want to write single variable results in one page and second variable result is another page and so on, can I do this using write to spreadsheet file api ? I can use report generation toolkit for excel to accomplish this, but was wondering is it possible with write to spreadsheet file ?

[smercurio_fc · Accepted solution]

The Write to Spreadsheet File does not create "pages". It's misleading when it says "spreadsheet" in the name. It creates a text file, not an Excel workbook. As such, text files have no "pages", or sheets, like a workbook.

Yes, you can use the Report Generation Toolkit for this. You can also program it yourself using ActiveX (which is what the toolkit uses under the hood). For your next question, "how do I do this myself?", search the forum, as TONS of examples have been posted on controlling Excel via ActiveX. Lots of links to examples also exist in the Excel thread. NOTE: DO NOT POST QUESTIONS IN THE EXCEL THREAD.

[systemcrash]

thanks, I have gone through excel thread, its a great one. I have the program using report generation vi's. Thanks for clearing the doubt.