The native Delphi components in this suite provide fast and direct data export into MS Excel, XML, HTML, SPSS, PDF and other formats from a DBGrid, Dataset or any VCL control!
SMExport suite 4.99 is a set of component that export data from TDataSet or TDBGrid or any other VCL control (such as TStringGrid, TListView and so on) into such formats as Paradox (if using the BDE) and DBase tables or into a text file (fixed or comma-delimited), HTML, XML, MS Excel, MS Word, PDF, MS Access, SQL-script, Lotus 1-2-3, Quattro, SYLK, DIF, LDAP DIF and other formats as described in the following table:
||MS Excel directly without OLE|
||MS Excel 2007/2010 directly without OLE|
||using MS Excel as OLE-server|
||use the DAO/MS Jet|
||using MS Word as OLE-server|
||RichText format (directly without OLE/DDE/RichText.dll)|
||Text files (fixed or comma-delimited types)|
||XML file. Subset of TClientDataset format for save/load from XML is supported|
||Adobe Acrobat PDF document|
||Lotus 1-2-3 directly without OLE|
||QuattroPro directly without OLE|
||SYLK (Symbolic Link)|
||DIF (Data Interchange Format)|
||LDAP Data Interchange Format (directory entries)|
||SPSS file for statistical software and analysis|
||SQL-script with data dump|
||Paradox/DBase/ASCII files (BDE is required)|
||DBase tables (without BDE)|
||ADO data source (without ADO VCL components)|
||MS Windows clipboard with separated fields/columns|
||copy a data into other dataset|
Data specific format settings (such as column widths, colors, fonts, selected records etc.) are transferred where possible.
The SMExport components are native VCL engines with multi-language support.
Note that nearly every component above allows the user to select one of 3 possible actions after the export process has completed:
- Return control to the form (no action taken after export)
- Email the resulting file as an attachment
- Open the file in the supported software package (such as Excel, Word, Access, etc.).
SMExport suite also contains a very useful wizard, the TSMEWizardDlg () component, which is a self-contained wizard which guides end users in the exporting of any data at run-time via a user-friendly interface which assists with export parameter settings. This component gives your user total control over entire data export process via a few simple mouse clicks. Simply drop the component on a form and execute it on an appropriate button click (or other user action as you see fit).
Another useful compound component in the SMExport suite is the TSMExportMonitor () component. This component activates a visual dialog for setting export parameters. Judicious us of this component enables you to programmatically control all data export processes in a single module and thus provide a flexible application for your end-users.
Custom data engines in SMExport suite allow you to export data from any VCL control (TStringGrid, TListView, TDecisionCube etc). Included is a virtual data engine which allows you to generate data in run-time that is not linked to any control. A number of custom third-party data sources are supported as well (DevExpress, TMS, DOA, IBObject, DBISAM etc)
The data pumping components in this suite allow you to export any number of tables from a database with just a few mouse clicks.