AutoFit
Changes the width of the columns or the height of the rows in the range to achieve the best fit.
Syntax
expression.AutoFit(bRows, bCols);
expression - A variable that represents a ApiRange class.
Parameters
| Name | Required/Optional | Data type | Default | Description |
|---|---|---|---|---|
| bRows | Optional | boolean | Specifies if the width of the columns will be autofit. | |
| bCols | Optional | boolean | Specifies if the height of the rows will be autofit. |
Returns
This method doesn't return any data.
Example
This example changes the width of the columns or the height of the rows in the range to achieve the best fit.
- Code
- Result
// How to set an autofit for width or height for a range.
// Get a range and apply autofit property.
let worksheet = Api.GetActiveSheet();
let range = worksheet.GetRange("A1");
range.SetValue("This is an example of the column width autofit.");
range.AutoFit(false, true);