Autofit Rows/Columns Activity
The Autofit Rows/Columns activity enables the automatic adjustment of row heights and column widths to accommodate the size of the data entries within an Excel worksheet. This function ensures that all content is fully visible and professionally formatted without manual resizing.
| Field | Description | Requirement |
|---|---|---|
| Excel name | The reference name of the Excel file that has been previously opened or created. | Required |
| Sheet name | The name of the specific worksheet to target. If omitted, the activity defaults to the first sheet. | Optional |
| Sheet index | The numerical index of the worksheet to target. If omitted, the activity defaults to the first sheet. | Optional |
| Rows | The specific row index or range to be adjusted, starting from 1. | Optional |
| Columns | The specific column name, index, or range to be adjusted, starting from 1. | Optional |
Action Types & Examples
Excel Reference
- Format: string
- Example Result: "newExcel"
Sheet Identification
- Format: string or integer
- Example Result: "Sheet1"
Range Specification
- Format: string or digit
- Example Result: "1:5"
Implementation Examples
Field Setup - Excel Name: ${newExcel} - Sheet Name: Sheet1 - Sheet Index: 5
Execution Parameters - Single Row: 1 - Row Range: 1:5 - Column Reference: A1 - Column Range: A1:B5 - Column Index: 1 - Column Index Range: 1:5
Technical Notes
The activity utilizes a 1-based indexing system for both rows and columns. If no specific rows or columns are defined, the autofit action may apply to the entire used range of the specified worksheet.