Online Documentation for Advanced Data Export for RAD Studio VCL

Version history

Full version history is available at https://www.sqlmanager.net/products/tools/advancedexport/news

 

         Version 4.17

• Support for RAD Studio 11 Alexandria added.
• The Captions option published for TQExport4SQL to change column names in SQL script.

 

         Version 4.16

• Support for RAD Studio 10.4 Sydney implemented.
• Invalid characters are not allowed in result files now.
• Margins can be now customized in TQExport4Xlsx and TQExport4Docx components.
• Data can be exported without calling the dialog using the TQExport4Dialog.Execute (const ConfigFileName: string) method.
• The XLSX file couldn't be opened if SheetName property contained spaces. Fixed now.
• Redundant attributes removed from the pageSetup tag in the XLSX result file.
• The 'Could not convert variant of type (Null) into type (OleStr)' error fixed for exporting TQuery data containing NULL values into XLS.
• Configuration files are now loaded faster.
• End of support for RAD Studio 2009 and older versions.
• Other improvements and bugfixes.

 

            Version 4.15

• Implemented support of RAD Studio 10.3 Rio.
• Encoding for XML files has been added.
• The error occurred on exporting data into XLSX with custom export source and AutoCalcColWidth property set to True. Fixed now.
• Invalid XLS file structure was created with AutoCalcColWidth property set to True. Fixed now.
• XLS. The error occurred if Sheets property contained only one element. Fixed now.
• XLS. Temporary files were created in the application folder, which resulted in access errors in some cases. Fixed now.
• DoExport method didn’t work correctly if more than 65536 rows were processed. Fixed now.
• Headers and footers for print page in XLS were not displayed correctly. Fixed now.
• EDatabaseError exception occurred on executing the TCustomSQLDataSet.GetRecordCount method. Fixed now.
• Custom values for ThousandSeparator property were not saved in the configuration file. Fixed now.
• ODS. Date and time values were not exported correctly. Fixed now.
• Many other improvements and fixes.

         Version 4.14.1

• Support of RAD Studio 10.2 Tokyo added.
• The possibility to set a start topic of the help file in the TQExport4Dialog.HelpTopic property added.
• The TXlsFieldFormat.Width property did not work. Fixed now.
• Some other small bug fixes.

 

 Version 4.14

• Support for 64-bit Windows target platform has been added.
• Support for Unicode configuration files added.
• Now it is possible to export data into XLSX files, containing Unicode symbols in names.
• ODS and ODT files with Unicode symbols, generated by the component, were opened with MS Excel and MS Word with errors. Fixed now.
• Now all components except for TADO_QExport4Access and TQExport4DBF export BLOB and binary data as Base64 and HEX strings.
• Now you can set column width in ColumnWidths property of the TQExport4XLS component with TqeCustomSource4 as source and no fields defined.
• AutoCalcColWidth property is now applied correctly in XLS files.
• XLSX files were opened with errors if data cell styles were changed in OnGetDataParams event handler. Fixed now.
• The Access violation error occurred on getting size and precision for TFmtBCDField field types. Fixed now.
• Now the formatting strings for TXlsxCellStyle.NumericFormat property in TQExport4Xlsx component create new styles in the document correctly.
• The errors occurred in TQExport4ODS and TQExport4ODT components on exporting data without adding any style settings. Fixed now.
• Many other fixes and improvements.

 

 Version 4.13.2

• RAD Studio 10.1 Berlin support added
• A few installation errors have been fixed

 

 Version 4.13

• The possibility of exporting string data as hyperlinks has been added.
• The possibility of formatting TBCDField field values as Currency field type has been implemented.
• All 64-bit Integer values with more than 18 digits were converted to Float type with exponential notation. Fixed now.
• Errors on 64-bit run-time QExport4RT_C23.cbproj package compilation have been fixed.
• String height is now adjusted to cell font and data size.
• The invalid byte was added after every line break when exporting to TXT, CSV, DIF, SYLK. Fixed now.
• Integer overflow error has been fixed.
• Images are exported to XLS correctly now.
• The "Cannot load package 'QEXport4RT_C11' error has been fixed.
• The "Not enough timers available" error when using the components inside of IntraWeb application has been fixed.
• Now the 'Destination Directory' value is correctly saved to the template.
• The Database Home list was empty in some cases for Oracle server. Fixed now.
• Now '0000-00-00' zero date is exported correctly from MySQL server.
• Other minor improvements and bugfixes.

 

 Version 4.12

• Added support of RAD Studio 10 Seattle
• There were double fields count when going back to the first step in ImportWizard. Fixed now.
• Fields mapping was cleared on loading template, even if there were no changes in fields information. Fixed now.
• Some graphic artefacts in ImportWizard in Win64 build. Fixed now.

 

 Version 4.11

