连接Excel的示例
-------------------------
using System.Data;
using System.Data.OleDb;
try
{
OleDbConnection myConn=new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=aa.xls;Extended Properties=Excel 8.0;");
myConn.Open();
OleDbDataAdapter thisAdapter= new OleDbDataAdapter("SELECT * FROM [Sheet1$]",myConn);
OleDbCommandBuilder thisBuilder=new OleDbCommandBuilder(thisAdapter);
DataSet thisDataSet=new DataSet();
thisAdapter.Fill(thisDataSet,"ExcelInfo");
MessageBox.Show(thisDataSet.Tables["ExcelInfo"].Rows[1][1].ToString());
myConn.Close();
}
catch(OleDbException ex)
{
MessageBox.Show(ex.Message);
}
-------------------------
using System.Data;
using System.Data.OleDb;
try
{
OleDbConnection myConn=new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=aa.xls;Extended Properties=Excel 8.0;");
myConn.Open();
OleDbDataAdapter thisAdapter= new OleDbDataAdapter("SELECT * FROM [Sheet1$]",myConn);
OleDbCommandBuilder thisBuilder=new OleDbCommandBuilder(thisAdapter);
DataSet thisDataSet=new DataSet();
thisAdapter.Fill(thisDataSet,"ExcelInfo");
MessageBox.Show(thisDataSet.Tables["ExcelInfo"].Rows[1][1].ToString());
myConn.Close();
}
catch(OleDbException ex)
{
MessageBox.Show(ex.Message);
}
有没有更简单一点的方法。C#中难道没有提供了某个组件(像VB一样)可以直接通过组件拖拽的方法实现呢?
http://www.uncj.net/Exce.htm