how can I send my output into a spreadsheet without having to ask for the spreadsheet headings to be written everytime? In other words, can I create a step to write the headings on the spreadsheet and then be able to continue wrting data in the same table without the need to re-create the step for the headings?
Are you using the Write to Spreadsheet File VI to write the data to a text file? Or using ActiveX or the Report Generation Toolkit to write to an Excel Spreadsheet?
UF newbie wrote: I am using the write to spreadsheet command
Then you can just do as the code provided by Dimitrios shows. Write out your header first, then write out your data, using the "append to file?" input.
Note that in the example posted the sequence frame is not necessary. All you need to do is to use the "new file path" output rather than branching the wire. This will guarantee that the header is written before the loop starts.
Just in case you are not familiar with LabView. I have created an array of 2 Headings using strings.Inside the loop i have generated some 'random numbers' for your first column and added 5 to the same number for your second column. Then i just have build an array with both numbers. Don't forget to put some delay in your while loop so it allows your proccessor to do other things as well.
