Edit spreadsheets
edit_workbookOpen and modify spreadsheets: write values/formulas, find and replace, insert/delete rows and columns, sort, deduplicate, manage sheets, apply formats, charts, tables, PivotTables; saves new copies.
Instructions
Open workbooks (xlsx, xlsm, xls, xlsb, ods, csv, tsv; one, a list or a folder) and change them: write values and formulas, find and replace, insert or delete rows and columns, sort, remove duplicates, add, rename or delete sheets, apply formats, conditional formatting, tables, charts and PivotTables. Saved as new copies; the originals are only read.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sort | No | ||
| write | No | ||
| charts | No | ||
| pivots | No | ||
| suffix | No | _edited | |
| tables | No | ||
| formats | No | Cell formats (on `sheet`, default the first sheet). | |
| replace | No | ||
| input_dir | No | ||
| overwrite | No | Replace existing outputs. | |
| add_sheets | No | ||
| all_sheets | No | csv / tsv / pdf: write every sheet as its own file (<name>_<sheet>.csv) instead of only the first sheet. | |
| input_path | No | ||
| output_dir | No | Absolute output folder (default: next to the input; required for new files). | |
| input_paths | No | ||
| output_path | No | Absolute output file for the first format (its extension must match). | |
| rows_columns | No | ||
| delete_sheets | No | ||
| rename_sheets | No | ||
| output_formats | No | Outputs (default xlsx). | |
| remove_duplicates | No | ||
| conditional_formats | No |