|
|
|
|
|
|
|
|
<xlsDocument variable>.MergeCell (Function) In french: <Variable xlsDocument>.FusionneCellule Merges the specified cells in an Excel document. 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 row and column 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. | | xlsMergeSimple | Merges the cells without centering the contents. |
Merging a range of cells identified by name 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. | | xlsMergeSimple | Merges the cells without centering the contents. |
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|