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.
readexcelsheetpaging
ENTITY_ID
BENCHMARK_TYPE
Currently, I am using the following code to read the first 6 columns, since I know my required columns are within those:
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
Readexcelsheetpaging cannot directly read specific columns by name if their positions change. Best practice is to read a broad range including headers, find column indexes by header names dynamically, then extract needed columns by those indexes after reading.