How to export/import changed data
Once you compile your excel file, it creates an application (executable – EXE File) with the possibility to export/import changed data for the application.
The Export/Import of changed data is allowed if the EXE application was compiled with “Allow Export/Import” option on.
For example, when the compiled application ‘Sample.exe’ runs, the following menu appears in Excel 2003.
in Excel 2007 or higher, the following menu appears:
Please note that the ‘Export Data’ item is grayed. It will be activated as soon as any data is changed on spreadsheet because the option allows to export only the changed data.
- Export Data : By clicking on the ‘Export Data’ menu, the windows standard save dialog will appear. You have to type a file name in order to export. The export file will be in binary format with the .dat extension. The file contains only the data, which was changed in the cells manually or from vba code during the current work session. For the EXE application, the export option only works for the changed data. If you want to export the non-changed data, just copy/cut and paste exactly at the same place for that data.
- Export Collected Data: This item works same way as Export Data, except that it exports all changes that were made and collected since the beginning of the use of the EXE file.
If one cell during this time was modified more than once, then the latest value will be exported.
- Import Data: On clicking the ‘Import Data’ menu, the following dialog will appear:
Select the file you want to import into your application and it will import the values into cells. If you would like to see the imported values on a different background or font color, you may choose the colors before importing.
If you would like to import data into original xls file then go to the Excel main menu ->DoneEx ->XCell Compiler -> Load external data
In this case the data will be imported into an active workbook.
Important note: The data in in the cells where the imported data is placed will be rewritten.
If you would like to import data into the EXE application then please go to the Excel main menu ->DoneEx ->Application name ->Import Data