How to export/import changed data
Once you compile your excel spreadsheet, it creates an application (EXE File) with the possibility to export/import changed data for the application.
The Export/Import of changed data is only allowed if the EXE application was compiled with the “Allow Export/Import” option on.
For example, when the compiled application ‘Sample.exe’ runs, the following menu appears on Excel:
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 changed data.
- Export Data : By clicking on the ‘Export Data’ menu, the windows standard save dialog will appear. 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 is different from the original application data. For the EXE application the export option only works for the changed data. If you want to export non-changed data, just copy/cut and paste the data over.
- Export Collected Data: This item works same way as Export Data with exception that it exports all changes that were made and collected since the launch of the EXE file.
If a cell was modified more than once during this time then the latest value will be exported.
- Import Data: By 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 the cells. If you would like to see the imported values on a different background or in a different font color, you may choose the colors you want before importing.
If you would like to import data into the 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 the active workbook.
Please note that the data in the cells where the data is being imported into will be overwritten.
If you would like to import the data into an EXE application, then please go the Excel main menu ->DoneEx ->Application name ->Import Data.