LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

export table to excel

Hi

 

plesae see example that I send , its export data from table to excel file and save the excel file in c:

 

the main problem I have number with 20 digit and other number with 15 digit , when I save and open in using excel the number look as

 

8.9972E+19 and other number is 3.596e+14

 

I need to see the number in full format as its look in the table

 

89972010311041561435

359628040266996

 

how can I do that

 

Thanks 

 

 

 

 

Download All
0 Kudos
Message 1 of 4
(3,042 Views)
Without looking at the code and excel file, it sounds like the formatting of the cells within excel.

If you right click the cell and select format, you can change the format of the number
0 Kudos
Message 2 of 4
(3,038 Views)

Hi

 

I want to do it in labview code , is there option that way

 

thanks

 

0 Kudos
Message 3 of 4
(3,035 Views)

@Elyan_wisam wrote:

Hi

 

I want to do it in labview code , is there option that way

 

thanks

 


Sure there is a way. Learn ActiveX. There are examples that ship with LabVIEW.

You'll need to read the relevant sections of the Excel Developer Reference for the version of Excel you have.

I have linked to Excel 2013 version http://msdn.microsoft.com/en-us/library/office/ee861528%28v=office.15%29.aspx

 

0 Kudos
Message 4 of 4
(3,027 Views)