Writing multiple port data report into single excel file

[rg.naveen]

I'm working on a STTE automation of an power management unit in which data's from 6 different channels are received from the unit which has to be tested and then verified and co-related with the digital and analog inputs given by the user. So my question is finally how to write all dese six channel's data to a single excel file with multiple work sheets..... Like channel-1 one in sheet1,ch-2 in sheet2 so on.... (these data's from 6 different are received from 6 different serial communication port.)

 pls guide how to forward in the final report generation for abv mentioned requirement in labview

[nyc_(is_out_of_here)]

If you want multiple worksheets in your Excel file, then you will need to use either ActiveX automation or ADO.

[rg.naveen]

the attachment pic is just a prototype... it shows dat basic desigh i've made to receive 6 serial data from 6 diff channels of different baud rates... now i've stuck up in d phase where i'm unable to log all 6 datas into one excel file with 6 different sheets... please give me a idea how to proceed... or do i have to modify the programme? like replacing loops? please jus show me demo of creating excel file of multiple sheets, using atleast two different channels...

[nyc_(is_out_of_here)]

Examples on how to write to Excel via ActiveX automation is included the LabVIEW. You will have to modify it to be able to write to multiple worksheets in an Excel file.

[rg.naveen]

ok..i'm new to labview... i'm not getting an idea like how to do that... pls anyone just give a lift by providing example or let me know wer and how to modify dis programme for my requirement..

[TiTou]

As nyc mentioned you will have to use ActiveX if you want to do exactly what you discribed but if you're new to LabVIEW that can be a big step.

In the VI you posted you write your data to xls file but the fact is that you use the write to text file function, so in the end your file is just a simple text file, and of course Excel can open this type of file.

Maybe you could have your VI to write txt files and then have another bit of code that would transfert the data in each text file to differnt worksheet in a Excel file.

Or maybe another option would be to write all your data to the same TDMS file (on channel per port) and then use the TDMS Excel Add in to generate an Excel file from the TDMS.

Feel free to ask more questions 😮

[TiTou]

Here's a quick starter if you want to go for the TDMS option :

[rg.naveen]

thanks..i'm trying what u hav shown in the pic... but i'm using lv2009 the tdms close function as shown in the pic is not availabe in my function list.. so how to get output file path?

[TiTou]

Indeed, I have LV 2010 and the previous versions don't have the path output on the TDMS close primitive but you can use the path value at the TMDS open to display it.

Hope this helps