I'd like to import the Excel file and extract the data that I want to use in the new Excel file

[mingjuno]

I'd like to import the Excel file and extract the data that I want to use in the new Excel file

[RavensFan]

Please attach a VI that uses English characters and not Japanese/Chinese.  We can't open VI's that use those characters.

Did you look at the Report Generation Toolkit for opening an Excel file?

[mingjuno]

Upload again

[RavensFan]

That's better.  I can open that file.

I see you found how to open an existing file. Now you just need to do that process again opening another Excel file, and then WRITING the data into that new file.

[Bob_Schor · Accepted solution]

Your question has two parts:

1. Open and read data from an existing Excel Workbook, extracting data from the Workbook for use in another (different) Excel Report.
2. Create a New Report, using data obtained in Step 1.

There are several examples that ship with LabVIEW that discuss Step 2.  If you open this Forum and search for "Revised Excel Example", you will find a reasonably-complete example that may be easier to follow.

To do Step 1, you create a New Report, but put the path to the Excel File you wish to read as the "Template" input for the New Report.  You can now use Excel Get Data to extract data from the current WorkSheet.  Once you have the data you will need for Step 2, do a Dispose Report to close Excel, then do another New Report as part of Step 2.

Bob Schor