PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
  • 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/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
xlsRow (Type of variable)
In french: xlsLigne (Type de variable)
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 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
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
// 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)

// Character font.
MyFont is Font
MyFont..Name = "Arial"
MyFont..Size = 12
MyFont..Bold = True
MyFont..Color = White

// Cell by default.
MyDefaultCell is xlsCell
MyDefaultCell.BackgroundColor = DarkGreen
MyDefaultCell.Font = MyFont

// xlsRow variable.
MyRow is xlsRow
MyRow..Height = 200
MyRow..DefaultCell = MyDefaultCell

// All the cell on row 2 have
// the characteristics of the cell (color, size, font, etc.)
MyDocument..Row[2] = MyRow

// Saves the modifications.
xlsSave(MyDocument)
xlsClose(MyDocument)
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.
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