How do I add a header line in "write to a spreadsheet" vi

[00kar]

Hi,

I have been writing data from a bundle to a spreadsheet using "write to spreadsheet" vi.

It seems to be working fine but I am in the process of submitting a report and would like to add header names for the columns of data.

So I need help to add column headers for the data being entered.

[Anna_K.]

Hello,

You could write to it twice, first with an array of strings ( you may have to set Transpose to true) then again with data as long as you set Append? to True the second time. Does that help? Otherwise the Report Generation Toolkit has Excel specific VIs that can do pretty much everything from graphs and tables to custom formatting etc.

Thanks,

Anna K.