Delphi编程保存数据到Excel文件(1)：控件总览
168 views
Skip to first unread message
william
Mar 18, 2008, 8:43:08 AM3/18/08
to 编程笔记
Delphi编程保存数据到Excel文件(1)：控件总览
在delphi编写的程序中，如果需要把数据保存到Excel文件中，可以采用的方式不外乎有两种：
(1)采用OLE自动化方式，这需要同时安装有Excel程序。
(2)采用控件方式，直接输出Excel文件，不需要安装有Excel程序。
现在比较好的控件有：
(1) XLSReadWriteII (http://www.axolot.com/components/
xlsrwii20.htm) $299.00
The complete solution when you need to access Excel files. For
Delphi and .NET.
Native access to Excel files. The user doesn't need to have Excel,
or any other software installed. XLSReadWriteII works as an invisible
Excel workbook. All cell values are always accessible. Stability. One
of the major goals with version 2.0 was to create a product that won't
corrupt the Excel files and won't alter any data in the file.
XLSReadWriteII is easy to use. With the new formatting interface in
version 2.0, you can format cells through a cell object. Fast and
efficient support when you have any questions. No runtime fees for the
component. Full source code included. We released the first version of
XLSReadWrite in 1998. At that time it was the only component that
could read and write Excel 97+ files. We are commited to have the
leading Excel solution for Delphi in the future as well.
(2) NativeExcel (http://www.nika-soft.com/nativeexcel2/index.htm)
$49.99
NativeExcel v2.x is a high-performance solution for Delphi
Developers that allows writing of new Excel sdivadsheets and reading
of existing ones. NativeExcel does not require installed Microsoft
Office, it writes and reads excel files directly. NativeExcel can be
used as a replacement of standard Excel components, it has the same
object model, properties and methods. With NativeExcel v2.x you can
open and modify an existing sdivadsheet. NativeExcel2 works with
Delphi 4,5,6,7,2005 and 2006.
(3) SM-software TXLSFile (http://sm-software.com/pxlsfile.htm)?
$65.00
TXLSFile is a Delphi library for reading and writing of Microsoft
Excel XLS files. It is based on direct reading and writing of files,
and works without OLE Automation with Microsoft Excel.
(4) EMS Quick Export (http://www.sqlmanager.net/products/tools/
advancedexport) $195.00
Advanced Data Export is a component suite (for Borland Delphi
and .NET) that allows you to save your data in the most popular data
formats for the future viewing, modification, printing or web
publication. You can export data into MS Access, MS Excel, MS Word
(RTF), HTML, XML, PDF, TXT, DBF, CSV and more! There will be no need
to waste your time on tiresome data conversion - Advanced Data Export
will do the task quickly and will give the result in the desired
format.
(5) Scalabium SMExport Suite (http://www.scalabium.com/sme/)
$35.00
fast and direct data export into MS Excel, XML, HTML, SPSS, PDF
and others from DBGrid/Dataset or any VCL control!
SMExport suite is a component set for data export from TDataSet or
TDBGrid or any other VCL control (TStringGrid, TListView etc) into the
Paradox and DBase tables (using BDE) 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 others.
(6) FastReport Export Filters (http://www.pragnaan.com/fr/)
$149.00
your application users have the choice of exporting reports to
PDF, HTML, DOC, Excel, GIF, JPEG, BMP, EMF, WMF... even from
FastReport! Written 100% in Object Pascal and compiles completely into
your executable.
(7) Delphi Reports Export (http://www.excelbusinesstools.com/
solutions.asp?prod=207)
The Excel Reporting export component for Delphi is a powerful band-
oriented generator of template-based reports in MS Excel. The easy-to-
use component property editors allow to quickly create powerful
reports in Microsoft Excel. The report export component for Delphi can
create reports, which can be edited, saved to file and viewed almost
on any computer. The component supports Borland Delphi 5, 6, 7, and MS
Excel 97 SR-1, 2000, 2002 (XP).
(8) QuickReport Professional Export Filters (http://www.2ccc.com/
article.asp?articleid=936)
QuickReport Export是一套QuickReport的过滤器，能够将报表保存为
PDF、HTML、RTF、Excel、Text、JPEG、GIF、BMP、EMF和WMF等格式。
(9) eDocEngine VCL (http://www.viewslip.net/cn/
tools_view_0615.html)
Gnostice eDocEngine是一个全面、通用的100% VCL电子文档创建组件包，支持Borland Delphi和
Borland C++Builder。eDocEngine当前支持
PDF、RTF、HTML、XHTML、EXCEL、TEXT、CSV、Quattro Pro、LOTUS
1-2-3、DIF、SYLK、TIFF、PNG、SVG (XML based vector
graphics)、JPEG、GIF、BMP、EMF和WMF格式文档的创建。
(10) HierCube library for VCL (http://www.viewslip.net/cn/
tools_view_06303.html)
HierCube Library是一套程序件，为研制快速、强大和方便的各种程序语言OLAP—应用程序而创建的。HierCube
library拥有基于MOLAP原理的自身OLAP-引擎。与传统的MOLAP技术相比，其优势是无须完成中间计算即可建立OLAP-视图。这可在进
行 OLAP程序操作时大大节省时间和内存。此外，计算速度实际上不取决于立方体的维数和分级维数深度。例如：OLAP-引擎能够在不到一秒时间内处理
含有百万条记录的事实项目表。为使用HierCubeOLAP方案，无需安装任何OLAP服务器或其他生产商的方案。
?? HierCube library可输出(XLS, HTML, PDF, WMF, RTF, CSV, BMP, XML (XML
for Excel, XML for Analysis)等常见格式，最常见Delphi，C++Builder， MS Excel，
QuickReport,，ReportBuilder,，FastReport，RaveReport的报表生成程序。也可将Grid上的信息输到
canvas打印机上。此外，HCL 具有可写输出程序的API，无需对HierCube library内部结构进行深入研究。输出程序的初始编码自
由分配。因此，可自由地编写自己的输出程序，或对现有结构进行加工。
(11) TscExcelExport (http://www.scip.be/index.php?
Page=ComponentsExcelExport&Lang=EN) freeware for non-commercial use
This TscExcelExport component is an advanced, powerful but easy
component to export all records of a dataset from Delphi to MS Excel
(97, 2000, XP or 2003). Many features are provided to change the
layout, to add totals, to create groups, ...
This component uses the Office server components from the Borland
COM type library. By using compiler directives (in unit
scExcelExportConfig.inc) you can override the default type library.
The available libraries are Excel97, Excel2000 and ExcelXP. MS Excel
should be installed on the PC when using this component.
(12) XL Report (http://www.afalinasoft.com/xl-report/index.html)
XL Report by AfalinaSoft is a tool for report generation and data
analysis in Delphi/C++Builder applications through the use of
Microsoft Excel.
The power of Excel and its analytical tools plus the easiness of
XL Report usage will open to you new ways in reporting and data
analyzing.
(13) Advanced Excel Report (http://www.sqlmanager.net/en/products/
tools/excelreport) $95.00
Advanced Excel Report for Delphi is a powerful band-oriented
generator of template-based reports in MS Excel. Easy-to-use component
property editors allow you to quickly create powerful reports in MS
Excel. Now you can create reports, which can be edited, saved to file
and viewed almost on any computer. Advanced Excel Report supports
Borland? Delphi? 5, 6, 7, and MS Office 97 SR-1, 2000, 2002 (XP).
在delphi编写的程序中，如果需要把数据保存到Excel文件中，可以采用的方式不外乎有两种：
(1)采用OLE自动化方式，这需要同时安装有Excel程序。
(2)采用控件方式，直接输出Excel文件，不需要安装有Excel程序。
现在比较好的控件有：
(1) XLSReadWriteII (http://www.axolot.com/components/
xlsrwii20.htm) $299.00
The complete solution when you need to access Excel files. For
Delphi and .NET.
Native access to Excel files. The user doesn't need to have Excel,
or any other software installed. XLSReadWriteII works as an invisible
Excel workbook. All cell values are always accessible. Stability. One
of the major goals with version 2.0 was to create a product that won't
corrupt the Excel files and won't alter any data in the file.
XLSReadWriteII is easy to use. With the new formatting interface in
version 2.0, you can format cells through a cell object. Fast and
efficient support when you have any questions. No runtime fees for the
component. Full source code included. We released the first version of
XLSReadWrite in 1998. At that time it was the only component that
could read and write Excel 97+ files. We are commited to have the
leading Excel solution for Delphi in the future as well.
(2) NativeExcel (http://www.nika-soft.com/nativeexcel2/index.htm)
$49.99
NativeExcel v2.x is a high-performance solution for Delphi
Developers that allows writing of new Excel sdivadsheets and reading
of existing ones. NativeExcel does not require installed Microsoft
Office, it writes and reads excel files directly. NativeExcel can be
used as a replacement of standard Excel components, it has the same
object model, properties and methods. With NativeExcel v2.x you can
open and modify an existing sdivadsheet. NativeExcel2 works with
Delphi 4,5,6,7,2005 and 2006.
(3) SM-software TXLSFile (http://sm-software.com/pxlsfile.htm)?
$65.00
TXLSFile is a Delphi library for reading and writing of Microsoft
Excel XLS files. It is based on direct reading and writing of files,
and works without OLE Automation with Microsoft Excel.
(4) EMS Quick Export (http://www.sqlmanager.net/products/tools/
advancedexport) $195.00
Advanced Data Export is a component suite (for Borland Delphi
and .NET) that allows you to save your data in the most popular data
formats for the future viewing, modification, printing or web
publication. You can export data into MS Access, MS Excel, MS Word
(RTF), HTML, XML, PDF, TXT, DBF, CSV and more! There will be no need
to waste your time on tiresome data conversion - Advanced Data Export
will do the task quickly and will give the result in the desired
format.
(5) Scalabium SMExport Suite (http://www.scalabium.com/sme/)
$35.00
fast and direct data export into MS Excel, XML, HTML, SPSS, PDF
and others from DBGrid/Dataset or any VCL control!
SMExport suite is a component set for data export from TDataSet or
TDBGrid or any other VCL control (TStringGrid, TListView etc) into the
Paradox and DBase tables (using BDE) 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 others.
(6) FastReport Export Filters (http://www.pragnaan.com/fr/)
$149.00
your application users have the choice of exporting reports to
PDF, HTML, DOC, Excel, GIF, JPEG, BMP, EMF, WMF... even from
FastReport! Written 100% in Object Pascal and compiles completely into
your executable.
(7) Delphi Reports Export (http://www.excelbusinesstools.com/
solutions.asp?prod=207)
The Excel Reporting export component for Delphi is a powerful band-
oriented generator of template-based reports in MS Excel. The easy-to-
use component property editors allow to quickly create powerful
reports in Microsoft Excel. The report export component for Delphi can
create reports, which can be edited, saved to file and viewed almost
on any computer. The component supports Borland Delphi 5, 6, 7, and MS
Excel 97 SR-1, 2000, 2002 (XP).
(8) QuickReport Professional Export Filters (http://www.2ccc.com/
article.asp?articleid=936)
QuickReport Export是一套QuickReport的过滤器，能够将报表保存为
PDF、HTML、RTF、Excel、Text、JPEG、GIF、BMP、EMF和WMF等格式。
(9) eDocEngine VCL (http://www.viewslip.net/cn/
tools_view_0615.html)
Gnostice eDocEngine是一个全面、通用的100% VCL电子文档创建组件包，支持Borland Delphi和
Borland C++Builder。eDocEngine当前支持
PDF、RTF、HTML、XHTML、EXCEL、TEXT、CSV、Quattro Pro、LOTUS
1-2-3、DIF、SYLK、TIFF、PNG、SVG (XML based vector
graphics)、JPEG、GIF、BMP、EMF和WMF格式文档的创建。
(10) HierCube library for VCL (http://www.viewslip.net/cn/
tools_view_06303.html)
HierCube Library是一套程序件，为研制快速、强大和方便的各种程序语言OLAP—应用程序而创建的。HierCube
library拥有基于MOLAP原理的自身OLAP-引擎。与传统的MOLAP技术相比，其优势是无须完成中间计算即可建立OLAP-视图。这可在进
行 OLAP程序操作时大大节省时间和内存。此外，计算速度实际上不取决于立方体的维数和分级维数深度。例如：OLAP-引擎能够在不到一秒时间内处理
含有百万条记录的事实项目表。为使用HierCubeOLAP方案，无需安装任何OLAP服务器或其他生产商的方案。
?? HierCube library可输出(XLS, HTML, PDF, WMF, RTF, CSV, BMP, XML (XML
for Excel, XML for Analysis)等常见格式，最常见Delphi，C++Builder， MS Excel，
QuickReport,，ReportBuilder,，FastReport，RaveReport的报表生成程序。也可将Grid上的信息输到
canvas打印机上。此外，HCL 具有可写输出程序的API，无需对HierCube library内部结构进行深入研究。输出程序的初始编码自
由分配。因此，可自由地编写自己的输出程序，或对现有结构进行加工。
(11) TscExcelExport (http://www.scip.be/index.php?
Page=ComponentsExcelExport&Lang=EN) freeware for non-commercial use
This TscExcelExport component is an advanced, powerful but easy
component to export all records of a dataset from Delphi to MS Excel
(97, 2000, XP or 2003). Many features are provided to change the
layout, to add totals, to create groups, ...
This component uses the Office server components from the Borland
COM type library. By using compiler directives (in unit
scExcelExportConfig.inc) you can override the default type library.
The available libraries are Excel97, Excel2000 and ExcelXP. MS Excel
should be installed on the PC when using this component.
(12) XL Report (http://www.afalinasoft.com/xl-report/index.html)
XL Report by AfalinaSoft is a tool for report generation and data
analysis in Delphi/C++Builder applications through the use of
Microsoft Excel.
The power of Excel and its analytical tools plus the easiness of
XL Report usage will open to you new ways in reporting and data
analyzing.
(13) Advanced Excel Report (http://www.sqlmanager.net/en/products/
tools/excelreport) $95.00
Advanced Excel Report for Delphi is a powerful band-oriented
generator of template-based reports in MS Excel. Easy-to-use component
property editors allow you to quickly create powerful reports in MS
Excel. Now you can create reports, which can be edited, saved to file
and viewed almost on any computer. Advanced Excel Report supports
Borland? Delphi? 5, 6, 7, and MS Office 97 SR-1, 2000, 2002 (XP).
Reply all
Reply to author
Forward
0 new messages