topic Re: Export data in Excel format in LabVIEW

Export data in Excel format

Macarel31 — Thu, 03 Jan 2013 04:39:01 GMT

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.

Re: Export data in Excel format

Pankajusic — Thu, 03 Jan 2013 05:25:19 GMT

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

Re: Export data in Excel format

Macarel31 — Thu, 03 Jan 2013 14:44:09 GMT

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

Re: Export data in Excel format

Dennis_Knutson — Thu, 03 Jan 2013 15:12:22 GMT

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.

Re: Export data in Excel format

Macarel31 — Thu, 03 Jan 2013 15:55:46 GMT

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.

Re: Export data in Excel format

MwMonty — Thu, 03 Jan 2013 16:14:15 GMT

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

Re: Export data in Excel format

Macarel31 — Thu, 03 Jan 2013 19:35:48 GMT

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.