Spreadsheet format

[Analog_lab]

Hi,

I  want to write data with header using spreadsheet vi. I have attached my labview VI.

I want to save data in the  format as shown in  attachment no. 1. But , I am unable to write this way.

I always get the data stored in the format as shown in my attachment no.3.

Is there way I can store data this way.

Thanks,

[RavensFan]

Why did you upload bitmap images?  Renaming them to .jpg does not magically change them from bitmap to jpeg!

You can't get what you want in image two.  Write Spreadsheet File will always build files line by line, which means row by row.

You need to build up your arrays inside the loop, concatenating columns, then write to file just a single time outside the loops.

[Analog_lab]

Hi,

Sorry about the bitmap images.

Thanks for the reply. So, there is no way to write column by column. Good to know.

Thanks again.

[George_P_Burdell]

Analog_lab-

If you are looking to get further functionality of LabVIEW within the Microsoft Excel environment, I would strongly suggest using the Excel Specific VIs included in the Report Generation Toolkit.  They are extremely easy to use and will give you full functionality of the features in Excel.  These VIs provide you access to each specific cell and what you would like to add as well as graph functions, formatting, sorting, etc.  For additional information, please see the link below or contact National Instruments.  This link (under “Resources”) has a way to evaluate this toolkit free for 30 days to see what you think.  Good luck with the rest of your application.