using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Linq;
using?System.Text;
using?System.Windows.Forms;
using?System.Data.SqlClient;
using?Excel?=?Microsoft.Office.Interop.Excel;

namespace?OutputExcel
{
????public?partial?class?Form1?:?Form
????{
????????public?Form1（）
????????{
????????????InitializeComponent（）;
????????????GetData（）;
????????}

????????DataTable?dt;
????????///?

????????///?獲取數據
????????///?

????????private?void?GetData（）
????????{
????????????SqlConnection?sqlCon?=?new?SqlConnection（“server=localhost;database=Test;uid=sa;pwd=1“）;
????????????string?sql?=?“select?*?from?Users“;
????????????sqlCon.Open（）;
????????????SqlCommand?cmd?=?new?SqlCommand（sql?sqlCon）;
????????????sqlCon.Close（）;
????????????SqlDataAdapter?sda?=?new?SqlDataAdapter（cmd）;
????????????dt?=?new?DataTable（）;
????????????sda.Fill（dt）;

????????????dataGridView1.DataSource?=?dt;
????????}

????????public?void?ExportToExcel（DataTable?dt?string?saveFileName）
????????{
????????????if?（dt?==?null）?return;
????????????Excel.Application?xlApp?=?new?Excel.Application（）;
????????????if?（xlApp?==?null）
????????????{
????????????????//?lblMsg.Text?=?“無法創建Excel對象，可能您的機子未安裝Excel“;
????????????????MessageBox.Show（“請確保您的電腦已經安裝Excel“?“提示信息“?MessageBoxButtons.OK?MessageBoxIcon.Error）;
????????????????return;
????????????}
????????????Excel.Workbooks?workbooks?=?xlApp.Workbooks;
????????????Excel.Workbook?workbook?=?workbooks.Add（Excel.XlWBATemplate.xlWBATWorksheet）;
????????????Excel.Worksheet?worksheet?=?（Excel.Worksheet）workbook.Worksheets[1];?//取得sheet1
????????????Excel.Range?range?=?null;
????????????long?totalCount?=?dt.Rows.Count;
????????????long?rowRead?=?0;
????????????float?percent?=?0;

????????????//寫入標題
????????????for?（int?i?=?0;?i?????????????{
????????????????worksheet.Cells[1?i?+?1]?=?dt.Columns[i].ColumnName;
????????????????range?=?（Excel.Range）worksheet.Cells[1?i?+?1];
????????????????range.Interior.ColorIndex?=?15;//背景顏色
????????????????range.Font.Bold?=?true;?//粗體
????????????????range.HorizontalAlignment?=?Excel.XlHAlign.xlHAlignCenter;?//居中
????????????????//加邊框
????????????????range.BorderAround（Excel.XlLinestyle.xlContinuous?Excel.XlBorderWeight.xlThin
???????????????????????????????????Excel.XlColorIndex.xlColorIndexAutomatic?null）;
????????????????//range.ColumnWidth?=?4.63;//設置列寬
????????????????//range.EntireColumn.AutoFit（）;//自動調整列寬
????????????????//r1.EntireRow.AutoFit（）;//自動調整行高
????????????}
????????????//寫入內容
????????????for?（int?r?=?0;?r?????????????{
????????????????for?（int?i?=?0;?i?????????????????{
????????????????????try
????????????????????{
????????????????????????worksheet.Cells[r?+?2?i?+?1]?=?dt.Rows[r][i];

????????????????????????range?=?（Excel.Range）worksheet.Cells[r?

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

?????文件??????19456??2013-04-24?16:02??OutputExcel\OutputExcel\bin\Debug\OutputExcel.exe

?????文件??????26112??2013-04-24?16:02??OutputExcel\OutputExcel\bin\Debug\OutputExcel.pdb

?????文件??????11600??2013-04-26?10:02??OutputExcel\OutputExcel\bin\Debug\OutputExcel.vshost.exe

?????文件????????490??2010-03-17?22:39??OutputExcel\OutputExcel\bin\Debug\OutputExcel.vshost.exe.manifest

?????文件???????6363??2013-04-24?17:27??OutputExcel\OutputExcel\Form1.cs

?????文件???????6145??2013-04-24?17:27??OutputExcel\OutputExcel\Form1.Designer.cs

?????文件??????22145??2013-04-24?17:27??OutputExcel\OutputExcel\Form1.resx

?????文件???????4501??2013-04-24?16:00??OutputExcel\OutputExcel\obj\x86\Debug\DesignTimeResolveAssemblyReferences.cache

?????文件???????6418??2013-04-24?16:02??OutputExcel\OutputExcel\obj\x86\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件????????224??2013-04-24?16:02??OutputExcel\OutputExcel\obj\x86\Debug\GenerateResource.read.1.tlog

?????文件????????562??2013-04-24?16:02??OutputExcel\OutputExcel\obj\x86\Debug\GenerateResource.write.1.tlog

?????文件????????667??2013-04-26?10:02??OutputExcel\OutputExcel\obj\x86\Debug\OutputExcel.csproj.FileListAbsolute.txt

?????文件??????19456??2013-04-24?16:02??OutputExcel\OutputExcel\obj\x86\Debug\OutputExcel.exe

?????文件????????180??2013-04-24?16:02??OutputExcel\OutputExcel\obj\x86\Debug\OutputExcel.Form1.resources

?????文件??????26112??2013-04-24?16:02??OutputExcel\OutputExcel\obj\x86\Debug\OutputExcel.pdb

?????文件????????180??2013-04-24?09:53??OutputExcel\OutputExcel\obj\x86\Debug\OutputExcel.Properties.Resources.resources

?????文件???????9432??2013-04-24?16:02??OutputExcel\OutputExcel\obj\x86\Debug\ResolveAssemblyReference.cache

?????文件???????3876??2013-04-24?09:52??OutputExcel\OutputExcel\OutputExcel.csproj

?????文件????????492??2013-04-24?09:30??OutputExcel\OutputExcel\Program.cs

?????文件???????1372??2013-04-24?09:30??OutputExcel\OutputExcel\Properties\AssemblyInfo.cs

?????文件???????2870??2013-04-24?09:30??OutputExcel\OutputExcel\Properties\Resources.Designer.cs

?????文件???????5612??2013-04-24?09:30??OutputExcel\OutputExcel\Properties\Resources.resx

?????文件???????1094??2013-04-24?09:30??OutputExcel\OutputExcel\Properties\Settings.Designer.cs

?????文件????????249??2013-04-24?09:30??OutputExcel\OutputExcel\Properties\Settings.settings

?????文件????????875??2013-04-24?09:30??OutputExcel\OutputExcel.sln

????..A..H.?????18944??2013-04-26?10:03??OutputExcel\OutputExcel.suo

?????文件????2097152??2013-04-26?10:03??OutputExcel\Test.mdf

?????文件????1048576??2013-04-26?10:03??OutputExcel\Test_log.ldf

?????目錄??????????0??2013-04-24?09:30??OutputExcel\OutputExcel\obj\x86\Debug\TempPE

?????目錄??????????0??2013-04-24?16:02??OutputExcel\OutputExcel\obj\x86\Debug

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