<Variable xlsDocument>.MergeCell (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help

WLanguage

WLanguage functions

Standard functions

XLS file handling functions

Prefix syntax

MergeCell

Presentation

Example

See also

MergeCell

UnmergeCell

Constants for managing XLS files

Handling XLS files

XLS file handling functions

XLSCell type: MaskWD property

xlsAddWorksheet

xlsCell

xlsClose (Example)

xlsClose

xlsColumn

xlsColumnTitle (Example)

xlsColumnTitle

xlsColumnType (Example)

xlsColumnType

xlsCoordinatesToName

xlsCurrentWorksheet

xlsData (Example)

xlsData

xlsDefuseCell

xlsDeleteWorksheet

xlsDocument (Example)

xlsDocument

xlsLayout

xlsMergeCell

xlsMsgError (Example)

xlsMsgError

xlsNameToCoordinates

xlsNbColumn (Example)

xlsNbColumn

xlsNbColumns

xlsNbRow (Example)

xlsNbRow

xlsNbRows

xlsNbWorksheet

xlsOpen (Example)

xlsOpen

xlsRow

xlsSave

xlsVersion (Example)

xlsVersion

New WINDEV and WEBDEV 28 feature!

This content has been translated automatically. Click here to view the French version.

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

<Variable xlsDocument>.MergeCell (Function)

In french: <xlsDocument Variable>.MergeCell

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
MonDocumentXLS.MergeCell("B2", "D4")

Syntax

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

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

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

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

Component: wd280xls.dll