xlsColumn (Variable type)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help / WLanguage / WLanguage functions / Standard functions / XLS file functions

Properties specific to xlsColumn variables

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

Declaring and using a variable

xlsColumn (Variable type)

In french: xlsColonne

The xlsColumn type is used to describe and modify a column in an Excel document. You can define and change the characteristics of this column using different WLanguage properties.

This type of variable is used by the xlsDocument type.

Note: For more details on the declaration of this type of variable and the use of WLanguage properties, see Declaring a variable.

Example

// 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 xlsColumn variables

The following properties can be used to handle xlsColumn variables:

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.