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?

Participating Frequently

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.

Participating Frequently

pls find the code, i am using batchsize -1

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

Participating Frequently

It does not support page size -1 try passing 10

Sign up