C# 我获得二进制文件流怎么转化为<em>EXCEL</em>对象？之前是通过...-excel

/// <summary>
/// 由EXCEL转换成DataTable
/// </summary>
/// <param name="strpath">文件路径及文件名 </param>
/// <returns> </returns>
private DataTable XlsToDataTable(String strpath)
{
string strConn;
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + strpath + ";" +
"Extended Properties=Excel 8.0;";
OleDbConnection conn = new OleDbConnection(strConn);
OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn);
DataTable dt = new DataTable();
myCommand.Fill(dt);
return dt;
}

注意636f70797a686964616f361Sheet1$,这是工作表的名字.

publicDataSet ImportExcel(string strFileName) //strFileName指定的路径百+文件名度.xls
{
if (strFileName != "")
{
string conn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strFileName + ";Extended Properties=Excel 8.0";
string sql = "select * from [Sheet1$]";
OleDbDataAdapter da = newOleDbDataAdapter(sql, conn);
DataSet ds = newDataSet();
try
{
da.Fill(ds, "datatable");
}
catch
{

}
return ds;
}
else
{
return null;
}
}

这个方法问我经常用，转成答dataset和datatable没什么太内大区别吧，反正容ds.Tables[0]就是dataTable了
可以知设置道path的，如专下属：
"sDom": 'T<"clear">lfrtip'
"oTableTools": {
"sSwfPath": "DataTables-1.9.4/extras/TableTools/media/swf/copy_csv_xls_pdf.swf"
}

publicDataSet ImportExcel(string strFileName) //strFileName指定的路径+文件名.xls
{
if (strFileName != "")
{
string conn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strFileName + ";Extended Properties=Excel 8.0";
string sql = "select * from [Sheet1$]";
OleDbDataAdapter da = newOleDbDataAdapter(sql, conn);
DataSet ds = newDataSet();
try
{
da.Fill(ds, "datatable");
}
catch
{

}
return ds;
}
else
{
return null;
}
}

这个方法我经常用，转成dataset和datatable没什么太大区别吧，反正ds.Tables[0]就是dataTable了e799bee5baa6e79fa5e98193e58685e5aeb9361