c#读取excel数据的两个方法

《c#读取excel数据的两个方法》由会员上传分享，免费在线阅读，更多相关内容在应用文档-天天文库。

1、C#读取excel数据的两个方法oledb方法 程序代码usingSystem.Data.OleDb;            stringstrCon="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=c:\test.xls;ExtendedProperties=Excel8.0";            OleDbConnectionmyConn=newOleDbConnection(strCon);            stringstrCom="Sel

2、ect*FROM[1$A1:C100]";            myConn.Open();            OleDbDataAdaptermyCommand=newOleDbDataAdapter(strCom,myConn);            DataSetmyDataSet=newDataSet();            myCommand.Fill(myDataSet,"1$");            myConn.Close();            dataGridV

3、iew1.DataSource=myDataSet.Tables[0];            //MessageBox.Show(dataGridView1.ColumnCount.ToString());            dataGridView1.Columns[0].SortMode=DataGridViewColumnSortMode.NotSortable;            dataGridView1.Columns[1].SortMode=DataGridViewColumn

4、SortMode.NotSortable;            dataGridView1.Columns[2].SortMode=DataGridViewColumnSortMode.NotSortable;            dataGridView1.Columns[0].AutoSizeMode=DataGridViewAutoSizeColumnMode.AllCells;            dataGridView1.Columns[1].AutoSizeMode=DataGri

5、dViewAutoSizeColumnMode.AllCells;            dataGridView1.Columns[2].AutoSizeMode=DataGridViewAutoSizeColumnMode.AllCells;            dataGridView1.ReadOnly=true;Excel.Application方法 程序代码usingExcel=Microsoft.Office.Interop.Excel;usingSystem.Reflection; 

6、            Excel.ApplicationoXL=newMicrosoft.Office.Interop.Excel.Application();            oXL.Visible=true;            Excel._WorkbookoWB2=(Excel._Workbook)oXL.Workbooks.Open(@"f:test.xls",                 Missing.Value,                 Missing.Valu

7、e,                 Missing.Value,                 Missing.Value,                 Missing.Value,                 Missing.Value,                 Missing.Value,                 Missing.Value,                 Missing.Value,                 Missing.Value,   

8、              Missing.Value,                 Missing.Value,                 Missing.Value,                 Missing.Value                );            Excel._WorksheetoSheet=(Excel._Worksheet)oWB.ActiveSheet;            Excel.Shap