PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
  • Other functions linked to Excel
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
The following functions are used to manage XLS files:
xlsAddWorksheetAdds or inserts a new worksheet into an Excel document.
xlsCloseCloses an XLS file.
xlsColumnTitleRetrieves the title of a column found in an XLS file.
xlsColumnTypeReturns the type of data entered in a column of an XLS file.
xlsCoordinatesToNameRetrieves the name of a cell, XLS worksheet or Spreadsheet control according to its coordinates.
xlsCurrentWorksheetUsed to find out and modify the current worksheet in an XLS file.
xlsDataRetrieves the content of a cell found in an XLS file.
xlsDeleteWorksheetDeletes a worksheet from the Excel document.
xlsMsgErrorReturns the caption of the last error caused by an XLS function.
xlsNameToCoordinatesReturns the coordinates of a cell, XLS file or spreadsheet control according to its name.
xlsNbColumnReturns the number of columns found in a worksheet of an XLS file.
xlsNbColumnsxlsNbColumns is kept for backward compatibility only.
xlsNbRowReturns the number of rows found in an XLS file.
xlsNbRowsxlsNbRows is kept for backward compatibility only.
xlsNbWorksheetReturns the number of worksheets found in an XLS file.
xlsOpenOpens an Excel file (xls or xlsx files).
xlsSaveSaves an XLS document.
xlsVersionReturns the Excel version that was used to save the file.
Other functions linked to Excel
AAFDisableDisables the export of Table control content or content selection to Excel or to OpenOffice Calc (depending on the software installed on the user's computer).
AAFExecuteExports the content of Table control or the selection performed in the Table control to Excel or to OpenOffice Calc (depending on the software installed in the user computer).
HImportXLSImports an XLS file into a data file in HFSQL Classic or Client/Server format (data file described in the data model editor or declared by HDeclare, HDeclareExternal or HDescribeFile).
LooperToExcelCreates an Excel file with data from a Looper control (based on a data file or populated programmatically).
TableToExcelCreates an Excel file with the data from a Table or TreeView Table control (based on a data file or populated programmatically).
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment