Skip to main content
Known Participant
Oct 15, 2024 9:55 AM UTC
Solved

How can I know the max row with content when reading excel?

Hi,

When I was reading an excel file uploaded by user, how can I identify the max row that has values?

Otherwise if I read to the row that has no values I'll get error, I'm using excelreadcellsbynumber()

    mathieud0001
    Genius
    Oct 15, 2024 9:01 PM UTC

    readexcelsheetpaging should return the total count of rows.

    community.appian.com/.../excel-tools-2-2-14--readexcelsheetpaging

    3 replies

    sebastiand8415
    Inspiring
    Oct 15, 2024 2:09 PM UTC

    Can you be a bit more specific? Also maybe you could use readExcelSheet() instead.

    mathieud0001
    Genius
    Oct 15, 2024 9:01 PM UTC

    readexcelsheetpaging should return the total count of rows.

    community.appian.com/.../excel-tools-2-2-14--readexcelsheetpaging

    Known Participant
    Oct 16, 2024 1:56 AM UTC

    Thanks