PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
  • Properties specific to the description of xlsColumn variables
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
xlsColumn (Type of variable)
In french: xlsColonne (Type de variable)
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 by several WLanguage properties.
This type of variable is used by the xlsDocument type.
Remark: See Declaring a variable for more details on the declaration of this type of variable and the use of WLanguage properties.
Versions 16 and later
Linux This type of variable is now available in WINDEV Linux.
WEBDEV - Server codeLinux This type of variable is now available in WEBDEV Linux.
New in version 16
Linux This type of variable is now available in WINDEV Linux.
WEBDEV - Server codeLinux This type of variable is now available in WEBDEV Linux.
Linux This type of variable is now available in WINDEV Linux.
WEBDEV - Server codeLinux This type of variable is now available in WEBDEV Linux.
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 the description of xlsColumn variables

The following properties can be used to handle an xlsColumn variable:
NameType usedEffect
CellArray of xlsCellCells of the column.
DefaultCellxlsCellThe default style of the column will correspond to the style of the specified cell.
WidthRealWidth 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.
Remark: These properties can be used with one of the following syntaxes:
  • <Variable name>..<Property name>
  • <Variable name>.<Property name>
Minimum version required
  • Version 14
This page is also available for…
Comments
Click [Add] to post a comment