ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage functions / Standard functions / XLS file functions
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Determines if a cell is merged with other cells and gets the merged cell range.
Example
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".
Component: wd290xls.dll
Minimum version required
  • Version 28
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 04/06/2023

Send a report | Local help