|
|
|
|
|
|
|
|
|
|
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: "<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> = xlsGetMerge(<Excel document> , <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…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|