Cancel
Showing results for 
Search instead for 
Did you mean: 

Read excel file

Experimenter
Experimenter

Hello,

 

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!

3 REPLIES 3

Re: Read excel file

Legend
Legend

Hello!

 

It's possible to do that by using the ActiveX object. I think this requires the interface package though.

Re: Read excel file

Experimenter
Experimenter

Thanks! Unfortunately I don't have access to the interface package. Is there no other way to do this?

Re: Read excel file

Experimenter
Experimenter

Solved it with createCOMObject!