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.
Note: See Declaring a variable for more details.
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.
Note: 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