Write to Spreadsheet File vi doesn't work in xlsx format

[Anne_Z]

Hi, I have used Write to Spreadsheet vi sending data to xls files. It didn't work now when associated with xlsx file. I got error message when opening the data file:

Excel cannot open the file 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.

Is Write to Spreadsheet.vi made for xls format only?

Is there an equivelent version for xlsx format?

Thanks,

Anne

[johnsold]

Write to Spreadsheet File.vi is NOT for writing Excel files. It creates TEXT files with tab delimiting (default) between fields.

Excel apparently will accept .xls extensions for text files. I have not used recent versions of Excel, so I cannot say what it does with other formats.

Lynn

[billko]

Just a heads-up:

The vast majority of node function questions can be answered by using the context help for it (i.e., ctrl + H and then mouse over the node in question).  If that's not enough, there is usually a link in the context help to a more detailed explanation.

For example, using the context help on the "Write to Spreadsheet File" node would've shown you that in order to format for Microsoft Excel, you need to use either the Report Generator or activeX.

[Anne_Z]

Thanks you for your responses.

If Write to Spreadsheet vi is not for xlsx file. Which Vis are alternatives?

[billko]

Did you actually read the replies?

[johnsold]

Bill's first reply tells you where to start if you need actual Excel files.

Lynn