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.