We are currently performing maintenance on Appian Community. As a result, discussions posts and replies are temporarily unavailable. We appreciate your patience.
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 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.