private DataSet xsldata() //定义一个dataset并把excel数据读入dataset
{
dataGridView1.Rows.Clear();
OpenFileDialog openFile = new OpenFileDialog();//打开文件对话框。
openFile.Filter = ("Excel 文件(*.xls)|*.xls");//后缀名。
if (openFile.ShowDialog() == DialogResult.OK)
{
string filename = openFile.FileName; //文件路径
string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filename + ";Extended Properties='Excel 8.0;IMEX=1'";
OleDbConnection Conn = new OleDbConnection(strCon);
string strCom = "SELECT * FROM [sheet1$]";
Conn.Open();
OleDbDataAdapter myCommand = new OleDbDataAdapter(strCom, Conn);
DataSet ds = new DataSet();
myCommand.Fill(ds, "[sheet1$]");
Conn.Close();
Conn.Dispose();
return ds; //返回dataset
}
else
return null;
}
//导入excel
private void toolStripButton1_Click(object sender, EventArgs e)
{
try
{
DataSet ds = xsldata();
if (ds == null) //如果录入dataset的数据为空(没有点击导入或者直接退出),则{}不执行
{ }
else
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
{
dataGridView1.Rows.Clear();
OpenFileDialog openFile = new OpenFileDialog();//打开文件对话框。
openFile.Filter = ("Excel 文件(*.xls)|*.xls");//后缀名。
if (openFile.ShowDialog() == DialogResult.OK)
{
string filename = openFile.FileName; //文件路径
string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filename + ";Extended Properties='Excel 8.0;IMEX=1'";
OleDbConnection Conn = new OleDbConnection(strCon);
string strCom = "SELECT * FROM [sheet1$]";
Conn.Open();
OleDbDataAdapter myCommand = new OleDbDataAdapter(strCom, Conn);
DataSet ds = new DataSet();
myCommand.Fill(ds, "[sheet1$]");
Conn.Close();
Conn.Dispose();
return ds; //返回dataset
}
else
return null;
}
//导入excel
private void toolStripButton1_Click(object sender, EventArgs e)
{
try
{
DataSet ds = xsldata();
if (ds == null) //如果录入dataset的数据为空(没有点击导入或者直接退出),则{}不执行
{ }
else
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
dataGridView1.Rows.Add((i + 1).ToString(),
ds.Tables[0].Rows[i][0].ToString(),
ds.Tables[0].Rows[i][1].ToString(),
ds.Tables[0].Rows[i][2].ToString(),
ds.Tables[0].Rows[i][3].ToString(),
ds.Tables[0].Rows[i][4].ToString(),
ds.Tables[0].Rows[i][5].ToString(),
ds.Tables[0].Rows[i][6].ToString(),
ds.Tables[0].Rows[i][7].ToString(),
ds.Tables[0].Rows[i][8].ToString(),
ds.Tables[0].Rows[i][9].ToString(),
ds.Tables[0].Rows[i][10].ToString()
);
}
}
ds.Tables[0].Rows[i][0].ToString(),
ds.Tables[0].Rows[i][1].ToString(),
ds.Tables[0].Rows[i][2].ToString(),
ds.Tables[0].Rows[i][3].ToString(),
ds.Tables[0].Rows[i][4].ToString(),
ds.Tables[0].Rows[i][5].ToString(),
ds.Tables[0].Rows[i][6].ToString(),
ds.Tables[0].Rows[i][7].ToString(),
ds.Tables[0].Rows[i][8].ToString(),
ds.Tables[0].Rows[i][9].ToString(),
ds.Tables[0].Rows[i][10].ToString()
);
}
}
}
catch (Exception ex)
{
MessageBox.Show("" + ex.ToString() + "导入文件时出错,文件可能正被打开", "提示");
return;
}
catch (Exception ex)
{
MessageBox.Show("" + ex.ToString() + "导入文件时出错,文件可能正被打开", "提示");
return;
}
<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>