readexcelsheetpaging plug returns empty data when row 1 is blank

Hi everyone,

To avoid ambiguity: my input is an excel document. The relevant sheet is the first sheet (index 0). In that sheet, the first row is completely empty, and the header starts on row 2 (e.g., A2, B2, …).

When I try to read the data with readExcelSheetPaging(), Appian seems to interpret the sheet as empty and I get:

List of Variant - 0 items

Example Code:

a!localVariables(
local!excelData: readexcelsheetpaging(
excelDocument: ri!excelInputFile,
sheetNumber: 0,
pagingInfo: a!pagingInfo(
startIndex: 2,
batchSize: 10
),
stopReadingAtFirstBlankRow: 0
),
local!excelData.data
)

What I have tried so far:

• Using the remove() function to remove the first row does not help. The empty row is removed but Appian still returns 0 row, interpretating the sheet as empty.
• If I modify the respective excel Input file sheet and put any dummy value in "A1", then the exact expression works as expected and returns data from row 2 onwards. In that case, removing/skipping the header row also works as expected.

My suspicion: 

It seems like the plug in readExcelSheetPaging() cannot handle a sheet where the first row is completely blank, even if startIndex is set to 2 and stopReadingAtFirstBlankRow is disabled.

Has anyone encountered this behavior? Is this a known limitation? Did I miss anything?

I would highly appreciate your feedback.