/// <summary>
/// 将指定的电子表格,检索出来,填充到数据集
/// </summary>
/// <param name="strFilePath">Excel 绝对路径</param>
/// <param name="strSheetName">Excel 里面的表格名 如sheet1</param>
/// <returns>DataSet</returns>
public DataSet CreateDataSource(string strFilePath, string strSheetName)
{
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strFilePath + ";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'";
string strSQLCommand = "SELECT * FROM [" + strSheetName + "$]";
DataSet ds = new DataSet();
try
{
System.Data.OleDb.OleDbDataAdapter ad = new System.Data.OleDb.OleDbDataAdapter(strSQLCommand, strConn);
//填充,生成一个和原始电子表格一模一样的表
ad.Fill(ds, "ds1");
this.strReturnMessage = "Data List...";
}
catch (Exception ex)
{
this.strReturnMessage = "Error Message:" + ex.Message;
ds = null;
}
return ds;
}
/// 将指定的电子表格,检索出来,填充到数据集
/// </summary>
/// <param name="strFilePath">Excel 绝对路径</param>
/// <param name="strSheetName">Excel 里面的表格名 如sheet1</param>
/// <returns>DataSet</returns>
public DataSet CreateDataSource(string strFilePath, string strSheetName)
{
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strFilePath + ";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'";
string strSQLCommand = "SELECT * FROM [" + strSheetName + "$]";
DataSet ds = new DataSet();
try
{
System.Data.OleDb.OleDbDataAdapter ad = new System.Data.OleDb.OleDbDataAdapter(strSQLCommand, strConn);
//填充,生成一个和原始电子表格一模一样的表
ad.Fill(ds, "ds1");
this.strReturnMessage = "Data List...";
}
catch (Exception ex)
{
this.strReturnMessage = "Error Message:" + ex.Message;
ds = null;
}
return ds;
}