|
|
|
|
|
|
|
|
|
|
<xlsDocument variable>.GetMerge (Function) In french: <Variable xlsDocument>.RécupèreFusion Determines if a cell is merged with other cells and gets the merged cell range. MyXLSDocument is xlsDocument
sMerge is string = MyXLSDocument.GetMerge("B1")
IF sMerge = "" THEN
Info("No merge")
ELSE
sMin is string = sMerge.ExtractString(1, ":")
sMax is string = sMerge.ExtractString(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> = <Excel document>.GetMerge(<Cell row> , <Cell column>)
<Result>: Character string - Empty string ("") if the specified cell is not merged,
- Merged cell range in the following format: "<Upper-left cell>:<Lower-right cell>"
where <Cell> has the following syntax: <Column letter><Row number>.
Example of cell range: "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> = <Excel document>.GetMerge(<Cell>)
<Result>: Character string - Empty string ("") if the specified cell is not merged,
- Merged cell range in the following format: "<Upper-left cell>:<Lower-right cell>"
where <Cell> has the following format: <Column letter><Row number>.
Example of cell range: "A2:C5".
<Excel document>: xlsDocument variable Name of the variable of type xlsDocument to be used. <Cell>: Character string Cell to be manipulated in the following format: <Column letter><Row number>. For example: "A4".
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|