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.

New in version 2025

This function is now available for Android applications.

This function is now available in Android widget mode.

This function is now available for iPhone/iPad applications.

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