From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.

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,392 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,369 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)

         E-List Master - Kudos glutton - Press the yellow button on the left...
        
0 Kudos
Message 3 of 4
(2,361 Views)
Thank you for the trick.
0 Kudos
Message 4 of 4
(2,348 Views)