• RAD Studio XE8 support implemented.
• Export to XLS. Ability to set page properties for the printed page has been implemented.
• Export to PDF. The AutoBreakString property is renamed to BreakString. The way it works has been changed.
• The LoadPropertiesFromStream and SavePropertiesToStream methods have been added.
• Export to Access. Microsoft.ACE.OLEDB.15.0 support is added.
• Multiple bugs related to decimal separator setting have been fixed.
• Export to PDF. The line breaks in MEMO-fields were deleted. Fixed now.

 

 Version 4.10

• Support of RAD Studio XE5 is added.
• QExport4XML. Added export to MS Access XML format files.
• QExportDocx. Added BLOB fields export.
• Other improvements and bug fixes.

 

 Version 4.9

• Added support of Embarcadero RAD Studio XE4.

• Added the possibility to append date/time to the exported file name. The AppendDateTimeToFileName and AppendDateTimeToDatabaseName (TADO_QExport4Access) properties. Use the ExportedFileName and ExportedDatabaseName (TADO_QExport4Access) properties to get the name of the file to which the export is performed.
• QExport4SQL. Added the possibility to generate a single INSERT statement. The MultipleInsert property.
• TQExport4XML. Now the BLOB filed data is uploaded using base64 encoding. (For Delphi 2005/CBuilder 2006 versions and older).
• QExport4XLS. Now the exported data can be splitted into Excel worksheets by the specified number of rows. The SplitByRows property.
• When changing delimiters in the Formats property, the delimiters in the corresponding format masks are changed automatically.
• QExport4XLS. Now when trying to export more than 255 columns, an error message occurs.
• QExport4XLS. Fixed the errors of the format mask usage.
• If format masks correspond to system masks, they were not saved in the *.dfm file. Fixed now.
• When removing a delimiter in the Formats property, it was replaced by #0 in the corresponding format masks. Fixed now.
• QExport4DBF. While exporting the TWideMemoField fields were recorded in the *.dbt file in Unicode. Fixed now.
• QExport4SQL. When unloading currency data types, a currency symbol was added to the values. Fixed now.
• Other improvements and bug fixes.

 

 Version 4.8

