Number of sheets

Topics: Developer Forum, Project Management Forum, User Forum
Sep 17, 2012 at 3:35 PM

Hello everybody,

Just i little question. When i load an Excel file, Is it possible to know it number of sheets ?

Thank you

Sep 17, 2012 at 5:20 PM
Edited Sep 19, 2012 at 9:23 AM

There is a method called 'listWorksheetInfo' that will return a list of information about each sheet. Just count the array that is returned and that is the number worksheets in the file.

- Christopher Mullins

Sep 18, 2012 at 8:59 AM

Thank you very much!! it's exactly what i was looking for!!