using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Text;
using?System.Windows.Forms;
using?System.Data.SqlClient;
namespace?cangku
{
???class?daochuEXCEL
????{
????????public??static??void?ExportExcel（string?fileName?DataGridView?myDGV）
????????//導(dǎo)出函數(shù)有兩個(gè)參數(shù)，一個(gè)為保存文件名，另一個(gè)為當(dāng)前顯示數(shù)據(jù)的datagridview
????????{
????????????string?saveFileName?=?““;
????????????SaveFileDialog?saveDialog?=?new?SaveFileDialog（）;//建立保存對(duì)話框
????????????saveDialog.DefaultExt?=?“xls“;
????????????saveDialog.Filter?=?“Excel文件|*.xls“;
????????????saveDialog.FileName?=?fileName;
????????????saveDialog.ShowDialog（）;
????????????saveFileName?=?saveDialog.FileName;
????????????if?（saveFileName.IndexOf（“:“）?????????????Microsoft.Office.Interop.Excel.Application?xlApp
?????????=?new?Microsoft.Office.Interop.Excel.Application（）;
????????????if?（xlApp?==?null）
????????????{
????????????????MessageBox.Show（“無(wú)法創(chuàng)建Excel對(duì)象，可能您的機(jī)子未安裝Excel“）;
????????????????return;
????????????}
????????????Microsoft.Office.Interop.Excel.Workbooks?workbooks?=?xlApp.Workbooks;
????????????Microsoft.Office.Interop.Excel.Workbook?workbook?=?workbooks.Add（Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet）;
????????????Microsoft.Office.Interop.Excel.Worksheet?worksheet?=?（Microsoft.Office.Interop.Excel.Worksheet）workbook.Worksheets[1];//取得sheet1?
????????????//寫(xiě)入標(biāo)題，headertext為標(biāo)題屬性
????????????for?（int?i?=?0;?i?????????????{?worksheet.Cells[2?i?+?1]?=?myDGV.Columns[i].HeaderText;?}
????????????//寫(xiě)入數(shù)值
????????????worksheet.Cells[1?1]?=?fileName;
????????????//寫(xiě)入導(dǎo)出數(shù)據(jù)的表格名稱(chēng)
????????????for?（int?r?=?0;?r?????????????{
????????????????for?（int?i?=?0;?i?????????????????{
????????????????????worksheet.Cells[r?+?3?i?+?1]?=?myDGV.Rows[r].Cells[i].Value;
????????????????}
????????????????System.Windows.Forms.Application.DoEvents（）;
????????????}
????????????worksheet.Cells[myDGV.Rows.Count?+?4?2]?=?“導(dǎo)出數(shù)據(jù)時(shí)間：“;//顯示導(dǎo)出時(shí)間???
????????????worksheet.Cells[myDGV.Rows.Count?+?4?3]?=?Convert.ToString（DateTime.Now）;
????????????worksheet.Columns.EntireColumn.AutoFit（）;//列寬自適應(yīng)
????????????if?（saveFileName?!=?““）
????????????{
????????????????try
????????????????{?workbook.Saved?=?true;?workbook.SaveCopyAs（saveFileName）;?}
????????????????catch?（Exception?ex）
????????????????{
????????????????????MessageBox.Show（“導(dǎo)出文件時(shí)出錯(cuò)文件可能正被打開(kāi)！\n“?+?ex.Message）;
????????????????}
????????????}
????????????xlApp.Quit（）;
????????????MessageBox.Show（fileName?+?“的簡(jiǎn)明資料保存成功“?“提示“?MessageBoxButtons.OK）;
????????}
????}
}

?屬性????????????大小?????日期????時(shí)間???名稱(chēng)
-----------?---------??----------?-----??----

?????文件????????392??2011-04-10?16:17??cangku\app.config

?????文件????2777088??2011-04-10?17:29??cangku\bin\Debug\cangku.exe

?????文件????????392??2011-04-10?16:17??cangku\bin\Debug\cangku.exe.config

?????文件?????263680??2011-04-10?17:29??cangku\bin\Debug\cangku.pdb

?????文件??????44544??2005-12-08?14:51??cangku\bin\Debug\cangku.vshost.exe

?????文件????????392??2011-04-10?16:17??cangku\bin\Debug\cangku.vshost.exe.config

?????文件?????217088??2011-04-10?09:30??cangku\bin\Debug\Interop.Microsoft.Office.Core.dll

????.......?????90117??2004-08-13?19:00??cangku\bin\Debug\Lpk.dll

?????文件????1048576??2010-11-16?20:25??cangku\bin\Debug\Microsoft.Office.Interop.Excel.dll

?????文件????????394??2010-11-16?20:24??cangku\cangku\app.config

?????文件????2736128??2011-04-10?07:15??cangku\cangku\bin\Debug\cangku.exe

?????文件????????394??2010-11-16?20:25??cangku\cangku\bin\Debug\cangku.exe.config

?????文件?????241152??2011-04-10?07:15??cangku\cangku\bin\Debug\cangku.pdb

?????文件???????5632??2005-12-08?14:51??cangku\cangku\bin\Debug\cangku.vshost.exe

?????文件????????394??2010-11-16?20:25??cangku\cangku\bin\Debug\cangku.vshost.exe.config

?????文件?????217088??2011-04-10?07:15??cangku\cangku\bin\Debug\Interop.Microsoft.Office.Core.dll

?????文件????1048576??2010-11-16?20:25??cangku\cangku\bin\Debug\Microsoft.Office.Interop.Excel.dll

????.......?????90117??2004-08-13?19:00??cangku\cangku\bin\Debug\Usp10.dll

?????文件??????11127??2010-12-13?10:44??cangku\cangku\cangku.csproj

?????文件???????2973??2010-11-16?20:24??cangku\cangku\daochuEXCEL.cs

?????文件????????411??2010-12-13?10:54??cangku\cangku\dbhelper.cs

?????文件???????1922??2010-11-16?20:24??cangku\cangku\goodsadd.cs

?????文件??????12276??2010-11-16?20:24??cangku\cangku\goodsadd.Designer.cs

?????文件???????5814??2010-11-16?20:24??cangku\cangku\goodsadd.resx

?????文件???????2163??2010-11-16?20:24??cangku\cangku\goodsManage.cs

?????文件???????7861??2010-11-16?20:24??cangku\cangku\goodsManage.Designer.cs

?????文件???????5814??2010-11-16?20:24??cangku\cangku\goodsManage.resx

?????文件???????4182??2010-11-16?20:24??cangku\cangku\goodsModify.cs

?????文件??????11530??2010-11-16?20:24??cangku\cangku\goodsModify.Designer.cs

?????文件???????5814??2010-11-16?20:24??cangku\cangku\goodsModify.resx

............此處省略306個(gè)文件信息