#region Excel格式
string strConn;
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;"
+ "Data Source=" + filename + ";"
+ "Extended Properties=Excel 8.0;";
OleDbConnection myOleDbConnection = new OleDbConnection(strConn);
OleDbCommand myOleDbCommand = new OleDbCommand("SELECT * FROM [Sheet1$]", myOleDbConnection);
OleDbDataAdapter myData = new OleDbDataAdapter(myOleDbCommand);
DataSet ds = new DataSet();
try
{
myData.Fill(ds);
return ds.Tables[0];
}
catch (Exception ex)
{
throw new Exception("读取导入文件数据时出现错误,Excel格式的表名必须为Sheet1:" + ex.Message);
}
#endregion
#region Access格式
string strConn;
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;"
+ "Data Source=" + filename + ";";
OleDbConnection myOleDbConnection = new OleDbConnection(strConn);
OleDbCommand myOleDbCommand = new OleDbCommand("SELECT * FROM aa", myOleDbConnection);
OleDbDataAdapter myData = new OleDbDataAdapter(myOleDbCommand);
DataSet ds = new DataSet();
try
{
myData.Fill(ds);
return ds.Tables[0];
}
catch (Exception ex)
{
throw new Exception("读取导入文件数据时出现错误,Access格式文件的表名必须为Subsidy:" + ex.Message);
}
#endregion
string strConn;
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;"
+ "Data Source=" + filename + ";"
+ "Extended Properties=Excel 8.0;";
OleDbConnection myOleDbConnection = new OleDbConnection(strConn);
OleDbCommand myOleDbCommand = new OleDbCommand("SELECT * FROM [Sheet1$]", myOleDbConnection);
OleDbDataAdapter myData = new OleDbDataAdapter(myOleDbCommand);
DataSet ds = new DataSet();
try
{
myData.Fill(ds);
return ds.Tables[0];
}
catch (Exception ex)
{
throw new Exception("读取导入文件数据时出现错误,Excel格式的表名必须为Sheet1:" + ex.Message);
}
#endregion
#region Access格式
string strConn;
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;"
+ "Data Source=" + filename + ";";
OleDbConnection myOleDbConnection = new OleDbConnection(strConn);
OleDbCommand myOleDbCommand = new OleDbCommand("SELECT * FROM aa", myOleDbConnection);
OleDbDataAdapter myData = new OleDbDataAdapter(myOleDbCommand);
DataSet ds = new DataSet();
try
{
myData.Fill(ds);
return ds.Tables[0];
}
catch (Exception ex)
{
throw new Exception("读取导入文件数据时出现错误,Access格式文件的表名必须为Subsidy:" + ex.Message);
}
#endregion