Skip to main content
R
rakshnaj
February 9, 2021
Question

Question on reading the total no.of sheets in excel

  • February 9, 2021
  • 5 replies
  • 0 views

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

    5 replies

    dhananjayk
    dhananjayk
    February 9, 2021

    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

    R
    rakshnajAuthor
    February 10, 2021

    Hi DhananjayK,

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

    dhananjayk
    dhananjayk
    February 10, 2021

    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.

    Terms & ConditionsAccessibility statement