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 | Required | bool | Specifies if the width of the columns will be autofit. | |
| bCols | Required | bool | 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.
var oWorksheet = Api.GetActiveSheet();
var oRange = oWorksheet.GetRange("A1");
oRange.SetValue("This is an example of the column width autofit.");
oRange.AutoFit(false, true);