/// <summary>
/// 将Excel中的数据读入到DataSet中,作为GridView的数据源
/// </summary>
/// <returns>数据集对象</returns>
private DataSet CreateDataSource()
{
string strConn;
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server .MapPath ("合并单元格.xls")+";Extended Properties=Excel 8.0;";
OleDbConnection myConn = new OleDbConnection(strConn);
OleDbDataAdapter myDA = new OleDbDataAdapter ( "select * from [Sheet1$]", strConn);
DataSet ds = new DataSet();
myDA.Fill(ds); return ds;
}
/// 将Excel中的数据读入到DataSet中,作为GridView的数据源
/// </summary>
/// <returns>数据集对象</returns>
private DataSet CreateDataSource()
{
string strConn;
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server .MapPath ("合并单元格.xls")+";Extended Properties=Excel 8.0;";
OleDbConnection myConn = new OleDbConnection(strConn);
OleDbDataAdapter myDA = new OleDbDataAdapter ( "select * from [Sheet1$]", strConn);
DataSet ds = new DataSet();
myDA.Fill(ds); return ds;
}
麻烦大家了~