c#如何对excel进行直接操作

[ernidan]

谁有相关例子吗？（包含引用命名空间 和具体实现方法 ）

[angeldh]

我有想知道 UP

[lljfl]

http://www.cnblogs.com/linfuguo/archive/2006/08/19/480976.html

[hdyd]

用OLEDB直接读就可以了



string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = " + strFileName + ";Extended Properties = Excel 8.0";
OleDbConnection oleConnection = new OleDbConnection(strConnection);
try
{
oleConnection.Open();
DataSet dsRead = new DataSet();
OleDbDataAdapter oleAdper = new OleDbDataAdapter(" SELECT * FROM [" + sheetName + "$]", oleConnection);
oleAdper.Fill(dsRead, "result");
return dsRead;
}

[长江支流]

http://blog.csdn.net/flygoldfish/archive/2005/11/07/524305.aspx

http://www.webmis.com.cn/MisGoldPrinter.htm

http://www.webmis.com.cn/GoldPrinter.ExcelExpert.htm