Question

How can I skip blank rows when reading excel sheet

The excel sheet contains some blank rows to divide the sections which I can't change, how can I skip these blank rows when reading from excel sheet.

I see this readexcelsheet() function in other post seems it can decide which row to start, is it deprecated?

Hello [mention:2aea1bf0b6954f94815518e79da990c7:e9ed411860ed4f2ba0265705b8793d05]

This is my excel sheet

When I use readExcelSheet() function it returns blank rows.

When I use readExcelimportfile() function it does not return the blank rows.

Can you use readExcelimportfile() function in your case it may help.

Thank you, but I can't find these functions in my Appian, I only have this

Hi [mention:2aea1bf0b6954f94815518e79da990c7:e9ed411860ed4f2ba0265705b8793d05] use this plug-in

Sign up