From 11:00 PM CDT Friday, Nov 8 - 2:30 PM CDT Saturday, Nov 9, 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: 

writing tdms data to an excel template

Hi,

 

I have a VI that is acquiring data from DAQ card and writing to a TDMS file. But I want to write this TDMS data to a table I have in an excel template. 

The tdms data I have is two columns of data (around 5000 points in each column).

 

Is there any way I can write tdms data to a specific column in excel file?


Thanks in advance

0 Kudos
Message 1 of 4
(2,667 Views)

Yes there is! I haven't really used all these myself, but have a look at the pallette at: Programming -> Report Generation -> Excel Specific

 

I think you are looking for the Excel Easy Table, which lets you write data to a specified location in the excel file.

Best regards,

Jarle Ekanger, MSc, PhD, CLD
Flow Design Bureau AS

- "The resistance of wires in LabVIEW is not dependent on their length."
0 Kudos
Message 2 of 4
(2,642 Views)

Hi,

Here are some links on the report generation toolkit: http://www.ni.com/white-paper/3178/en/

http://digital.ni.com/public.nsf/allkb/EFCE1C25DCE7483E86256CAF00539451

Example code: http://www.ni.com/example/28177/en/

 

Also, very useful... look at the EXCEL examples in LabVIEW that ship with the Report Generation toolkit. Go to help, find examples -> search for Excel.

You will find some examples related to templates.

 

 

Tanim
National Instruments
0 Kudos
Message 3 of 4
(2,613 Views)

@manny09 wrote:

Hi,

 

I have a VI that is acquiring data from DAQ card and writing to a TDMS file. But I want to write this TDMS data to a table I have in an excel template. 

The tdms data I have is two columns of data (around 5000 points in each column).

 

Is there any way I can write tdms data to a specific column in excel file?


Thanks in advance


OK Lets get you back on track since some posters today aren't reading very well.

 

You have a TDMS file AND an Excel Template AND the TDMS Import Addon  The TDMS Import configuration utility does offer some latitude on what gets imported where.  You will need to play with the file and template to see if you can achieve what you want without adjusting the template


"Should be" isn't "Is" -Jay
0 Kudos
Message 4 of 4
(2,599 Views)