Corrupted Excel file?

[Newbie92]

Hi all,

I'm having problem with writing the data from my simulated vi data into Excel. After I run the Vi it works fine. But when I wish to open the excel file in which I set as the file path, it says the file extension is not valid. Why is that? Oh btw I'm still new so forgive me if this is an obvious question. I attached my VI as well as the error.

Regards,
Newbie92

[Newbie92]

I forgot to mention that I intend to open the file after i stop the VI

[GerdW]

Do you know you CANNOT write an Excel XLSX file using WriteToSpreadsheetFile?
(Just a guess as I'm not able to look at your VI right now.)

[Lies]

Best you can do is to write to a .csv file that excel can open an then save as excel workbook. Or try exporting to .xls instead of .xlsx.

In any way, i had the same problem like you and the .csv method workedd just fine for me, but feel free to try the last one too.

[Newbie92]

Hi GerdW,

No I didn't know that. Thanks for the info. Actually my purpose is just to create a saving application and I thougt writing to Excel would be the best choice. Do you have any tips or guide that I could follow to do so?

Regards.
Newbie92

[Newbie92]

Hi Lies,

I see. I will try and study the method. Thanks again.

Regards,

Newbie92

[mikeporter]

Actually this is something that has changed around a bit over there life of Excel. At one point it wouldn't open tab-delimited files at all unless you explicitly told it that was what you were doing. Then there was a period where it would automatically open tab-delimited files if you gave them the XLS file extension. Now, it will still open files like that, but will generate the "warning" you saw first.

Mike...

[Newbie92]

Hi mikeporter,

Thanks for the pointers. I'll keep that in mind when making my save applications.

Regards,

Newbie92

[mikeporter]

If you want to save to a real excel file, there are ways of doing that too. Check the examples.

Mike...

[Bob_Schor]

If you really want to write to Excel, you need the Report Generation Toolkit (which is now bundled with LabVIEW 2014).  If you type the word "Revised" (without the quotes) in the Search box of this forum, the first thing it pops up is an Example that I posted here showing how to do this.

Bob Schor