Is it possible to load all worksheets of an excelfile into separate tablefiles by SimTalk, without knowning the number of worksheets?
Currently I can only load a worksheet from an excelfile when I know the exact name of the worksheet as:
tablefile.readExcelFile("excel filename","worksheet name")
In PS when you open a tablefile and import an excelfile, PS shows a dialog with all the worksheets of which you can select one. I want to loop through the number of worksheets and load them into separate tablefiles.
Thanks in advance!
Solved! Go to Solution.