CSharp Excel操作

1.读取Excel文件内容，写入数据库。 2.读取数据库信息，写入Excel 2.合并指定区域内Excel单元格，如c（1, 1）=c(1,2)- -->c(4, 5); 3.设置单元格内容的字体、大小、颜色。 4.一句话读取Excel文档使用的行数和列数 5.一句话实现Excel文件复制，保存副本，并且设置禁止 弹出保存和覆盖的询问提示框 6.DataSet数据集实现快速查找指定条件的数据 7.两篇Excel文档进行内容比对 8.包括数据库，整套源码，和测试Excel文档

using System.Reflection;
using System.Runtime.CompilerServices;
using System.Runtime.InteropServices;


[assembly: Assemblytitle（“Maticsoft.Web 三层结构示例源码“）]
[assembly: AssemblyDescription（“Maticsoft.Web 三层结构示例源码“）]
[assembly: AssemblyConfiguration（““）]
[assembly: AssemblyCompany（“Maticsoft“）]
[assembly: AssemblyProduct（“Maticsoft.Web 三层结构示例源码“）]
[assembly: AssemblyCopyright（“Copyright （C） Maticsoft 2004-2008“）]
[assembly: AssemblyTrademark（““）]
[assembly: AssemblyCulture（““）]
[assembly: AssemblyVersion（“2.0.0.0“）]

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件        216  2010-03-03 08:59  CSharpExcelDb\app.xml

     文件        555  2010-03-18 09:17  CSharpExcelDb\BLL\AssemblyInfo.cs

     文件       7493  2010-03-18 09:17  CSharpExcelDb\BLL\BLL.csproj

     文件       2503  2010-03-18 09:17  CSharpExcelDb\BLL\BLL.csproj.user

     文件     372736  2010-03-18 09:17  CSharpExcelDb\BLL\CrystalDecisions.CrystalReports.Engine.dll

     文件     249856  2010-03-18 09:17  CSharpExcelDb\BLL\CrystalDecisions.Windows.Forms.dll

     文件     421888  2010-03-18 09:17  CSharpExcelDb\BLL\HikPlayM4.dll

     文件       5862  2010-03-18 09:17  CSharpExcelDb\BLL\jb\adcompany.cs

     文件       3887  2010-03-18 09:17  CSharpExcelDb\BLL\jb\AdCompanyType.cs

     文件       4494  2010-03-18 09:17  CSharpExcelDb\BLL\jb\ADLib.cs

     文件       3876  2010-03-18 09:17  CSharpExcelDb\BLL\jb\AdType.cs

     文件       4988  2010-03-18 09:17  CSharpExcelDb\BLL\jb\Area.cs

     文件       3894  2010-03-18 09:17  CSharpExcelDb\BLL\jb\brand.cs

     文件       3870  2010-03-18 09:17  CSharpExcelDb\BLL\jb\DecideMethod.cs

     文件       6263  2010-03-18 09:17  CSharpExcelDb\BLL\jb\DiscernResult.cs

     文件       3848  2010-03-18 09:17  CSharpExcelDb\BLL\jb\Forms.cs

     文件       5568  2010-03-18 09:17  CSharpExcelDb\BLL\jb\IllegalAd.cs

     文件       5354  2010-03-18 09:17  CSharpExcelDb\BLL\jb\IllegalAdDetail.cs

     文件       4193  2010-03-18 09:17  CSharpExcelDb\BLL\jb\illegalLevel.cs

     文件       4147  2010-03-18 09:17  CSharpExcelDb\BLL\jb\IllegalRule.cs

     文件       6220  2010-03-18 09:17  CSharpExcelDb\BLL\jb\MediaLib.cs

     文件       4504  2010-03-18 09:17  CSharpExcelDb\BLL\jb\MediaLibDetail.cs

     文件       6201  2010-03-18 09:17  CSharpExcelDb\BLL\jb\Person.cs

     文件       3802  2010-03-18 09:17  CSharpExcelDb\BLL\jb\PlayMode.cs

     文件       3860  2010-03-18 09:17  CSharpExcelDb\BLL\jb\PlayType.cs

     文件       3928  2010-03-18 09:17  CSharpExcelDb\BLL\jb\RecType.cs

     文件       5313  2010-03-18 09:17  CSharpExcelDb\BLL\jb\SampleLib.cs

     文件       4737  2010-03-18 09:17  CSharpExcelDb\BLL\jb\TaskList.cs

     文件       4157  2010-03-18 09:17  CSharpExcelDb\BLL\jb\WorkLog.cs

     文件     425984  2010-03-18 09:17  CSharpExcelDb\BLL\MagicLibrary.dll

............此处省略564个文件信息