save file to xlsx foramt (Exsel 2007)

[yechielo]

Hi,

I work with LabVIEW8.2, how can I save file as a .xlsx (Exsel 2007)?

Thx

[waldemar.hersacher]

You need the http://www.ni.com/toolkits/report_gen.htm Reporting toolkit for MS Office.

[yechielo]

Thx

but i'm a student and i need to save only one file in my final project, is there any free/eazy way to do that?

if i will save the file as xls format (Exsel 2003) it's ok too....

[BenjaminR]

Hi,

You have an example in LabVIEW help; look for “Write Table to XL”. What kind of data would you like to save in this file? You have some native file type in LabVIEW and then you can open it in Excel with an Add-in complement. Let me know if I answer to your question.

[smercurio_fc]

If all you're doing is just saving some data you can just use the Write To Spreadsheet File VI. This generates a tab-delimited file that can easily be opened in Excel. If you set the filename with the extension of .xls then you will be able to double-click the file to have it open in Excel, but you must be aware that it's still a text file.

[waldemar.hersacher]

You can use the way of smercurio_fc. But be aware that all locale settings in LabVIEW and Excel must match. This is critical for the decimal separator and the column separator. Excel behavies differently by just double clicking on a csv-File or opening it by File > Open. In the first case Excel will read in the file without the localized settings, in the second case Excel knows the localized settings and will open an wizard for import. In this wizard you can change some of the import options like the column separator.