NI Home > Community > NI Discussion Forums
Reply
Member
NSTL
Posts: 30
0 Kudos

How to export wave form data to excel with specified location?

How to export wave form data in excel with specified location,

i.e. Specified column,

How it is possible?

Thank you.

Active Participant
ABCPrograms
Posts: 352
0 Kudos

Re: How to export wave form data to excel with specified location?

if I read this item and your previous item, then I guess you need an excel toolkit? :smileywink:

 

Can't you just use a *.csv file?  Or do you want to do your reporting in Excel as well.

 

Kind regards,

 

Bjorn

Kind regards,

- Bjorn -

Have fun using LabVIEW... and if you like my answer, please pay me back in Kudo's :smileywink:
LabVIEW 5.1 - LabVIEW 2012
Member
NSTL
Posts: 30
0 Kudos

Re: How to export wave form data to excel with specified location?

Thank you for immediate responding,

I want send wave form data with specified column..In excel sheet

i.e.  wave form data is 2 dimensional, For Example i want write data in 5 row Dth column onwards,

and 5 row Eth column...

How it is possible...?

Thank you.

Member
tsksesa
Posts: 81
0 Kudos

Re: How to export wave form data to excel with specified location?

 

The best way to do this is to use the office report generation generation toolkit

 

You will have to do some translation of the data in order to get it all lined up.  But I have found that with a little practace I can make vi's that are more useful than the best VB script with these vi's. 

Member
NSTL
Posts: 30
0 Kudos

Re: How to export wave form data to excel with specified location?

Without tool kit is it possible....?:smileywink:

Active Participant
SimonH
Posts: 306

Re: How to export wave form data to excel with specified location?

 


NSTL wrote:

Without tool kit is it possible....?:smileywink:


 

Yes, it's possible -- it's just not as easy as most things are in LabVIEW (which is why we created the Report Generation Toolkit).

 

 

You'll want to look into either the Excel ActiveX interface or the Microsoft.Office.Interop.Excel .NET assembly in order to automate Excel.  This code snippet is an example of using the .NET assembly to create a datatable and graph in Excel:

 

dotNET to Excel.png

 

If you have the Report Generation Toolkit you can get the same effect using the MS Office Report Express VI and your code would look like this:

 

Report Generation Toolkit Express to Excel.png

 

Good luck,

 

Simon