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.
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: 03/02/2023

Send a report | Local help