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?
Discussion posts and replies are publicly visible
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
Thanks it works now
readexcelsheet( cons!UD_FILE_EXAMPLE_XLSX_10, /*document */ 0, 0 )
You can use the above code as well if you don't want to use the paging.
If it worked for you please accept the answer.