How Can I Transfer Data From One Excel File To Another Excel File ?

Updated Jul 2, 2018

Reported In

Software

  • LabVIEW

Issue Details

I want to get data from an Excel file to be able to process it with LabVIEW and after that save it to a report template that I had on Excel.

Solution

The following Snippet code can be used as a template to be able to subtract data from one excel file, process it and then save it in another Excel File.

Explanation:
New Report - Sets worksheet to work with.
Excel Get Data - Retrieves data from the current worksheet.
Dispose Report - Closes the report and release the interface.
Excel Easy Table - Inserts and formats the input data into an Excel Table.
Save Report to File - Saves the table into an Excel File.

Additional Information

It is important to know that in this example the data acquisition is only getting transpose and then send it back to a new file but it doesn't mean that you have to limit yourself to only do this you can custom the code as you want to perform the task you need to do with your data.

WAS THIS ARTICLE HELPFUL?

Not Helpful