|
|
|
|
|
|
|
|
- Properties specific to the description of xlsRow variables
xlsRow (Type of variable) 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. Remark: For more details on the declaration of this type of variable and the use of WLanguage properties, see Declaring a variable.
// 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: | | | | 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 | Height 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. |
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|