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

Certified Associate Developer

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 ?

  Discussion posts and replies are publicly visible