xlsMergeCell (Function) In french: xlsMergeCell Merges the specified cells into an Excel Document.
MonDocumentXLS is xlsDocument
// Fusionne les cellules du rectangle défini par B2 en haut-gauche et D4 en bas-droite
xlsMergeCell(MonDocumentXLS, "B2", "D4")
Syntax
Merge several cells: range of cells identified by their rows and columns Hide the details
<Result> = xlsMergeCell(<Document Excel> , <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> = xlsMergeCell(<Document Excel> , <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. |
This page is also available for…
|
|
|
|