PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Properties specific to the description of xlsCell 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
xlsCell (Type of variable)
In French: xlsCellule (Type de variable)
An xlsCell variable is used to describe and modify a cell in an Excel document.
This type of variable is used:
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.
Remarks

Properties specific to the description of xlsCell variables

The following properties can be used to handle an xlsCell variable:
NameType usedEffect
AlignmentHInteger constantHorizontal alignment of the cell. The possible values are as follows:
  • haCenter: centered.
  • haRight: right alignment.
  • haLeft: left alignment.
AlignmentVInteger constantVertical alignment of cell. The possible values are as follows:
  • vaTop: alignment at the top.
  • vaMiddle: alignment in the middle.
  • vaBottom: alignment at the bottom.
BorderBorder variableCharacteristics of cell border.
BrushColorInteger or Integer constantBackground color of cell. This color can correspond to:
MaskCharacter stringDisplay mask in Excel. This mask must correspond to the mask recognized by Excel. See the documentation about Excel for more details.
MaskWDCharacter stringDisplay mask in WINDEV or WEBDEV format that will be used in the Excel cell ("DD/MM/YYYY" for example). The specified mask is automatically converted into Excel format. The hundredths of a second found in the masks are not supported.
See Supported masks for more details.
This property is available in write mode.
MultilineBoolean
  • True if the cell is multiline,
  • False otherwise.
FontFont variableFont of cell.
TypeInteger constantExcel type of cell. The possible values are as follows:
  • xlsTypeString: "Character string" column or column containing different types of data.
  • xlsTypeDate: "Date" column.
  • xlsTypeDateTime: "DateTime" column.
  • xlsTypeDouble: "Numeric" column.
  • xlsTypeDuration: "Duration" column.
  • xlsTypeError: If an error occurs. To find out the error details, use xlsMsgError or ErrorInfo associated with the errMessage constant.
  • xlsTypeTime: "Time" column.
  • xlsTypeCurrency: "Currency" column.
This property is available in read-only.
ValueType of cell valueValue of the cell.
When defining the style of a column (xlsColumn.DefaultCell), this property is ignored in write mode and it is initialized empty in read mode).
Note: These properties can be used with one of the following syntaxes:
  • <Variable Name>..<Property Name>
  • <Variable Name>.<Property Name>
Related Examples:
XLS Type Unit examples (WINDEV): XLS Type
[ + ] Handling the xlsDocument, xlsColumn, xlsRow and xlsCell variables.
The purpose of this example is to explain how these types of variables can be easily handled.
Minimum required version
  • Version 14
This page is also available for…
Comments
Click [Add] to post a comment