From 04:00 PM CDT – 08:00 PM CDT (09:00 PM UTC – 01:00 AM UTC) Tuesday, April 16, will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.


Showing results for 
Search instead for 
Did you mean: 

How to write data to excel in specified format?


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



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

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

0 Kudos
Message 3 of 4

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