LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

I can't transfer data properly to Excel 2003 with the report generation toolkit.

I have a table with number to transfer into Excel. I use EasyGraph.vi and it works correctly with Excel 2000. But when I try the same program to transfer my data into Excel 2003, the data are not transfered correctly. When I have for example 0,56, it is read as text in Excel and when I have something like 53,300 Excel 2003 read this 53 300 as if there was no coma.
Do you know what's happening with Excel 2003 ?
0 Kudos
Message 1 of 4
(2,849 Views)
I have had similar problems with an app I developed. Excel 2003 seems to have some MAJOR differences, even from 2002. I found that I had to replace 2003 with 2002 to get the cell references to work properly. I probably could have searched for an updated driver ( I was using an Active-X control written for 2000), but I already had 2002 on hand, and it did the trick for me.
Good Luck

Dave
0 Kudos
Message 2 of 4
(2,826 Views)
Separators have always been a pain in Excel !
A work around is to avoid using any separator at all, and to format numbers as power of 10.
For instance :
0.12345 -> 12345E-5
12.345 -> 12345E-3
The attached vi does the trick.
Chilly Charly    (aka CC)
0 Kudos
Message 3 of 4
(2,818 Views)
Thank you for the trick.
0 Kudos
Message 4 of 4
(2,805 Views)