12-02-2014 06:40 PM
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
12-03-2014 01:17 AM
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.
12-03-2014 11:32 AM
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.
12-03-2014 03:42 PM
@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