Question

readexcelsheetpaging() is not retrieving any data

Hi,

I am trying to use readexcelsheetpaging(), it shows totalCount value but not retrieving any data

*note: the excel is generated using export to excel smart service

what may be the issue, is there any work around?

Hi, can you please share the screen shot of the code as this must be because of paging you must be passing -1 as batch size.

pls find the code, i am using batchsize -1

readexcelsheetpaging(
ri!doc,
0,
a!pagingInfo(1,-1)
)

It does not support page size -1 try passing 10

Sign up