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 xlsRow 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
xlsRow (Type of variable)
In french: xlsRow
The xlsRow type is used to describe and modify a row in an Excel document. The characteristics of this row 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)
 
// Police de caractères
MaPolice is Font
MaPolice.Name = "Arial"
MaPolice.Size = 12
MaPolice.Bold = True
MaPolice.Color = White
 
// Cellule par défaut
MaCelluleDéfaut is xlsCell
MaCelluleDéfaut.BackgroundColor = DarkGreen
MaCelluleDéfaut.Font = MaPolice
 
// Variable xlsLigne
MaLigne is xlsRow
MaLigne..Height = 200
MaLigne..DefaultCell = MaCelluleDéfaut
 
// Toutes les cellules de la ligne 2 ont
// les caractéristiques de la cellule (couleur, taille, police, ...)
MonDocument..Row[2] = MaLigne
 
// Sauvegarde les modifications.
xlsSave(MonDocument)
xlsClose(MonDocument)
Remarks

Properties specific to the description of xlsRow variables

The following properties can be used to handle an xlsRow variable:
NameType usedEffect
CellArray of xlsCellCells of the column.
DefaultCellxlsCellThe default style of the row will correspond to the style of the specified cell.
HeightDouble realHeight of row in pixels (between 0 and 545 pixels). If this property is initialized to -1, the default height of the rows 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