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,862 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,842 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,671 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,655 Views)