ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage functions / Standard functions / XLS file functions
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Determines if a cell is merged with other cells and gets the merged cell range.
New in version 2025
Android This function is now available for Android applications.
Android Widget This function is now available in Android widget mode.
iPhone/iPad This function is now available for iPhone/iPad applications.
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: "<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".
Component: wd300xls.dll
Minimum version required
  • Version 28
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 11/20/2024

Send a report | Local help