How to Read Only Specific Columns from Excel Using readexcelsheetpaging?

Hi Community,

I am working on an Appian process where I need to read data from an Excel file using the readexcelsheetpaging function. My Excel sheet (sheet 0) contains many columns, but for my use case, I only need to read two specific columns: ENTITY_ID and BENCHMARK_TYPE. These columns are not always in the same position—they might move if the template changes.

Currently, I am using the following code to read the first 6 columns, since I know my required columns are within those:

local!headerSheet: readexcelsheetpaging(
excelDocument: ri!importDocumentId,
sheetNumber: 0,
pagingInfo: a!pagingInfo(1, cons!AOM_READ_EXCEL_MAX_COLUMNS),
numberOfColumns: 6,
password: null,
stopReadingAtFirstBlankRow: false
).data,
However, this approach is not ideal because:
  • It still reads unnecessary columns if my required columns are not always in the first 6.
  • If the column order changes, I might miss the columns I need or read too many.

My question:
Is there a way in Appian to use readexcelsheetpaging (or any other function) to read only specific columns by name (e.g., ENTITY_ID and BENCHMARK_TYPE), regardless of their position in the Excel sheet?
If not, what is the best practice for efficiently extracting only the needed columns from a sheet with many columns, especially if the order can change?

Any advice or workarounds would be greatly appreciated!

Thank you!


  Discussion posts and replies are publicly visible