Skip to main content
D
dharanik2600
July 7, 2025
Question

readexcelsheet function was taking only first 250 columns in uploaded template

  • July 7, 2025
  • 14 replies
  • 0 views

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

14 replies

shubhama926776
shubhama926776
July 7, 2025

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.

D
dharanik2600Author
July 7, 2025

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

shubhama926776
shubhama926776
July 7, 2025

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

Terms & ConditionsAccessibility statement