PC SOFT

ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE
New WINDEV and WEBDEV 28 feature!
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 in an Excel document.
Example
MyXLSDocument is xlsDocument
 
// Merges the cells from B2 at the top-left to D4 at the bottom-right
MyXLSDocument.MergeCell("B2", "D4")
Syntax

Merging a range of cells identified by their rows and columns Hide the details

<Result> = <Excel document>.MergeCell(<Start row> , <Start column> , <End row> , <End column> [, <Type of merge>])
<Result>: Boolean
  • True if the cells were merged,
  • False otherwise.
<Excel document>: xlsDocument variable
Name of the variable of type xlsDocument to be used.
<Start row>: Integer
Row number of the upper-left cell in the range of cells to merge.
<Start column>: Integer
Column number of the upper-left cell in the range of cells to merge.
<End row>: Integer
Row number of the lower-right cell in the range of cells to merge.
<End column>: Integer
Column number of the lower-right cell in the range of cells to merge.
<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.

Merging a range of cells identified by their names Hide the details

<Result> = <Excel document>.MergeCell(<Start cell> , <End cell> [, <Type of merge>])
<Result>: Boolean
  • True if the cells were merged,
  • False otherwise.
<Excel document>: xlsDocument variable
Name of the variable of type xlsDocument to be used.
<Start cell>: Character string
Name of the upper-left cell in the range of cells to merge. This parameter has the following syntax: <Column letter><Row number>. For example: "A32".
<End cell>: Character string
Name of the lower-right cell in the range of cells to merge. This parameter has the following syntax: <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
See also
Minimum version required
  • Version 28
This page is also available for…
Comments
Click [Add] to post a comment