How to save data to excel, word, etc

[Perry_Liu]

I want to use the write to spreadsheet, but the format of the saved data can not be opened by excel or word directly. Can I still use write to spreadsheet or I should use other buttons. Actually, I do not know how to choose the format of the saved data. Thanks for answering.

[ADrexelDragon]

The format the Vi called Write to Spreadsheet saves it directly to an xls file. You would have to save the data manually via path and strings. I do not understand what "other buttons" you are talking about. Please explain your problem further and with greater detail.

[_Ian_]

You can use 'Write to Spreadsheet' to create files that can be opened in Excel (e.g. csv files).

If you want to create 'real' .xls files you need to be a bit more creative.... there are many examples on the forums using ActiveX - I have been playing with this myself today - the info is all here, just be prepared to put a bit of effort in to understand it!

Similarly, if you create a text file it can be opened in notepad, Word etc. If you want to create a 'real' .doc file.... thats a bit harder to say the least  .

The attached example shows how to create a csv (comma separated variable) file using the Write to Spreadsheet function. It will open in excel perfectly well.

Ian

[chilly_charly · Accepted solution]

---

ADrexelDragon a écrit :

The format the Vi called Write to Spreadsheet saves it directly to an xls file. 

---

Not exactly. It saves the data as a "Tab/Return" ASCII file (assuming you don't change the separator). Means that the file can be opened by any text editor. Including Excel and Word.

If you want to open the file directly with Excel (or Word) with a simple double-click, then just add .xls (or .doc) as extension to the file name.

If you use the .txt extension, there are chances your file will be opened by Notepad.

Nothing complicated !

[Perry_Liu]

Thank you so much for answering. When I mentioned he other buttons, I meant other file I/O. When I used the write spreadsheet, it can not be opened using excel. And I want to output the data by either excel or word. Thanks.

[Perry_Liu]

Wow, so smart!! Thanks so much.

[Coq_Rouge]

You also have several options then using EXCEL.

[ADrexelDragon]

---

@chilly charly wrote:

Not exactly. It saves the data as a "Tab/Return" ASCII file (assuming you don't change the separator). Means that the file can be opened by any text editor. Including Excel and Word.

If you want to open the file directly with Excel (or Word) with a simple double-click, then just add .xls (or .doc) as extension to the file name.

If you use the .txt extension, there are chances your file will be opened by Notepad.

---

Thank you for the correction.
Good luck Perry Liu!