I want to copy multiple sheets from a single excel file. I am able to use multiple readexcel files, but it seems slow. I am guessing this is becuase it is initiating a COM connection each time it reads a new sheet.
I am thinking it may be more efficient to create an excel workbook object as shown below, then read and write each sheet. This way the COM connetion is only made once. However, I can not think of a way to move the data from the excel sheet to a Plant Sim tablefile.
Is there a method to do this? If so, shouldn't this be a faster method?
you can access all methods and attributes of the Excel- COM object to read the data e.g.
for var i:=1 to y loop
for var k:=1 to z loop
freelance simulation specialist
I imagine this would be a slow soution as well. Within excel I can copy a range to a range, which is fairly effcient. But since I am copying a range within excel to a PlantSim table this is not available.