Help / WLanguage / WLanguage functions / Standard functions / XLS file functions
  • Properties specific to xlsRow variables
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WindowsLinuxPHPWEBDEV - Browser code
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Stored procedures
xlsRow (Variable type)
In french: xlsLigne
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: For more details on the declaration of this type of variable and the use of WLanguage properties, see Declaring a variable.
New in version SaaS
Android This type of variable is now available for Android applications.
Android Widget This type of variable is now available in Android widget mode.
iPhone/iPad This type of variable is now available for iPhone/iPad applications.
// 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.

Properties specific to 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…
Click [Add] to post a comment

Last update: 06/06/2024

Send a report | Local help