c#如何读取正在编辑的excel数据

这个excel是新建的，没有保存地址。很纠结！

读取Excel首先你在引用中得引用Microsoft office Excel 20** 对应的dll文件，才能读取到Excel的数据
在类里面引用：System.Data.OleDb;

static public DataSet ExcelToDataSet(string filename)
{
DataSet ds;
string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Extended Properties=Excel 8.0;" +
"data source=" + filename;
OleDbConnection myConn = new OleDbConnection(strCon);
string strCom = " SELECt * FROM [Sheet1$]";
myConn.Open();
OleDbDataAdapter myCommand = new OleDbDataAdapter(strCom, myConn);
ds = new DataSet();
myCommand.Fill(ds);
myConn.Close();
return ds;
}
这个方法返回一个数据读取的数据原给你的datagridview

public datatable loaddatafromexcel(string path) { string strconn = "provider=microsoft.ace.oledb.12.0;" + "data source=" + path + ";extended properties='excel 12.0; hdr=yes; imex=1'"; oledbconnection conn = new oledbconnection(strconn); conn.open(); string strexcel = ""; oledbdataadapter mycommand = null; datatable dt = null; strexcel = "select * from [sheet1$]"; mycommand = new oledbdataadapter(strexcel, strconn); dt = new datatable(); mycommand.fill(dt); return dt; } static void main(string[] args) { program p = new program(); datatable dt= p.loaddatafromexcel(路径); console.writeline(dt.rows[0][0].tostring() + dt.rows[0][1].tostring()); } 你试试行不行