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

Parents Reply Children
No Data