//根据文件名,读取excel文件的所有sheet名
public DataTable get_tbl_list(string strco)
{
string strConn;
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strco + ";Extended Properties='Excel 8.0;IMEX=1;'";
OleDbConnection mycn = new OleDbConnection(strConn);
try
{
mycn.Open();
DataTable dt = mycn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
return dt;
}
catch (System.Data.SqlClient.SqlException e)
{
throw new Exception(e.Message);
}
finally
{
mycn.Close();
mycn.Dispose();
}
}
public DataSet get_data(string strco, string tblname)//根据文件名,sheet名读取数据。
{
string strConn;
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strco + ";Extended Properties='Excel 8.0;HDR=yes'";
OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [" + tblname + "]", strConn);
DataSet myDataSet = new DataSet();
try
{
myCommand.Fill(myDataSet, "Excel");
return myDataSet;
}
catch (System.Data.SqlClient.SqlException e)
{
throw new Exception(e.Message);
}
finally
{
}
}
public DataTable get_tbl_list(string strco)
{
string strConn;
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strco + ";Extended Properties='Excel 8.0;IMEX=1;'";
OleDbConnection mycn = new OleDbConnection(strConn);
try
{
mycn.Open();
DataTable dt = mycn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
return dt;
}
catch (System.Data.SqlClient.SqlException e)
{
throw new Exception(e.Message);
}
finally
{
mycn.Close();
mycn.Dispose();
}
}
public DataSet get_data(string strco, string tblname)//根据文件名,sheet名读取数据。
{
string strConn;
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strco + ";Extended Properties='Excel 8.0;HDR=yes'";
OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [" + tblname + "]", strConn);
DataSet myDataSet = new DataSet();
try
{
myCommand.Fill(myDataSet, "Excel");
return myDataSet;
}
catch (System.Data.SqlClient.SqlException e)
{
throw new Exception(e.Message);
}
finally
{
}
}