xlsMergeCell (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

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

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

xlsMergeCell (Function)

In french: xlsFusionneCellule

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
xlsMergeCell(MyXLSDocument, "B2", "D4")

Syntax

Merging a range of cells identified by row and column Hide the details

<Result> = xlsMergeCell(<Excel document> , <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.
xlsMergeSimple Merges the cells without centering the contents.

Merging a range of cells identified by reference Hide the details

<Result> = xlsMergeCell(<Excel document> , <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

Upper-left cell in the range of cells to merge. This parameter has the following format: <Column letter><Row number>. For example: "A32".

<End cell>: Character string

Lower-right cell in the range of cells to merge. 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.
xlsMergeSimple Merges the cells without centering the contents.

Component: wd300xls.dll