Want to generate a specific format in the excel file

[www.masibus.com]

Dear All,

                 I am new to the LabVIEW and I want the specific header in the excel file, is it possible to do this way? and if it could be then what could be the method to insert the data in the blank cells left in between? the format i want is i have attached in the excel file.

Thanks,

Parth

[Fox_Mccloud]

Hello www.masib. 😉

I have been looking for something like that too. However I could not find one.

What I ended up doing was to parse my own Excel xml file.

Open the file you have attached and save it as a XML in excel.

Open the xml file in notepad or some other textbrowser. Check out the layout and then build your own parser.

I've done this and it works perfect. Save the file you created with your parser to .xls and the user will never know the difference.


Hope this workaround suits your purpose.

Cheers

//Beckman

Message Edited by Fox_Mccloud on 02-06-2007 03:05 AM

[GerdW]

Hi Parth,

if you don't care about formatting options (bold/italic or row/column height/width) you can save your data in csv-format.
CSV means comma separated values and is easily imported into excel. You can also use tab instead of comma...

Build up a 2D-array of strings and put your values (either header strings or data) into the array. Then save the array using 'Write to spreadsheet'.