AnsweredAssumed Answered

Import an excel file with multiple worksheets

Question asked by dougw on May 11, 2017
Latest reply on May 11, 2017 by philmodjunk

I know this was ask before but not recently so I'm wondering if anyone has developed a solution since.


I'm using FM Advanced 15 on a Windows 7 computer.

I need to import an excel document with the potential for 30 or more worksheets.

Each worksheet has the exact same layout.

I will be getting these documents on a regular basis


I've created a simple script to import the excel spread sheet (with dialog on), starting at worksheet 1 within a loop and manually select the next worksheet each time the script loops around. 

It does work this way but it's tedious and mind numbing with the potential for importing the same worksheet twice or missing one altogether.


I'm just looking for a way to automate the entire process so that each worksheet is imported in the sequence they are in the excel document.