• QExport4Xlsx. Added the RightToLeftExcelMode property. If RightToLeftExcelMode = True, opening the exported file makes Excel switch to the 'Right to Left' display mode.
• QExport4Xlsx. Now string data with non-printable characters (characters with codes up to # 31) are exported correctly.
• QExport4Xlsx. The values of Date/Time fields were exported as numbers. Fixed now.
• Now all fields, including Blob fields, are exported by default.
• QExport4Dialog. Now it is impossible to export, if none of the fields are selected.
• QExport4ASCII. The Null character was added to the end of each row. Fixed now.
• QExport4ASCII. Export to CSV. The format mask was not applied to real numeric values. Fixed now.
• QExport4ASCII. Export to CSV. The column width is now calculated only for the fields, where the field width is not specified.
• QExport4ASCII. Export to CSV. The export of multibyte characters caused the error. Fixed now.
• QExport4ASCII. Now column width parameters are read from a configuration file correctly.
• QExport4XLS. Values were formatted incorrectly. Fixed now.
• QExport4XLS. The format masks for standard styles were modified while being exported. Fixed now.

 

 Version 4.7

1. QExport4XLS:

• Added the Aggregates property. This collection allows to define aggregate functions for the range of cells.
• The row height settings were not applied. Fixed now.
• The images stretched along the width of data output. Fixed now.

2. TQExport4ASCII:

• Added the TrimCaptionsToDataLength property. When TrimCaptionsToDataLength=True, the caption width will be aligned along the data columns width.

• When DataSet=nil and AutoCalcColWidth=True, the data export caused the error. Fixed now.

3. TQExport4Xlsx.

• In the designer the editor of the StripStylesLis properties could not be called. Fixed now.
• The font settings were not applied. Fixed now.
• When processing OnGetDataParams, the resulting file was created incorrectly. Fixed now.

4. QExport4XLS. TQExport4Xlsx. A number of properties were not saved in the configuration file. Fixed now.
5. TQExport4DBF. When using a Chinese locale, the file was created incorrectly. Fixed now.
6. XML-Based. The data export caused the error. Fixed now.
7. In OnGetExportText the values for null-fields could not be overridden. Fixed now.
8. Other improvements and bug fixes.

 

 Version 4.6

• Added support of Embarcadero RAD Studio XE2.

 

 Version 4.5

• Added the support of MS Access 2007. When the FileVersion property of the TADO_QExport4Access component is equal to afvAccess2007, the export is performed to the MS Access 2007 format.
• TQExport4Xlsx. Now it is possible to set a view of each cell individually using the new OnGetDataParams event.
• TQExport4Xlsx. Added the possibility to determine and set the columns width automatically. The new AutoCalcColWidth property is responsible for this.
• TQExport4Xlsx. The data formatting could not be applied. Fixed now.
• TQExport4Xlsx. Values of the Formats and UserFormats properties were not saved in the configuration file. Fixed now.
• TQExport4Xls. When opening a file with multiple sheets, generated by the component, the cells actions (sorting, filtering, etc.) became inaccessible in Excel. Fixed now.
• TQExport4Xls. In some cases the data export caused the program hang-up. Fixed now.
• TQExport4Dialog. When exporting to MS Access, the "Print file after export" and "Open file after export" options did not work (it was not possible to open and print the file). Fixed now.
• ADO_QExport4Access. When PrintFile=True and ShowFile=True, the ACCESS process remained in the process list after the export is finished. Fixed now.
• Some other improvements and bugfixes.

 

 Version 4.4

• QExport4XLS. The possibility to automatically add new sheets when exporting more than 65536 lines is added.AutoAddSheet property is responsible for this. When AutoAddSheet = True, the new sheets are added automatically. When AutoAddSheet = False - upon reaching the maximum number of the lines the error message on the sheet appears.
• QExport4XLS. The AutoTruncateValue property is added. If the value of more than 32767 symbols is inserted in the cell, the length of the line will be truncated automatically to the enabled when AutoTruncateValue = True. When AutoTruncateValue = False, the error message "String too large" will appear.
• QExport4Dialog. The ability to Drag and Drop fields to the specified position is added. The field was added to the end of the list before.
• When exporting the value over 4110 symbols to Excel the file did not open. Fixed now.
• QExport4Dialog. The error of exporting the empty sheets to PDF occurred when setting the PDFOptions->PageOptions->Units = unMillimeter property. Fixed.
• The error "Index of bounds" occurred with the null Map property. Fixed now.
• QExport4XLS. The error preventing the column width automated setting is fixed.
• QExport4XLS. The error of the line breaking is fixed.
• QExport4XLS. The error causing the application hanging occurred at the following conditions:

the export is set for several sheets;

on one or several sheets the property Exported = False;

Fixed now.

• Other small improvements and bugfixes.

 

 Version 4.3

• The support of Embarcadero RAD Studio XE is added.
• QExport4XLS. The "Out of Memory" error occurred when modifying the Options->FooterFormat->Color property. Fixed now.
• QExport4XLS. The "Data may have been lost" error occurred when exporting data using the AddStringCell function. Fixed now.
• QExport4. The formatting of the Currency type did not work for Docx and XML formats. Fixed now.
• A compile error occurred when compiling the QXMLWriter.pas file in Delphi5. Fixed now.
• Export4Xlsx. If the CustomSource data source contained columns with the String data type, they were not exported. Fixed now.
• QExport4Xlsx. Null values for the DateTime fields were exported as 0. Fixed now.
• QExport4Xlsx. The component didn’t run under Windows Vista OS. Fixed now.
• QEXport4XLS. Added a new event handler - OnAdvancedGetExportData.
• TQExport4Dialog. The ExportType property is added.
• Added three demo projects for С++ Builder 2010.
• The installer now creates shortcuts for demo and help files.
• Some other improvements and bugfixes.

 

 Version 4.2

• RAD Studio 2010 support is added.
• Portuguese Brazilian, Turkish, Spanish and Dutch localizations are added.
• When exporting to XLSX, the integer and float types are exported as numeric.
• It is now possible to display DisplayLabel instead of FiledName for exported fields in the TQExport4Dialog.
• Memory leaks are eliminated.
• Errors connected with strip styles occurred when exporting data to DOCX and XLSX. Fixed now.
• Resolved the type naming conflict which occurred when compiling component packages in C++ Builder.
• Other small improvements and bug fixes.

 

 Version 4.1

• Support of RAD Studio 2009 is added
• Minor improvements and bug-fixes

 

 Version 4.0

• Four new data export components have been added:

QExport4Xlsx component allows you to export data to the MS Excel 2007 sheets

QExport4Docx component allows you to export data to the MS Word 2007 tables

QExport4ODS component allows you to export data to the OpenDocument Spreadsheet files (Open Document Format)

QExport4ODT component allows you to export data to the OpenDocument Text files (Open Document Format)

• Unicode support: now you are able to export Unicode data (UTF-8, UTF-16/UCS-2, UTF-32/UCS-4)
• Now you can select Data Packet or Access as a document type (TQExportXMLType = (xtDatapacket2, xtAccess)) for the QExport4XML component
• Due to the new installer the components will be installed and registered in Delphi\C++ Builder environment automatically
• Support of BDS 2006, RAD Studio 2007, Delphi 2007 and C++ Builder 2007 is added
• Other minor improvements and bug-fixes

Scroll to top

---