Cdatagridview和excel数据的相互导入方法

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中的数据传递给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表中的数据读入到内存表biao中，以备后用。objConn.Close();/连接并打开数据库，将数据导入内存表biao中，myRangw1为excel中工作表名。biao做查询使用。privatevoidbutton1_Click(objectsender,EventArgse)ExcelFileexcelFile=newExcelFile()

5、;ExcelWorksheetsheet=excelFile.Worksheets.Add(Users);/定义个表sheet然后添加字段名users？intcolumns=dataGridView1.Columns.Count;/列数introws=dataGridView1.Rows.Count;/行数for(intj=0;jcolumns;j+)sheet.Cells0,j.Value=dataGridView1.Columnsj.HeaderText;/添加第一行数据，应该是添加字段名吧。for(inti=1;irows;i+)for(intj=0;jcolumns;j+)sheet.

6、Cellsi,j.Value=dataGridView1j,i-1.Value.ToString().Trim()/;/从第二行开始添加数据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=导出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/写标题for(inti=0;i0)str+=t;str+=dataGridView1.Columnsi.HeaderText;sw.WriteLine(str);/写内容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(”