【免费】用DELPHI进行Excel操作资源-CSDN文库

共41个文件

dpk：14个

res：13个

pas：3个

EXCEL

2星需积分: 0 171 浏览量 2008-11-07 12:24:10 上传评论收藏 1.1MB ZIP 举报

资源详情

资源评论

资源推荐

收起资源包目录

ExcelExport.zip （41个子文件）

ExcelExportPack11.dpk 677B

TscExcelExport_Readme.htm 22KB

ExcelExportPack12.dpk 677B

dclExcelExportPack7.dpk 659B

ExcelExportPack6.res 2KB

dclExcelExportPack5.res 2KB

dclExcelExportPack7.res 2KB

dclExcelExportPack11.res 5KB

ExcelExportPack10.res 2KB

scExcelExport.dcr 2KB

scExcelExportConfig.inc 2KB

dclExcelExportPack5.dpk 667B

dclExcelExportPack12.dpk 674B

dclExcelExportPack9.dpk 684B

ExcelExportPack5.res 2KB

ExcelExportPack7.res 2KB

dclExcelExportPack9.res 2KB

ExcelExportPack12.dproj 4KB

ExcelExportPack9.res 2KB

ExcelExportPack7.dpk 676B

dclExcelExportPack12.dproj 4KB

ExcelExportPack5.dpk 692B

ExcelExportPack10.dpk 677B

dclExcelExportPack6.res 2KB

ExcelExportPack11.res 5KB

Source demo

Prj_ExcelExport.dpr 286B

Prj_ExcelExport.dproj 4KB

MainExcelExport.dfm 825KB

MainExcelExport.pas 46KB

Prj_ExcelExport.res 9KB

dclExcelExportPack10.dpk 686B

Live templates

ExcelExportUse.xml 1KB

ExcelExportCreate.xml 1018B

dclExcelExportPack10.res 2KB

scExcelExport.pas 124KB

dclExcelExportPack6.dpk 674B

dclExcelExportPack11.dpk 674B

ExcelExportPack6.dpk 676B

scExcelExportReg.pas 4KB

DemoExcelExport.exe 1.43MB

ExcelExportPack9.dpk 676B

<html> <head> <title>TscExcelExport</title> </head> <body bgcolor="#FFFFCC"> <hr> TscExcelExport 3.8 VCL component for Delphi 5, 6, 7, 2005, 2006, Turbo Delphi, 2007 & 2009 Support for Excel 97, 2000, XP, 2003 and 2007 October 2008 <hr> Stefan Cruysberghs Lommel, Flanders, Belgium <a href="http://www.scip.be">http://www.scip.be</a> <hr> Description This TscExcelExport component is an advanced, powerful but easy to use component which enables you to export all records of a dataset from Borland/Codegear Delphi to Microsoft Excel. Many features are provided to change the layout, use conditional formatting, to add totals, to create groups, to set a filter, ... The component works in Delphi 5, 6, 7, 2006, 2007 & 2009 and it supports Excel 97, 2000, XP, 2003 and 2007. Properties <ul> <li> Name of worksheet and file</li> <li> Header and footer texts</li> <li>Begin row and column of header, footer, titles (=fieldnames) and data (fieldvalues)</li> <li> Width of columns or autofit</li> <li>Font of header, footer, titles, summary and data (Alignment, WrapText, Orientation, MergeCells)</li> <li> Backgroundcolor and borders of header, titles, summary and data</li> <li> Summaries for numeric or given fields (SUM, MIN, MAX, AVG)</li> <li>Create groups with given fields</li> <li>AutoFilter for titles </li> <li>A lot of other options to customize the result</li> </ul> Events <ul> <li>To define the background color and font color, size, name and bold style of each cell </li> <li>For exporting data without using a TDataset </li> </ul> Methods <ul> <li> Export to Excel</li> <li> Save worksheet as XLSX (Open XML), XLS, HTML, XML or CSV</li> <li> Show print preview</li> </ul> Component editor <ul> <li>The component editor can be used to change some settings on an easy way.</li> </ul> Live templates <ul> <li>Live templates for Delphi 2006, 2007 & 2009 (ExcelExportUse and ExcelExportCreate)</li> </ul> Type library / COM <ul> <li>This component uses the Office server components from the Borland COM type library. </li> <li>By using compiler directives (in unit scExcelExportConfig.inc) you can override the default type library. The available libraries are Excel97, Excel2000 and ExcelXP (folder Borland\Delphi7\OCX\Servers or CodeGear\RAD Studio\6.0\OCX\Servers). </li> <li> MS Excel should be installed on the PC when using this component.</li> </ul> Delphi / Office <ul> <li>This VCL component was tested in Delphi 5 (SP1), Delphi 6, Delphi 7, Delphi (BDS) 2005, Delphi (BDS) 2006, Turbo Delphi and Delphi 2007. </li> <li>The TscExcelExport component works with Excel 97, Excel 2000, Excel XP, Excel 2003 and Excel 2007 (bèta) and it has been tested with Dutch and some English Office versions. </li> <li>This component will also give you access to the Excel Application, Workbook and Worksheet objects so you can access all VBA properties and methods. </li> </ul> Demo application <ul> <li>A full demo application with 18 examples is supplied to view and test all features of the component (and Excel automation).</li> <li>See source code for history and more information about properties, methods and events.</li> </ul> Known issues <ul> <li> The warnings 'unsafe code', 'unsafe type' and 'unsafe typecast' should be ignored when compiling the ExcelExport packages. In Delphi 7, 2005, 2006, Turbo Delphi, 2007 and 2009 these warnings can be disabled in your project options.</li> <li> EOleSysError "Class not registered" exception. This error occurs when one or more DLL's. The problem is that the EOleSysError does not specify which DLL's are causing the problem. So the best solution is to reinstall Office/Excel.</li> <li> Error reading ExplicitTop, ExplicitLeft, ExplicitWidth and ExplicitHeight properties when opening the demo application in other Delphi versions than 2007/2009. Just choose "Ignore all". These properties will be removed from the DFM and the appliction will run fine in Delphi 6, 7,