how to know number of last spreadsheet???

Mar 4, 2012 at 1:38 PM
Edited Mar 4, 2012 at 3:19 PM


First, sorry for my English.

I wonder, how I can know, how many worksheets are in an Excel file. In another project in which I use another script had a function to know, but now we are using xlsx, and don´t know how to tell the script where is the last worksheet.

Thank you ..

Mar 4, 2012 at 8:39 PM

will return the number of worksheets: sheets are numbered from 0 onwards


will return an array of the sheet names, you could also count() that.




Mar 5, 2012 at 6:46 PM
Edited Mar 5, 2012 at 6:47 PM

Thank you very much. I'll try.

Greetings ..