Name
xlsx.SetColumnWidth -- set column width
Synopsis
xlsx.SetColumnWidth(id, col, width[, sheet])
Function
This function sets the width of the column specified in col to width. Column indices start at 1. The width is specified in font units of the normal display font and can be a fractional value. Optionally, you can also pass the index of the worksheet to use in the optional sheet parameter (starting from 1 for the first worksheet). If the sheet parameter is omitted, the worksheet set by xlsx.SetDefaultSheet() will be used.

Inputs
id
identifier of the XLSX document to use
col
column index to use (starting from 1)
width
desired column width in font units
sheet
optional: index of the worksheet to use (defaults to the index of the default worksheet)
Example
xlsx.SetColumnWidth(1, 1, 8.43)
The code above sets the width of the first column to 8.43.

Show TOC