ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

New WINDEV and WEBDEV 28 feature!
This content has been translated automatically.  Click here  to view the French version.
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Merges the specified cells into an Excel Document.
Example
MonDocumentXLS is xlsDocument
 
// Fusionne les cellules du rectangle défini par B2 en haut-gauche et D4 en bas-droite
xlsMergeCell(MonDocumentXLS, "B2", "D4")
Syntax

Merge several cells: range of cells identified by their rows and columns Hide the details

<Result> = xlsMergeCell(<Document Excel> , <Row start> , <Start column> , <End row> , <End column> [, <Type of merge>])
<Result>: Boolean
  • True if the cells have been merged,
  • False otherwise.
<Document Excel>: xlsDocument variable
Name of the variable of type xlsDocument to be used.
<Row start>: entier
row number of the cell at the top left of the range of cells to merge.
<Start column>: entier
Column number of the cell at the top left of the range of cells to be merged.
<End row>: entier
row number of the cell at the bottom right of the range of cells to merge.
<End column>: entier
Column number of the cell at the bottom right of the cell range to be merged.
<Type of merge>: Optional Integer constant
Type of merge to be performed:
xlsMergeAndCenter
(default value)
Merges the cells and centers the contents.
xlsMergeSimpleMerges the cells without centering the contents.

Merge several cells: range of cells identified by their names Hide the details

<Result> = xlsMergeCell(<Document Excel> , <Start cell> , <End cell> [, <Type of merge>])
<Result>: Boolean
  • True if the cells have been merged,
  • False otherwise.
<Document Excel>: xlsDocument variable
Name of the variable of type xlsDocument to be used.
<Start cell>: Character string
Name of the cell at the top left of the range of cells to be merged). This parameter has the following format: <Column letter><Row number>. For example: "A32".
<End cell>: Character string
Name of the cell at the bottom right of the range of cells to be merged). This parameter has the following format: <Column letter><Row number>. For example: "A32".
<Type of merge>: Optional Integer constant
Type of merge to be performed:
xlsMergeAndCenter
(default value)
Merges the cells and centers the contents.
xlsMergeSimpleMerges the cells without centering the contents.
Component: wd280xls.dll
Minimum version required
  • Version 28
This page is also available for…
Comments
Click [Add] to post a comment