04-07-2015 01:23 AM
i have generated some 8000numeric values using whileloop, i need to save these values in excel i.e all values in a single column and 8000rows.
04-07-2015 03:51 AM
Instead of saving that data using Excel (requires .NET or ActiveX!) i recommend you to save the data in a spreadsheet format.
Excel can be configured to use spreadsheets very easily, so you can import the data very fast.
Note that this recommendation is valid for "small" files only (somehwere less than 100MB). For more data, you shouldn't use ASCII based files.....
Norbert
04-07-2015 04:24 AM
thankyou for the reply. i have tried out spreadsheet (wrie to spreadsheet)option in labview, but after running the program the file in which the data is stored is not opening, getting (file format error).
04-07-2015 04:29 AM
Can you post your VI?
It sounds like an atypical file corruption....
Norbert
04-07-2015 04:40 AM
In this code, after initialising the values in an array i need to save these valus in an excel sheet for further processing.
04-07-2015 04:52 AM
This VI does not create a spreadsheet file.
In your VI, you never use the "Save to File" function from the Office Report Generation Toolkit. Also, you split the report to add different stuff which seems to be invalid (serialize it using the wire!).
The approach i suggested is simply to use "Write SpreadSheet File" and pass the numeric data as 2D array to it....
Norbert
04-07-2015 04:59 AM
Here i have used write to spreadsheet icon, but im getting an error (file extension)
04-07-2015 05:46 AM
What are you using for a file name? My guess is that you are trying to save it with an xls or xlsx extension. You cannot do that since the Write To Spreadsheet File cannot save data in the Microsoft's propriatary format used for xls ans xlsx files. Use txt for your extension. Excel will still open it up just fine.