|
|
|
|
|
- Overview
- Performing an export
- Programming
- Name of export file
- Disabling the export option
- Running an export
- Modifying the option caption
- Securing the exports
FAA: Data export (Table field, Hierarchical Table, RepeatString, Tree, ...)
Would you like to run simulations in Excel, Word, LibreOffice, etc.? Nothing could be simpler. Simply "export" the control content to the desired software. The corresponding file is automatically created from the content of 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).
To perform an export to Excel, Word, ...: - Open the context menu of table and select "Export table to...".
Note: If the option is followed by a padlock or star, a password is requested before exporting. - Specify the name and location of the Excel file to be created.
- 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 being 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.
Name of export file By default, the suggested file name corresponds to the caption of the Table control. This name can be modified programmatically with the Caption property. For example:
TABLE_MyTable.Caption = "ExportStat2016"
Disabling the export option To disable the export option in a Table, TreeView Table, TreeView or Looper control, simply use AAFDisable: - 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 export data from a Table, TreeView Table, TreeView or Looper control through programming, simply use AAFExecute: - 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 option caption By default, the menu option allowing the user to export the field content is labelled "Export to Excel", "Export to Word", "Export to XML", ... To change this label, use the AAFChangeCaption function: - 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.
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 context menu found in the Table, TreeView Table, TreeView or Looper controls, use AAFExportSecurity.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|