Hi Everyone,
Is there any direct way to fetch the total no.of worksheets uploaded in the excel document and also what is the maximum limit of sheets that can be read in appian
Thanks,
Rakshna JG
Discussion posts and replies are publicly visible
Hi RakshnajWe 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 below1. sheetNumber: from which sheet system should read excel2. startRow: The row to start reading from where 0 is the first row3. 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,
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.