Skip to main content
October 16, 2024
Question

Not getting correct value from excelreadcellsbynumber

  • October 16, 2024
  • 1 reply
  • 0 views

Hi,

I'm using excelreadcellsbynumber to read excel file

excelreadcellsbynumber(
excelDoc: ri!template,
sheetNumbers: {1} ,
columnNumbers: { 7 },
rowNumbers: {7,8,9,10}
)

it returned null value from row 8, 9, 10,  which is not correct

Because when I use readexcelsheetpaging, it returned the correct values

readexcelsheetpaging(
ri!template,
0,
a!pagingInfo(1,100),
8,
"",
0
),

    1 reply

    shanmathip7466
    October 23, 2024

    Hi,

    I tried with two functions it is returning data as expected. Could you please verify the template used is same for two functions?