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 2024
WINDEVLinux This function is now available for WINDEV applications in Linux.
Windows This function is now available for WEBDEV websites in Windows.
Linux This function is now available for WEBDEV websites in Linux.
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: wd290xls.dll
Minimum version required
  • Version 20
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 02/28/2024

Send a report | Local help