Exporting data array to Excel in .xlsx file

[htesuy]

Hi, 

I want to send some data arrays from LabVIEW to an excel file, creating (or editing) a .xlsx file. When I try to open the created .xlsx file, it always says that:

¨Excel cannot open the file 'try.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.¨

So I am not getting my data in Excel that is what I need. Attached is the very simple vi I am trying.

Thanks!

[GerdW]

Hi htesuy,

---

@htesuy wrote:

Hi, 

I want to send some data arrays from LabVIEW to an excel file, creating (or editing) a .xlsx file.

---

Your VI does not work with XLSX files, the SpreadsheetFile functions works with delimited text files.

Two options:

1. Use a filename with a "CSV" suffix (or even "TXT"): Excel will still be able to handle your files.
2. Use the RGT (or ActiveX nodes, or external libraries like XLR8) to directly handle XLSX files…

Btw. you should use the default 4-2-2-4 connector pane pattern to allow for straight wires in your main VI…