03-30-2011 01:19 PM
Just a quick question.
I have some test results. From a cluster I am creating a CSV file... But how do I make it to get the results in excel sheet, shaped as shown in the attached excel sheet. Please note that those are different tests (test1 to test4). They will be classified based on the Frequency such that test 1 is taking all the results based on Frequency 100, test2 will be taking all the results based on frequency 200 and so on.
Thanks for your help.
03-31-2011 09:20 AM
Option 1: Use the Write to Spreadsheet File VI. This creates a delimited text file that can be opened with Excel.
Option 2: Buy the Report Generation Toolkit for Office
Option 3: Use ActiveX directly (which is what the Report Toolkit uses) to write to Excel. Examples ship with LabVIEW on using ActiveX to manipulate Excel. You can also find lots of other examples in the Excel thread. (NOTE: DO NOT POST QUESTIONS IN THE EXCEL THREAD)