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
xlsNameToCoordinates (Function)
In french: xlsNomVersCoordonnées
Returns the coordinates of a cell, XLS file or spreadsheet control according to its name.
New in version SaaS
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
CoordinateCellRow is int 
CoordinateCellRow = xlsNameToCoordinates("C1", xlsRowNum)
Syntax
<Result> = xlsNameToCoordinates(<Name> , <Type>)
<Result>: Integer
  • Sought coordinate.
  • Empty string if an error occurred (invalid coordinates).
<Name>: Character string
Name of the cell ("C1" for example).
<Type>: Integer constant
Type of coordinate to return:
xlsColumnNum<Result> will correspond to the column number.
xlsRowNum<Result> will correspond to the row number.
Business / UI classification: Business Logic
Component: wd300xls.dll
Minimum version required
  • Version 20
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 06/06/2024

Send a report | Local help