xlsRow (Variable type)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help / WLanguage / WLanguage functions / Standard functions / XLS file functions

Properties specific to xlsRow variables

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

Declaring and using a variable

xlsRow (Variable type)

In french: xlsLigne

The xlsRow variable type defines and changes the characteristics of a row in an Excel document. You can define and change the characteristics of this row using different WLanguage properties.

This type of variable is used by the xlsDocument type.

Note: For more details on the declaration of this type of variable and the use of WLanguage properties, see Declaring a variable.

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)

Properties

Properties specific to xlsRow variables

The following properties can be used to define the characteristics of xlsRow variables:

Name	Type used	Effect

Cell	Array of xlsCell	Cells of the column.
DefaultCell	xlsCell	The default style of the row will correspond to the style of the specified cell.
Height	Double real	Row height 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.