/// <summary>
/// 将excel文件导入到dataset中
/// </summary>
/// <param name="fileName">文件路径</param>
private void ImportXlsToData(string fileName)
{
string str= "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileName + ";Extended Properties=\"Excel 12.0;HDR=YES\"";
string oledbstr = "select * from [Sheet1$]";
OleDbConnection conn = new OleDbConnection(str);
try
{
conn.Open();
OleDbCommand com = new OleDbCommand(oledbstr, conn);
OleDbDataAdapter adp = new OleDbDataAdapter(com);
DataSet ds = new DataSet();
adp.Fill(ds);
}
catch (Exception err)
{
//显示错误信息
}
finally
{
conn.Close();
}
}
/// 将excel文件导入到dataset中
/// </summary>
/// <param name="fileName">文件路径</param>
private void ImportXlsToData(string fileName)
{
string str= "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileName + ";Extended Properties=\"Excel 12.0;HDR=YES\"";
string oledbstr = "select * from [Sheet1$]";
OleDbConnection conn = new OleDbConnection(str);
try
{
conn.Open();
OleDbCommand com = new OleDbCommand(oledbstr, conn);
OleDbDataAdapter adp = new OleDbDataAdapter(com);
DataSet ds = new DataSet();
adp.Fill(ds);
}
catch (Exception err)
{
//显示错误信息
}
finally
{
conn.Close();
}
}