|
|
|
|
xlsGetMerge (Function) In french: xlsRécupèreFusion Determines if a cell is merged with other cells and gets the merged cell range.
MyXLSDocument is xlsDocument sMerge is string = xlsGetMerge(MyXLSDocument, "B1") IF sMerge = "" THEN Info("No merge") ELSE sMin is string = ExtractString(sMerge, 1, ":") sMax is string = ExtractString(sMerge, 2, ":") Info("Merge between " + sMin + " and " + sMax) END
Syntax
Getting the merged cell range containing a cell identified by row and column Hide the details
<Result> = xlsGetMerge(<Excel document> , <Cell row> , <Cell column>)
<Result>: Character string - Empty string ("") if the specified cell is not merged,
- Merged cell range in the following format: "<Name top left cell>:<Name bottom right cell>".
For example: "A2:C5".
<Excel document>: xlsDocument variable Name of the variable of type xlsDocument to be used. <Cell row>: Integer Row number of the specified cell. <Cell column>: Integer Column number of the specified cell.
Getting the merged cell range containing a cell identified by its name Hide the details
<Result> = xlsGetMerge(<Excel document> , <Cell>)
<Result>: Character string - Empty string ("") if the specified cell is not merged,
- Merged cell range in the following format: "<Name top left cell>:<Name bottom right cell>".
For example: "A2:C5"
<Excel document>: xlsDocument variable Name of the variable of type xlsDocument to be used. <Cell>: Character string Name of the cell to be used. For example: "A4".
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|