SMExport suite 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:

TSMExportToXLS MS Excel directly without OLE
TSMExportToXLSX MS Excel 2007/2010 directly without OLE
TSMExportToExcelXML create xml-file supported by MS Excel
TSMExportToExcel using MS Excel as OLE-server
TSMExportToAccess use the DAO/MS Jet
TSMExportToWord using MS Word as OLE-server
TSMExportToWordX MS Word 2007/2010 directly without OLE
TSMExportToRTF RichText format (directly without OLE/DDE/RichText.dll)
TSMExportToText Text files: CSV (comma-delimited) or fixed column width
TSMExportToHTML HTML file
TSMExportToXML XML file. Different layouts are compatible with TClientDataset, MS SQL, ADO etc
TSMExportToJSON JSON file
TSMExportToPDF Adobe Acrobat PDF document
TSMExportToWKS Lotus 1-2-3 directly without OLE
TSMExportToQuattro QuattroPro directly without OLE
TSMExportToSYLK SYLK (Symbolic Link)
TSMExportToDIF DIF (Data Interchange Format)
TSMExportToLDIF LDAP Data Interchange Format (directory entries)
TSMExportToSPSS SPSS file for statistical software and analysis
TSMExportToSQL SQL-script with data dump
TSMExportToBDE Paradox/DBase/ASCII files (BDE is required)
TSMExportToDBF DBase tables (without BDE). Clipper, FoxPro, FVP, FoxBase etc supported
TSMExportToADO ADO data source (without ADO VCL components)
TSMExportToClipboard MS Windows clipboard with separated fields/columns
TSMExportToOpenOffice Open Office document (via OLE automation)
TSMExportToDataset 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.

Only for V.I.P