ems Advanced Data Export 4.1.0.1 Full sousce

{********************************************************} {* EMS Advanced Data Export Component Suite *} {* *} {* Copyright (C) 1999 - 2008 EMS Corporation *} {* *} {********************************************************} 03-12-2008 Version 4.1 1. Added CodeGear Studio 2009 support. 2. Some other improvements and bugfixes. 06-04-2008 Version 4.00 1. Four new data export components have been added: - QExport4Xlsx component allows you to export your data to the MS Excel 2007 sheets. - QExport4Docx component allows you to export your data to the MS Word 2007 tables. - QExport4ODS component allows you to export your data to the OpenDocument Spreadsheet files (Open Document Format). - QExport4ODT component allows you to export your data to the OpenDocument Text files (Open Document Format). 2. Unicode support. Now you are able to export Unicode data (UTF-8, UTF-16/UCS-2, UTF-32/UCS-4). 3. With a new installer the components will be installed and registered in Delphi\C++ Builder environment automatically. 4. Support of BDS 2007, Delphi 2007 and C++ Builder 2007 is added. 5. Now you can select Data Packet or Access as a document type (TQExportXMLType = (xtDatapacket2, xtAccess)) for the QExport4XML component. 6. Some other improvements and bugfixes. 05-05-2006 Version 3.40 1. Fixed the problem with extra delimiter symbols at the end of the header lines when exporting to CSV format. 2. Fixed the problem with extra delimiter symbols at the end of the record lines when exporting to Clipboard. 3. Fixed the bug that didn't allow setting the sheet height, scope and width when exporting to PDF format. 4. Fixed the bug that didn't allow saving the Width and Align property values to the template file when exporting to PDF format. 5. Fixed the bug that caused the following: when exporting memo type fields to MS Access, the data length after export always equaled the field length by adding subsequent spaces, even though the actual data length was shorter. Due to this the data from such fields could not be edited. 6. Added the support of fields of BCD type. 7. Added the opportunity to randomly rotate the cell text when exporting to XLS format. 8. Fixed the bug that caused the EOleSysError which often emerged during export to MS Access when creating a new database file (.mdb). 9. Delphi 2006 support. 10. EMS Quick Export Component Suite renamed to EMS Advanced Export Component Suite! 08-01-2005 Version 3.3 1. Now ADO_QExport3Access component exports long text data into MS Access Database correctly. 2. Added possibility to export data into MS Access Databases secured with password (ADO_QExport3Access). 3. Added possibility of formatting data using OnGetExportText event handler. (QExport3HTML) 4. New InterpertTags property implemented in QExport3HTML component. If this property is true then all special symbols <, >,", & found in exported data (text) will be replaced with &lt; &gt; &quot; &amp; accordingly. 5. Fixed bug related with calculating output coordinates during exporting data into PDF format. (QExport3Wizard) 6. QExport3ASCII component exported only one data record with the following settings of its properties: ExportType := etTxt; ExportSource := esCustom; AutoCalcColWidth := True; Now it's fixed. 7. The bug that results in Access Violation on usage of QExport3Dialog component in Delphi 2005 IDE is fixed now. 8. Decreased processor loading while executing long export/import operations. 12-28-2004 Version 3.2 1. Delphi 2005 support. 2. Now Quick Export can use several languages in one project. By default, it works with resources that are linked into .BPL file. If you need multi-language support in your project, make several language DLLs and switch to particular language by this code: uses QExport3; QExportLocale.LoadDll('QEEnglish.dll'); // load English resources ... QExportLocale.UnloadDll; // unload resource DLL and use default resources To make the DLL, run MakeDll.bat file in this folder, or MakeAll.bat file in the LANGUAGES folder to make DLLs for all languages. 3. We have added a new string property NullValue to the TQExport3DBF component. This property contains the string value that is to be inserted to the output DBF file if record has the fields with NULL values. 4. We have added a new string property NullValue to the TQExport3SQL component. This property contains the string value that is to be inserted to the output SQL script if record has the fields with NULL values. 5. Some other improvements and bugfixes. 03-01-2004 Version 3.1 1. We have added a possibility of writing your data into arbitrary Excel cell. Use the Cells property for this purpose. We have also added new methods allowing you to add a cell to a sheet in the runtime (AddBooleanCell, AddDateTimeCell, AddNumericCell, AddStringCell) 2. A possibility of defining merged cells is added to the TQExport3XLS component. The MergedCells property is intended for this purpose. You can also use the AddMergedCells method to define merged cells in the runtime. 3. Now you have a possibility of defining a screen tip for a hyperlink in the TQExport3XLS component. The ScreenTip property of the TxlsHyperlink class provides this feature. 4. We have added a possibility of defining background for a sheet in the TQExport3XLS component. If you would like to define background for a sheet, you should use the Background property. 5. A possibility of including pictures in the result Excel file is implemented. Use the Picture properties to define a picture set for a file and the Images property for placing defined pictures on a sheet. 6. We have improved an Autosize feature in the TQExport3XLS component. 7. A possibility of defining size and precision for float fields is added in the TQExport3DBF component. The DefaultSize and DefaultPrecision properties contain default values for corresponding parameters of a float field. If you would like define for some fields own values of size and precision you should use the ColumnsPrecision property. ColumnsPrecision is a list containing rows such as FIELD1=7,2 In this sample, size is seven and precision is two. 8. We have fixed a bug with exporting an empty data set into HTML. 11-03-2003 Version 3.00 General changes and innovations: 1. A possibility of defining hyperlynks is added to the TQExport3XLS component. The result Excel file can contain hyperlinks to web pages or to local files. Use the Hyperlinks property for this purpose. 2. We have aded a posibility of defining Notes in the TQExport3XLS component. Use this property to define comments to cells. The new NoteFormat property will help you to make an attractive appearance for your comments. 3. Now you can add charts based on the exported data to the result Excel file. We have added the Charts property for this purpose. 4. The new CaptionAligns property is added to the TQExport3RTF component. All column captions are left aligned by default. To set another alignment column caption you have to add a line such as COLUMN1=C COLUMN2=R to the CaptionAligns property. 5. We have improved graphical possibilities of the TQExport3RTF component. Now you can define graphical styles for column captiopns, data, footer and header. 6. A possibi