Using the "readExcelFile" function and reading data takes a long time.
Reading a text file with the same amount of data with "readFile" function completes in a short time.
For example using same data :
readExcelFile ... 1 min 30 sec
readFile ... 0.2 seconds
What is the reason behind this behavior ?
Solution To read Excel files we use the COM-Interface of Excel i.e. we start Excel using COM and the use COM calls to read the cells of the sheet.
Since the COM-Interface of Excel is terribly slow this takes much longer than reading a plain text file.
So if possible we recommend to save the data in Excel as a CSV file and the read it as a text file into Plant Simulation.
Hardware/Software Configuration Platform: INTEL
OS Version: 764SP1