using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Web;
using?System.Web.UI;
using?System.Web.UI.WebControls;
using?System.IO;
using?Excel?=?Microsoft.Office.Interop.Excel;

namespace?WEB
{?
????
????///?

????///??
????///??作者：鄒學典
????///??時間：2015-2-3
????///??功能：使用Office?COM組建導出Excel文件
????///??備注：??http://www.zousky.com/archives/2725.html
????///?
????///?

????public?partial?class?ExcelCOM?:?System.Web.UI.Page
????{
????????protected?void?Page_Load（object?sender?EventArgs?e）
????????{

????????}


????????///?

????????///?通過調用Office的Com組建來導出Excel文件
????????///?1、添加?office的組建引用，在DLL文件夾里面?“Microsoft.Office.Interop.Excel.dll”
????????///?2、添加?using?Excel?=?Microsoft.Office.Interop.Excel;
????????///?

????????///?
????????///?
????????protected?void?BtnExport_Click（object?sender?EventArgs?e）
????????{
????????????Excel.Application?excel?=null;?
????????????Microsoft.Office.Interop.Excel._Workbook?workBook=null;
????????????Microsoft.Office.Interop.Excel._Worksheet?worksheet?=?null;
????????????string?filePath?=?“\\File\\“?+?DateTime.Now.ToString（“yyyyMMddHHmmss“）?+?“.xls“;

????????????try
????????????{??
????????????????//強制回收垃圾
????????????????GC.Collect（）;

?????????????????excel?=?new?Excel.Application（）;
?????????????????workBook?=?excel.Workbooks.Add（true）;
?????????????????worksheet?=?（Microsoft.Office.Interop.Excel._Worksheet）workBook.ActiveSheet;

?????????????????//行索引
?????????????????int?rowIndex?=?1;
?????????????????//列索引
?????????????????int?cellIndex?=?1;

?????????????????//寫表頭
?????????????????excel.Cells[rowIndex?cellIndex++]?=?“姓名“;
?????????????????excel.Cells[rowIndex?cellIndex++]?=?“年齡“;
?????????????????excel.Cells[rowIndex?cellIndex++]?=?“積分“;

?????????????????//寫內容
?????????????????List?list?=?new?ExcelData（）.GetList（）;
?????????????????foreach?（ExcelModel?model?in?list）
?????????????????{
?????????????????????cellIndex?=?1;
?????????????????????rowIndex++;

?????????????????????excel.Cells[rowIndex?cellIndex++]?=?model.Name.ToString（）;
?????????????????????excel.Cells[rowIndex?cellIndex++]?=?model.Age.ToString（）;
?????????????????????excel.Cells[rowIndex?cellIndex++]?=?model.Score.ToString（）;
?????????????????}

?????????????????//保存文件
?????????????????workBook.SaveCopyAs（this.Server.MapPath（filePath））;

?????????????????//回收和清理對象
?????????????????workBook.Close（false?null?null）;
?????????????????excel.Quit（）;
????????????}
????????????catch?（Exception）
????????????{
????????????????throw;
????????????}
????????????finally
????????????{
????????????????if?（workBook?!=?null）
????????????????{
????????????????????System.Runtime.InteropServices.Marshal.ReleaseComobject（workBook）;
????????????????????workBook?=?null;
????????????????}
????????????????if?（?excel?!=?null）
????????????????{
??????

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????899??2015-02-11?09:33??ExportExcel\ExportExcel.sln

????..A..H.?????29696??2015-02-11?14:53??ExportExcel\ExportExcel.suo

?????文件???????1331??2015-02-11?09:20??ExportExcel\WEB\Properties\AssemblyInfo.cs

?????文件?????????87??2015-02-11?09:20??ExportExcel\WEB\Global.asax

?????文件???????1196??2015-02-11?09:20??ExportExcel\WEB\Global.asax.cs

?????文件???????1989??2015-02-11?09:20??ExportExcel\WEB\Web.config

?????文件???????1223??2015-02-11?09:20??ExportExcel\WEB\Web.Debug.config

?????文件???????1284??2015-02-11?09:20??ExportExcel\WEB\Web.Release.config

?????文件???????7006??2015-02-11?11:54??ExportExcel\WEB\WEB.csproj

?????文件????1624064??2015-02-11?11:05??ExportExcel\WEB\bin\NPOI.dll

?????文件?????387072??2015-02-11?11:05??ExportExcel\WEB\bin\NPOI.OOxml.dll

?????文件??????79872??2015-02-11?11:05??ExportExcel\WEB\bin\NPOI.Openxml4Net.dll

?????文件????1316864??2015-02-11?11:05??ExportExcel\WEB\bin\NPOI.OpenxmlFormats.dll

?????文件??????13824??2015-02-11?13:34??ExportExcel\WEB\bin\WEB.dll

?????文件??????30208??2015-02-11?13:34??ExportExcel\WEB\bin\WEB.pdb

?????文件???????7782??2015-02-11?13:34??ExportExcel\WEB\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件??????13824??2015-02-11?13:34??ExportExcel\WEB\obj\Debug\WEB.dll

?????文件????????573??2015-02-11?11:30??ExportExcel\WEB\obj\Debug\WEB.csproj.FileListAbsolute.txt

?????文件??????30208??2015-02-11?13:34??ExportExcel\WEB\obj\Debug\WEB.pdb

?????文件???????1143??2015-02-11?10:04??ExportExcel\WEB\ExcelCSV.aspx.designer.cs

?????文件???????1132??2015-02-11?09:27??ExportExcel\WEB\ExcelData.cs

?????文件???????1086??2015-02-11?11:54??ExportExcel\WEB\WEB.csproj.user

?????文件????1100392??2015-02-11?10:29??ExportExcel\WEB\DLL\Microsoft.Office.Interop.Excel.dll

?????文件????1316864??2015-02-11?11:05??ExportExcel\WEB\DLL\NPOI.OpenxmlFormats.dll

?????文件????1624064??2015-02-11?11:05??ExportExcel\WEB\DLL\NPOI.dll

?????文件?????387072??2015-02-11?11:05??ExportExcel\WEB\DLL\NPOI.OOxml.dll

?????文件??????79872??2015-02-11?11:05??ExportExcel\WEB\DLL\NPOI.Openxml4Net.dll

?????文件???????1751??2015-02-11?14:15??ExportExcel\WEB\ExcelCSV.aspx.cs

?????文件????????529??2015-02-11?14:16??ExportExcel\WEB\ExcelCSV.aspx

?????文件???????3698??2015-02-11?14:15??ExportExcel\WEB\ExcelCOM.aspx.cs

............此處省略25個文件信息