Right-click Context Menu of the column(s): Column Width
Set width of worksheet columns
wcolwidth irng:=[Book1]Sheet1!Col(3) width:=20;
Please refer to the page for additional option switches when accessing the x-function from script
| Display Name |
Variable Name |
I/O and Type |
Default Value |
Description |
|---|---|---|---|---|
| Column(s) | irng |
Input Range |
|
Specify the column(s). |
| Width | width |
Input double |
|
Specify the column width. The value is the ratio with respect to the default font width, which means a value 7 for wcolwidth means that you can display 7 characters of system default font in a column of default width. |
This function is used to update the width of the columns in the worksheet.