Widen columns to fit their contents. Widths are estimated from the longest value rather than measured, and rows are handed back to Excel to fit when the file opens
Inputs
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
Excel Instance excelInstance | variable | Required | — | — |
Sheet Name sheetName | string | Optional | — | Leave empty for the first sheet |
Range range | string | Optional | — | Leave empty for everything on the sheet |
Fit target | enum | Optional | columns | —columnsrowsboth |
Minimum Width minWidth | number | Optional | 6 | — Shown when target = columns / both |
Maximum Width maxWidth | number | Optional | 80 | — Shown when target = columns / both |
Compatibility
WindowsLinuxAttendedUnattended
Related activities
Apply Conditional Formatting
Add a rule that keeps highlighting cells as the data changes, rather than colouring the ones that match today
Format as Table
Turn a range into a real Excel table with banded rows, filter arrows and a name formulas can use
Format Cells
Set fill, font, borders, alignment, number format and size on a range. Every field is optional and only the ones filled in are changed
Merge Cells
Join a range into one cell, or split a merged one back up. Safe to re-run
Add Row to Sheet
Add a row of values to the end of a sheet
Append Data to Sheet
Add many rows to the end of a sheet in one step. Use Add Row to Sheet for a single row