这个地方有一个非常基本的,带图解.
http://www.aspxcn.com/dotnetbbs/View.aspx?fbId=23&Id=36280用C#进行Word 2002和Excel 2002编程
http://www.yesky.com/20030208/1651044.shtml
在这个论坛中,有很多,你可以自己搜索,用关键字Excel就可以.
http://www.aspxcn.com/dotnetbbs/View.aspx?fbId=23&Id=36280用C#进行Word 2002和Excel 2002编程
http://www.yesky.com/20030208/1651044.shtml
在这个论坛中,有很多,你可以自己搜索,用关键字Excel就可以.
//连接
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);
}
http://support.microsoft.com/default.aspx?scid=kb;EN-US;307029
http://support.microsoft.com/default.aspx?scid=kb;EN-US;306023