Insert Row(s) Node

I

Data/Excel

Insert Row(s)

Insert one or more rows into a worksheet

files_spreadsheet_insert_rowdata

Inputs7

Outputs4

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

Row

Integer

row

1-based target row index

Default 1

Position

String

position

Insert before or after the target row

Default before

beforeafter

Count

Integer

num_rows

How many rows to insert

Default 1

Adjust References

Boolean

adjust_references

Adjust formulas across workbook

Default true

Output Pins

4

Done

Execution

exec_out

Continue on success

Inserted

Boolean

inserted

Whether rows were inserted

Final Row Index

Integer

final_row_index

1-based row index used

Total Inserted

Integer

total_rows_inserted

How many rows were inserted

Node Info

Internal name

files_spreadsheet_insert_row

Category

Data/Excel