PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

  • Overview
  • Performing an export
  • Programming
  • Name of export file
  • Avoiding proposing an export
  • Running an export
  • Modifying the caption of the option
  • Securing the exports
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Overview
You want to perform simulations with Excel, Word, Open Office, ...? Nothing's easier. All you have to do is "export" the control content to the relevant software. The corresponding file is automatically created from the content of the exported control and it can be immediately used by another software.
The controls proposing this option are as follows:
  • Table and treeview table.
  • TreeView.
  • Looper.
  • Pivot table (to Excel only).
Performing an export
To perform an export to Excel, Word, ...:
  1. Display the popup menu of the table and select "Export the table to...".
    Versions 22 and later
    Note: If the option is followed by a padlock or a star, a password is requested before performing the export.
    New in version 22
    Note: If the option is followed by a padlock or a star, a password is requested before performing the export.
    Note: If the option is followed by a padlock or a star, a password is requested before performing the export.
  2. Specify the name of Excel file to create as well as its location.
  3. The application proposes to directly open the created file.
Notes :
  • If the file already exists, you can overwrite the existing file or merge it with the file currently created. The merge operation allows you to keep all the modifications performed (for example, for an Excel file, format of cells, formulas, ...).
  • The "High-precision numeric" columns (with 38 significant digits) are exported to Excel as exponential numbers.
Programming

Name of export file

By default, the suggested file name corresponds to the caption of the Table control. This name can be modified by programming with ..Caption.
For example:
// In order for the file proposed to export to be "ExportStat2016"
TABLE_MyTable..Caption = "ExportStat2016"

Avoiding proposing an export

To avoid proposing an export in a Table, TreeView Table, TreeView or Looper control, all you have to do is use AAFDisable (or DisableAAF):
  • with the aafTableToExcel constant to disable the export menu to Excel.
  • with the aafTableToWord constant to disable the export menu to Word.
  • with the aafTableToXML constant to disable the export menu to XML.
The corresponding menus options will not be displayed anymore.

Running an export

To perform an export by programming for a Table, TreeView Table, TreeView or Looper control, all you have to do is use AAFExecute (or ExecuteAAF):
  • with the aafTableToExcel constant to export the control content to Excel.
  • with the aafTableToWord constant to export the control content to Word.
  • with the aafTableToXML constant to export the control content to XML.

Modifying the caption of the option

Versions 21 and later
The caption of the menu option allowing the user to export the control content is "Export to Excel", "Export to Word", "Export to XML", ... To modify this caption, use AAFChangeCaption:
  • with the aafTableToExcel constant to modify the export option to Excel.
  • with the aafTableToWord constant to disable the export option to Word.
  • with the aafTableToXML constant to disable the export option to XML.
New in version 21
The caption of the menu option allowing the user to export the control content is "Export to Excel", "Export to Word", "Export to XML", ... To modify this caption, use AAFChangeCaption:
  • with the aafTableToExcel constant to modify the export option to Excel.
  • with the aafTableToWord constant to disable the export option to Word.
  • with the aafTableToXML constant to disable the export option to XML.
The caption of the menu option allowing the user to export the control content is "Export to Excel", "Export to Word", "Export to XML", ... To modify this caption, use AAFChangeCaption:
  • with the aafTableToExcel constant to modify the export option to Excel.
  • with the aafTableToWord constant to disable the export option to Word.
  • with the aafTableToXML constant to disable the export option to XML.
Versions 22 and later

Securing the exports

The data displayed in the Table, TreeView Table, TreeView or Looper controls can be exported. If confidential data is displayed in these controls, you can:
  • forbid the export. In this case, the corresponding option is not proposed.
  • ask for a password. In this case:
    • a padlock (or a star '*') is displayed in the corresponding menu option.
    • a window asking for a password is displayed before performing the action. If the password is invalid, the action is not performed.
To secure the exports performed via the popup menu found in the Table, TreeView Table, TreeView or Looper controls, use AAFExportSecurity.
New in version 22

Securing the exports

The data displayed in the Table, TreeView Table, TreeView or Looper controls can be exported. If confidential data is displayed in these controls, you can:
  • forbid the export. In this case, the corresponding option is not proposed.
  • ask for a password. In this case:
    • a padlock (or a star '*') is displayed in the corresponding menu option.
    • a window asking for a password is displayed before performing the action. If the password is invalid, the action is not performed.
To secure the exports performed via the popup menu found in the Table, TreeView Table, TreeView or Looper controls, use AAFExportSecurity.

Securing the exports

The data displayed in the Table, TreeView Table, TreeView or Looper controls can be exported. If confidential data is displayed in these controls, you can:
  • forbid the export. In this case, the corresponding option is not proposed.
  • ask for a password. In this case:
    • a padlock (or a star '*') is displayed in the corresponding menu option.
    • a window asking for a password is displayed before performing the action. If the password is invalid, the action is not performed.
To secure the exports performed via the popup menu found in the Table, TreeView Table, TreeView or Looper controls, use AAFExportSecurity.
Minimum required version
  • Version 9
Comments
Click [Add] to post a comment