Question on reading the total no.of sheets in excel

Hi Rakshnaj

We have readexcelsheet function. It does not have any sheet count limitation but if you have more sheets it takes time to return results and lag is easily visible.

However, it has parameters as below
1. sheetNumber: from which sheet system should read excel
2. startRow: The row to start reading from where 0 is the first row
3. numberOfColumns: The number of columns to read. Leave blank (or use 0) to auto-detect the number of columns.
4. password: Optional: The Excel documents password

Hi Rakshnaj

We have readexcelsheet function. It does not have any sheet count limitation but if you have more sheets it takes time to return results and lag is easily visible.

However, it has parameters as below
1. sheetNumber: from which sheet system should read excel
2. startRow: The row to start reading from where 0 is the first row
3. numberOfColumns: The number of columns to read. Leave blank (or use 0) to auto-detect the number of columns.
4. password: Optional: The Excel documents password

Hi DhananjayK,

Thanks for your reply, Is there any direct way to read the total no.of sheets used in the excel document.

I don't think so.  If your use case is to just count the number of sheets then you need to look for some other plugin.

Hi Rakshnaj,

Can u let me know what are the limitations of readexcelsheet(). Like max file size, max column or rows or any ther limits. And how to verify the columns as well?

Hi saahilm,

readexcelsheet() does not have any limitations on rows/columns/file size.