Skip to main content
Known Participant
Oct 16, 2024 3:44 AM UTC
Question

Not getting correct value from excelreadcellsbynumber

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
    Inspiring
    Oct 23, 2024 9:38 PM UTC

    Hi,

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