Insert Column(s) Node

I

Data/Excel

Insert Column(s)

Insert one or more columns into a worksheet

files_spreadsheet_insert_columndata

Inputs7

Outputs5

Security exposure10/10

Packagedata

Ratings

Scores range from 0 to 10. Higher values mean more impact, exposure, or operational weight.

No score metadata has been set for this node yet.

Input Pins

7

Input

Execution

exec_in

Trigger

File

Struct

file

The .xlsx file to modify

SchemaFlowPathFlowPathFlowPath3 fields

pathstringrequired

store_refstringrequired

cache_store_refstring | null

Schema enforced

Sheet Name

String

sheet_name

Target worksheet name

Default Sheet1

Column

String

column

Target column (letter like 'B' or index like '2')

Default A

Position

String

position

Insert before or after the target column

Default before

beforeafter

Count

Integer

num_columns

How many columns to insert

Default 1

Adjust References

Boolean

adjust_references

Adjust formulas across workbook

Default true

Output Pins

5

Done

Execution

exec_out

Continue on success

Inserted

Boolean

inserted

Whether columns were inserted

Final Index

Integer

final_column_index

1-based column index used

Final Letter

String

final_column_letter

Excel letter for final index

Total Inserted

Integer

total_columns_inserted

How many columns were inserted

Node Info

Internal name

files_spreadsheet_insert_column

Category

Data/Excel