Export data in Excel format

[Macarel31]

Hello,

I'm a little beginner in labview and for a project, i have to make a measurement program.

All is good but i have some difficulties to export the data.

I want to export organized data in Excel. I'm going to be clear:

I want to have data in colum with the legend at the top (for example, in the box A1 there is "frequency" writen and the rest of the column A is the values of the frequency, then in the box B1 there is "Spectrum" writen and the rest of the column B is the values of the frequency  spectrum,....).

There is an other thing. In the measurement program, it'a possible to write a commentary. I would like to export too the commetary on an other sheet of the excel file.

For the moment, the only thong that i can do is to export only the datain column.

There is somebody who can help me?

Thanks a lot.

PS: all the data are a 1D array.

[Pankajusic]

Please find the attached VI snippet.

I hope this will solve ur purpose.

I have used a template fro excel report.

Please use attached template.

Thanks

Pankaj

[Macarel31]

Thanks for the help but i don't have the "Excel add worsheet.vi".

Is it possible to have it (i dont find it free on internet).

Thanks a lot

[Dennis_Knutson]

It is not free. It is part of the Report Generation add-on.

You can do all of the ActiveX stuff yourself. There are numerous examples in the Excel Board. As an alternative, you can use one of file write functions to create a text file. Use a comma or tab separated file and Excel can import it. The only thing you cannot do with a text file is assign your comment to a separate worksheet.

[Macarel31]

Ok,

i think i'm going to do the thing diffrently. Instead of open a new sheet, the commentary and the data will be in the same sheet.

I'm going to see if it works.

Thanks for the answers.

[MwMonty]

Have you tried creating a TDMS file? Here is an example of a program I have pulling data from 3 different devices.

 

[Macarel31]

Finally,  the first program doesn't works without the report generation toolkit.

i'm going to see if it's possible with the tdms files.