Skip to main content
S
saurabhr0005
October 31, 2023
Question

Bug in readexcelsheetpaging plug-in

  • October 31, 2023
  • 9 replies
  • 0 views

Hi,

This is mainly for the Appian team.

I just noticed there is a bug in this plug-in. The moment it comes across a blank row, it treats it as the end of file.

For eg, if rows 1-100 have data in any of the columns and row 101 is completely blank and 102-1000 rows have data in any column again, it only processes data from  1-100 and ignores the data in 102-1000.

This seems to be a bug because previous versions would read from rows 1 to 1000.

What can be done to resolve this?

9 replies

stefanhelzle0001
stefanhelzle0001
October 31, 2023

PEBKAC (Problem Exists Between Keyboard And Chair) ;-)

    S
    saurabhr0005Author
    October 31, 2023

    it returned totalCount as 65 even though the file has 10001 rows (66th row blank) even after giving stopReadingAtFirstBlankRow as 0 (it doesn't accept false or true as input but wants integer format even though the documentation help says boolean)

    What value should we give to not stop at blank row?

    stefanhelzle0001
    stefanhelzle0001
    October 31, 2023

    I am not sure that this plugin supports keyword syntax. I suggest to provide all parameters in the exact order.

      Terms & ConditionsAccessibility statement