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: 

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,829 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,809 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,638 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,622 Views)