Re : how do I create a spreadsheet file with labview

[Ms. Temi]

I simply want to create a spreadsheet file. all the comments i have read shows how to create a text file. or read/create from a spreadsheet but is it possible to create this spreadsheet through labview?

[tinnitus]

Hello Ms Temi,

a spreadsheet file is a txt file,

may be you want to say xls ?

Regards

Tinnitus

[tbob]

If you had the Report Generation Toolkit for Microsoft Office, you could create a real Excel spreadsheet file.  The Labview primitives Write to and Read from Spreadsheet file only create and read text files where the data is delimited by a tab (default) or whatever else you want to use (comma is popular).  However there is usually much confusion because Excel will open a tab delimited or comma separated variable (.csv) file and make it look like an xls file.  So which one do you want?  txt, csv, or xls?  The only advantages to a real xls file is the cell formatting and workbook pages.

[Ms. Temi]

Hi Tinnitus,

Yes I mean an xls (excel file). I have attached a word document that has the section of code that I am having trouble with and explains more in detail what I will like to accomplish.

Thank  you, I appreciate your assistance.

Temi

[muks]

First dont use a doc to show the screen shot. You can directly attach the image in jpg or png. You can use a write to spread sheet directly to create a excel file but again this is not native excel. You have to use activex or report generation toolkit to create a excel file.

[aeastet]

You can use a csv file. MS Excel knows how to open this file. If you are not ging to put graphs and need multipule tabs then csv is fast and easier to use. You can still open the file in MS Excel just like an XLS file.

[DavidRodz · Accepted solution]

Hello Ms. Temi,

When you use a write to spreadsheet module, it automatically creates the file and replaces it by default.  If you want to append to the spreadsheet file then you have to input a boolean variable below the module on "append?". 

So you dont need to create the file and then do the write spreadsheet since it only wants the path for the file like: "C:\ Documents and Settings\ User\ Desktop\ spread.txt"

Another way you can do is to write on the path the extension .xls and the icon and everything will run as a excel spreadsheet.

-David

[muks]

This will create the excel file with the random numbers

[Ms. Temi]

Thank you! I got it now

[Ms. Temi]

Thanks!