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