Skip to main content
amritjyotiv3475
November 18, 2022
Question

fn!readexcelsheetpaging() functions doesn't able to Load Excel File having 358 columns and 12000 rows of data

  • November 18, 2022
  • 0 replies
  • 0 views

Hi All,

We have a Use Case in which we need to do the excel header validation for the Excel File which is having 358 columns and 12000 rows of data.

When we tried to execute the below code:

fn!readexcelsheetpaging(
exceldocument: ri!excelFile,
sheetNumber: 0,
numberOfColumns: 358,
paginginfo:a!pagingInfo(
startIndex: 1,
batchSize: 1,
sort: null
)

Output : It is not returning any data for 12000 rows, however it is working for max 8000 rows in excel file.

Do anyone has faced same issue or error ?