You can import excel files directly into a tableFile in Plant Simulation (Tab File - Import). You don't need SimTalk for this.
For program it: see <tableFile>.readExcelFile.
I have been to work in a model and I use excel (to import) to read the database but this process is very slow, so Can you say me if I can use another software (like SLQ) or method to solve this problem or I just can use excel to export database?...
Thanks for you help!
There are several ways to import data. It depends on the number of data sets, you want to import.
You can use database-programs to import data. Plant Simulation offers a ODBC-interface. This you can use to send SQL statements to the database to read contents into tableFiles.
Or you export the data first from your data source to XML and read the XML-file in Plant Simulation.
But it is difficult to say, what variant is faster.
Excel needs to load all data into the memory. If you have a big data-set, you may run out of RAM capacity. The result is a very slow process (check it). In this case you need only more RAM to accelerate it.
So first how many data sets you need to import?
Thank you for you prompt answer, well I have to import from Excel 5 files but 2 of those have like 23 or more sheets.
So how can I do more quickly this process?
BTW I never have been used the ODBC-interface, can you explain me this process? or How can I make this?
Sorry for not to answer before, but the email was in spam hehe..
Well, I need read all the data at beginning only the first time, but if it has any change I have to re-load again.