How to save data to file(.xls)

[safix]

I need save data to .xls format- Microsft Excel....Labview allows only save to .xlsx format. Do you know somebody if is possible save file in .xls? Thank you for your help.

[Michel_Gauvin]

See this post:

https://forums.ni.com/t5/LabVIEW/How-to-Save-a-Table-Data-to-Excel-File/m-p/2997631/highlight/true#M...

[safix]

Please, can u write me exact solution for mine problem? This link is a little different.

[JCH_26]

Hi Safix

You should eb able to find examples for FILE I/O in the LabVIEW Example Finder: https://knowledge.ni.com/KnowledgeArticleDetails?id=kA03q000000YIKbCAO&l=en-US

Regards

Jonathan Hird CLAD

Applications Engineer

NI UK & Ireland

[safix]

Hi JCH26,

thanks, I will check it out. But I asked if someone has experience with this problem.

[Michel_Gauvin]

The answer is yes it's possible to save data in .xls file and there are multiple ways of doing this.  Send your code for a more appropriate answer.

[Bob_Schor]

I had the opposite problem -- I was always saving .xls, and I wanted to use .xlsx.  My solution was to simply use .xlsx as the extension whenever required, and it worked like a charm.  Have you tried doing the opposite, using .xls whereever an extension is specified?  [I can think of only two places this occurs in the Report Generation Toolkit, namely New Report and Save Report to File].  In my case, when both were .xls, my Excel format was .xls, also.

Bob Schor

[Bob_Schor]

It occurs to me that I might have given an inappropriate answer to your question.  When you asked how to write an .xls (Excel) file, and mentioned that you had the option of writing an .xlsx file, but not .xls, I assumed that you were using the LabVIEW Report Generation Toolkit, which was the basis of my previous response.

When asking for help, it is helpful to us (and therefore helpful to you) to provide a little more information, including the Version of LabVIEW that you are using and a "snippet" of the relevant LabVIEW code that is giving your problems.  [Note -- if you use LabVIEW's "Snippet" feature, shown on the Edit Menu, it not only shows code but also provides the LabVIEW version].

In particular, if you happen to be using LabVIEW 2014 (but not LabVIEW 2012 or earlier), you might have been trying to save your data by using Write to Measurement File, for which NI now provides the possibility to write the data in the .xlsx format.  NI added this feature in LabVIEW 2013, as it happens.  By this time, the .xlsx format (simpler, less proprietary) had become more-or-less "standard", so it was chosen as the "feature to add".

If you must write your data in the .xls format, do not use Write to Measurement File.  On the other hand, if you have to use Write to Measurement File, you should be able to read your data even with Excel 2007, as Microsoft has a package that provides the ability to read the .xlsx format for this version of Excel.

I hope that this answers your question.

Bob Schor

[safix]

I am using Labview 2013 SP1. Yes, I am able to open file in Excel2007 but I need  to save  in xls. format. So when I won't  to use Write to Measurement File, what is solution for me? I  weren't using the LabVIEW Report Generation Toolkit(I haven't known that).  My English is not that strong. ... I am a little confused. Thank you.

[Munna232]

If you want to store your data in .xls format,  you need to use Report generation toolkit(RGT)/ActiveX.

Check this links to get some idea about RGT.

https://knowledge.ni.com/KnowledgeArticleDetails?id=kA03q000000x3gcCAA&l=en-US

https://knowledge.ni.com/KnowledgeArticleDetails?id=kA03q000000x4PICAY&l=en-US

You will get lots of Tutorials in NI forum. Please search it.