ParseExcelCellReference 2025.5.31.15¶
Bundle¶
com.snowflake.openflow.runtime | runtime-office-nar
Description¶
Processor responsible for parsing Excel cell reference formula.
Input Requirement¶
REQUIRED
Supports Sensitive Dynamic Properties¶
false
Properties¶
Property |
Description |
|---|---|
Ranges |
The comma-separated Excel ranges to parse in the A1 notation. For example: Sheet1!A1:B2,Sheet2!D4:E5,Sheet3. Ranges in R1C1 and 3-D reference style are not allowed.The value can’t be empty. |
Relationships¶
Name |
Description |
|---|---|
failure |
FlowFile with errors occurred while parsing ranges. |
success |
FlowFile annotated with attributes containing parsed Excel range. For each range a separate FlowFile is produced. |
Writes attributes¶
Name |
Description |
|---|---|
range.formula |
Single range formula that was used to produce other attributes, e.g. Sheet1!A1:B2. |
range.sheetname |
Parsed sheet name. |
range.rows.starting |
Starting row (numbered from 1) of parsed range. |
range.rows.ending |
Ending row of parsed range. |
range.columns.starting |
Number of starting column of parsed range. |
range.columns.ending |
Number of ending column of parsed range. |