From 04:00 PM CDT – 08:00 PM CDT (09:00 PM UTC – 01:00 AM UTC) Tuesday, April 16, 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: 

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
(2,783 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
(2,779 Views)

Hi

 

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

 

thanks

 

0 Kudos
Message 3 of 4
(2,776 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
(2,768 Views)