LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

listbox data to .csv file by using write to spreadsheet File.vi

Solved!
Go to solution

Hi, I am using the Write to Spreadsheet File.vi to write Multicolumn ListBox data to the .csv file.If I do save as from Excel, the pop-up window shows as attachment. And listbox data looks different too.  I want the data displays as the first row not the second row (the third picture).

 

Thank you for your help.

 

 

Download All
0 Kudos
Message 1 of 6
(3,451 Views)

I'm not exactly understanding your desired display.

 

You've got the right pieces in your diagram except it looks like you're missing the listbox reference which should be wired into your property node.

 

Can you elaborate on your questions and/or difficulties?

Message 2 of 6
(3,422 Views)

Thank you for your reply.

The working code is actually not having the missing listbox reference problem.

I want to display all data as the first row look (display all numbers, not just 2.00E+51). However, if I opent he .csv file and save as a different name. It gives the look below. I do not know how to fix it.

number.PNG

 

Thank you,

0 Kudos
Message 3 of 6
(3,418 Views)

Can you post your CSV before Excel gets a handle on it and then after?

I'm pretty sure it's Excel converting your hex number to scientific notiation and then writing scientific notation back to the CSV.

 

You can edit the display in Excel to make sure it's the correct format before doing your Save As.

 

Do you really need Excel? You may be better off staying with CSV files and leave Excel out of it.

0 Kudos
Message 4 of 6
(3,413 Views)

I don't really need Excel. I just want to open the .csv file and check data. It gives me the look with some scientific notation numbers and some regular numbers.

Here is the look before opened  by Excel.

before.PNG

 

Here is the after look

after.PNG

 

Thanks,

 

0 Kudos
Message 5 of 6
(3,398 Views)
Solution
Accepted by llx

Before doing your Save As in Excel, Change the cell formatting to Number. This should avoid the conversion to scientific notation prior to resave.

 

Or just use Notepad to view the file instead of Excel.

0 Kudos
Message 6 of 6
(3,385 Views)