LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

2D array to excel

Hi,

 

I collected the 2D array information of images from a camera, and write it to spreadsheet. How can I open the spread sheet in Excel? I tried to store, but the Excel just won't open correctly.

 

Thanks.

 

TH

0 Kudos
Message 1 of 4
(2,866 Views)
If you are using the Write to Spreadsheet, then you should know it does not create an excel file. It creates a text file with a delimiter that you can choose. The default is a tab. Saying the excel just won't open properly is a poor description. What exactly do you mean?
0 Kudos
Message 2 of 4
(2,856 Views)

One way is to convert the array of numbers as an array of strings (using Array to Spreadsheet string) and save into a txt file. Define a delimiter and use the same parameters when you read the file under excel.

 

 

RKO
0 Kudos
Message 3 of 4
(2,848 Views)
That is exactly what the Write to Spreadsheet does. Just look at the block diagram.
0 Kudos
Message 4 of 4
(2,845 Views)