LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

How to write data to excel in specified format?

Hello.

I am using activex to write data array to excel worksheet. Data format is string. Is it possible to specify data format (text, number, time...) in cells using activex?

0 Kudos
Message 1 of 4
(3,865 Views)

BPS,

 

Yes you can.   This snippet uses a mix of the Report Generation toolkit and ActiveX to format a column of timestamps.  Just modify the 'format string' to meet your needs.

 

 

Message 2 of 4
(3,845 Views)

Can you attach the VI file please??...am new to labView and i dont recognise a few blocks

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

The VI is attached. It's a 'Snippet' (look it up in the help). And, each VI has its name shown. Use the search button on the functions palette.

Message 4 of 4
(3,658 Views)