Skip to main content
simonj3483
June 11, 2021
Question

Excel tools 2.2.14- readexcelsheetpaging

  • June 11, 2021
  • 2 replies
  • 0 views

Hi,

tried using this tool and whilst totalRows is correct, it is returning no data.

fn!readexcelsheetpaging(
excelDocument: ri!spreadsheet,
sheetNumber: 5,
pagingInfo: a!pagingInfo(1,-1)
)

DataSubset

    • startIndex1(Number (Integer))
      • batchSize-1(Number (Integer))
        • sortList of SortInfo - 0 items
          • totalCount302(Number (Integer))
            • dataList of Variant - 0 items
              • identifiersList of Variant - 0 items

              Has anyone else seen this behaviour or explain what I am doing wrong?

                2 replies

                June 12, 2021

                Hi,

                Please change the batchsize to 100 or any max limit , then the function will return results

                Eg:a!paginginfo(1,100)

                simonj3483
                June 14, 2021

                Thanks Chandhinir, that has resolved the problem.