读取Excel中的数据
/// <summary>
/// 转换Excel文件转换为DataSet
/// </summary>
/// <returns>DataSet</returns>
private DataSet GetExcelData()
{
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + this.textBox1.Text.Trim() +"; Extended Properties=Excel 8.0; ";
DataSet myDataSet = new DataSet();
try
{
OleDbConnection conn = new OleDbConnection(strConn);
//Sheet1$为Excel的工作表名称
OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [Sheet1$] ", strConn);
myCommand.Fill(myDataSet);
}
catch (Exception exp)
{
MessageBox.Show("导入Excel失败!!!"+exp.Message);
}
return myDataSet;
}
/// 转换Excel文件转换为DataSet
/// </summary>
/// <returns>DataSet</returns>
private DataSet GetExcelData()
{
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + this.textBox1.Text.Trim() +"; Extended Properties=Excel 8.0; ";
DataSet myDataSet = new DataSet();
try
{
OleDbConnection conn = new OleDbConnection(strConn);
//Sheet1$为Excel的工作表名称
OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [Sheet1$] ", strConn);
myCommand.Fill(myDataSet);
}
catch (Exception exp)
{
MessageBox.Show("导入Excel失败!!!"+exp.Message);
}
return myDataSet;
}
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步