1、usingSystem;usingSystem.Data;usingSystem.Data.OleDb;usingSystem.IO;usingSystem.Windows.Forms;usingGemBox.ExcelLite;namespaceWindowsFormsApplication5publicpartialclassForm1:FormpublicSystem.Data.DataTablebiao=newSystem.Data.DataTable();publicDataViewdv=newDataView();publicSystem.Data.DataTabletemp=ne

2、wSystem.Data.DataTable();publicForm1()InitializeComponent();shuchu();dataGridViewl.DataSource=biao;/將表biao中的數(shù)據(jù)傳遞給datagridview顯示。this.dataGridViewl.Columns編號.Frozen=true;publicvoidshuchu()/System.Data.OleDb.OleDbConnectionobjConn=newSystem.Data.OleDb.OleDbConnection(Provider=Microsoft.Jet.OLEDB.4.0;D

3、ataSource=excell.xls;ExtendedProperties=Excel8.0;);System.Data.OleDb.OleDbConnectionobjConn=newSystem.Data.OleDb.OleDbConnection(Provider=Microsoft.Jet.OLEDB.4.0;DataSource=.excell.xls;ExtendedProperties=Excel8.0;);DataSetds=newDataSet();stringTJ=SELECT*FROMmyRange1$;OleDbDataAdapterda=newOleDbDataA

4、dapter(TJ,objConn);tryda.Fill(ds);catch(Exceptionex)MessageBox.Show(ex.Message);objConn.Close();return;biao=ds.Tables0;/將excel表中的數(shù)據(jù)讀入到內(nèi)存表biao中，以備后用。objConn.Close();/連接并打開數(shù)據(jù)庫，將數(shù)據(jù)導(dǎo)入內(nèi)存表biao中，myRangw1為excel中工作表名。biao做查詢使用。privatevoidbutton1_Click(objectsender,EventArgse)ExcelFileexcelFile=newExcelFile()

5、;ExcelWorksheetsheet=excelFile.Worksheets.Add(Users);/定義個表sheet然后添加字段名users？intcolumns=dataGridView1.Columns.Count;/列數(shù)introws=dataGridView1.Rows.Count;/行數(shù)for(intj=0;jcolumns;j+)sheet.Cells0,j.Value=dataGridView1.Columnsj.HeaderText;/添加第一行數(shù)據(jù)，應(yīng)該是添加字段名吧。for(inti=1;irows;i+)for(intj=0;jcolumns;j+)sheet.

6、Cellsi,j.Value=dataGridView1j,i-1.Value.ToString().Trim()/;/從第二行開始添加數(shù)據(jù)excelFile.SaveXls(./Users.xls);/保存為excel表MessageBox.Show(生成成功”)；privatevoidbutton2_Click(objectsender,EventArgse)SaveFileDialogsaveFileDialog=newSaveFileDialog();saveFileDialog.Filter=Execlfiles(*.xls)|*.xls;saveFileDialog.FilterI

7、ndex=0;saveFileDialog.RestoreDirectory=true;saveFileDialog.CreatePrompt=true;/saveFileDialog.Title=導(dǎo)出Excel文件到；DateTimenow=DateTime.Now;saveFileDialog.FileName=now.Year.ToString().PadLeft(2)+now.Month.ToString().PadLeft(2,0)+now.Day.ToString().PadLeft(2,0)+-+now.Hour.ToString().PadLeft(2,0)+now.Minut

8、e.ToString().PadLeft(2,0)+now.Second.ToString().PadLeft(2,0);saveFileDialog.ShowDialog();StreammyStream;myStream=saveFileDialog.OpenFile();StreamWritersw=newStreamWriter(myStream,System.Text.Encoding.GetEncoding(gb2312);stringstr=;try/寫標(biāo)題for(inti=0;i0)str+=t;str+=dataGridView1.Columnsi.HeaderText;sw.WriteLine(str);/寫內(nèi)容for(intj=0;jdataGridView1.Rows.Count;j+)stringtempStr=;for(intk=0;k0)tempStr+=t;tempStr+=dataGridView1.Rowsj.Cellsk.Value.ToString();sw.WriteLine(tempStr);sw.Close();myStream.Close();MessageBox.Show(”