origin_concat_worksheets
Concatenate worksheets by stacking rows aligned on column names or placing sheets side by side. Write results to a new sheet or update the primary sheet.
Instructions
Concatenate the primary worksheet with one or more others.
The primary worksheet is book_name/sheet_name; others is a list of {"book": ..., "sheet": ...}. axis="rows" stacks rows (a SQL UNION ALL, aligning by column name); axis="columns" places sheets side by side. Provide output_book/output_sheet to write to a new sheet instead of overwriting the primary worksheet.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| others | Yes | ||
| axis | No | rows | |
| book_name | No | ||
| sheet_name | No | ||
| output_book | No | ||
| output_sheet | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||