Skip to main content
October 15, 2024
Solved

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

  • October 15, 2024
  • 3 replies
  • 0 views

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()

    Best answer by mathieud0001

    readexcelsheetpaging should return the total count of rows.

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

    3 replies

    sebastiand8415
    October 15, 2024

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

    mathieud0001
    October 15, 2024

    readexcelsheetpaging should return the total count of rows.

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

    October 16, 2024

    Thanks