As you can see from the error in the image, I am currently reading a csv file instead of an Excel file in the Read range section.
・What I’m doing now
I created a variable called ExcelWk in the output of external Excel application scope.
And then, I write ExcelWk.GetSheets(0) at sheet information in Read Range. However, it failed.
・What I want to do
I would like to reference Excel file. so is there any way to read an Excel file opened with an external Excel application scope?
・Why not use dataTable?
Initially, I used the internal Excel Application Scope to get all the CSV data, and then I wrote the data into Excel. However, since the amount of data to be imported was huge and an error occurred in the middle of the process. So I am now using the method of opening the csv files one by one and writing them to Excel.