PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
This content has been translated automatically. Click here to view the French version.
  • 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/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
xlsColumn (Type of variable)
In french: xlsColumn
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.
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
WINDEVLinux 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
WINDEVLinux This type of variable is now available in WINDEV Linux.
WEBDEV - Server codeLinux This type of variable is now available in WEBDEV Linux.
WINDEVLinux This type of variable is now available in WINDEV Linux.
WEBDEV - Server codeLinux This type of variable is now available in WEBDEV Linux.
Example
// Ouverture d'un fichier Excel.
sFichierExcel is string
sFichierExcel = fSelect("", "", "Sélectionnez un fichier Excel...", ...
"Excel" + TAB + "*.xlsx" + CR + "Tous les fichiers (*.*)" + TAB + "*.*", "*.xlsx")
IF sFichierExcel = "" THEN RETURN
 
// Ouverture du document Excel.
MonDocument is xlsDocument
MonDocument = xlsOpen(sFichierExcel)
 
// Cellule par défaut.
Cellule is xlsCell
Cellule.BackgroundColor = LightRed
 
// Variable xlsColonne
Colonne is xlsColumn
Colonne.Width = 200
Colonne.DefaultCell = Cellule
 
// La variable Colonne est utilisée pour la colonne 2 du document.
MonDocument..Column[2] = Colonne
 
// Sauvegarde les modifications.
xlsSave(MonDocument)
xlsClose(MonDocument)
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.
Minimum version required
  • Version 14
This page is also available for…
Comments
Click [Add] to post a comment