The
xlsColumn type is used to describe and modify a column in an Excel document. The characteristics of this column can be defined and modified using different WLanguage properties.
Remark: For more details on the declaration of this type of variable and the use of WLanguage properties, see
Declaring a variable.
// Open an Excel file.
sExcelFile is string
sExcelFile = fSelect("", "", "Select an Excel file...", ...
"Excel" + TAB + "*.xlsx" + CR + "All files (*.*)" + TAB + "*.*", "*.xlsx")
IF sExcelFile = "" THEN RETURN
// Open the Excel document.
MyDocument is xlsDocument
MyDocument = xlsOpen(sExcelFile)
// Cell by default.
Cell is xlsCell
Cell.BackgroundColor = LightRed
// xlsColumn variable
Column is xlsColumn
Column.Width = 200
Column.DefaultColumn = Cell
// The Column variable is used by column 2 of the document.
MyDocument..Column[2] = Column
// Saves the modifications.
xlsSave(MyDocument)
xlsClose(MyDocument)
Remarks
Properties specific to the description of xlsColumn variables
The following properties can be used to handle an xlsColumn variable:
| | |
| Name | Type used | Effect |
|---|
| Cell | Array of xlsCell | Cells of the column. |
| DefaultCell | xlsCell | The default style of the column will correspond to the style of the specified cell. |
| Width | Real | Width of column in pixels (between 0 and 1789 pixels). If this property is initialized to -1, the default width of the columns in the Excel document will be used. |