when trying to upload a template with 500 lines of data the readexcelsheet function was calling in interface to read those 500 lines in that only first 250 lines was fetching the function other 250 was not reading tried providing paging info too but still same only first 250 lines was reading
Could you please confirm what could be the reason for this issue
Discussion posts and replies are publicly visible
It's strange to see this issue.Have you tried using the readExcelSheetPaging function instead?
Also, validate your Excel tool plugin version, as major changes have recently happened to this plugin.
Thank you for details Yes tried using readExcelSheetPaging but getting below error could you please suggest on this and sure will check plugin version too
Looks like error you got at apn_isblank --> As you already doing .data so result.values are not required you can directly reference local!extractedData.values as output is datasubset.Have you tried readexcelsheetpaging in blank rule to check output?Make sure sheet number value should be 0 as it starts from 0 instead of 1(if you are reading 1st sheet).also remove startRow parameter
yeah it was 0 only and removed startRow parameter but getting conversion error like above shared snip
I edited my earlier response.Verify once.Looks like error you got at apn_isblank --> As you already doing .data so result.values are not required you can reference local!extractedData.values as output is datasubset.Have you tried readexcelsheetpaging in blank rule to check output?
Thank you!! Yeah got to see thank you and sorry that time i didn't able to see yes tried in blank rule it was returning output as list of variant now after correcting as you suggested getting again conversion error like below
Can you show me output of readexcelsheetpaging in blank rule?
sure please find the same Output Data was returning blank though there was valid data in uploaded template
Data is null here.Can you share the same output using readexcelsheet smart service?
yes please find the same can see the data