高人进来指点下 Excel导出的问题
try
{
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0; " + "Data Source= " + Path + "; " + "Extended Properties=Excel 8.0; ";
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
System.Data.OleDb.OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
for (int i = 0; i < fp2.Sheets[0].RowCount - 1; i++)
{
if (fp2.Sheets[0].Cells[i, 0].Text != " ")
{
cmd.CommandText = "INSERT INTO [sheet1$] (工号,姓名,部门,职务,日期,时间) VALUES( ' " + fp2.Sheets[0].Cells[i, 0].Text + " ', ' " +
fp2.Sheets[0].Cells[i, 1].Text + " ', ' " + fp2.Sheets[0].Cells[i, 2].Text + " ', ' " + fp2.Sheets[0].Cells[i, 3].Text +
" ', ' " + fp2.Sheets[0].Cells[i, 4].Text + " ', ' " + fp2.Sheets[0].Cells[i, 5].Text + " ') ";
cmd.ExecuteNonQuery();
}
}
conn.Close();
return true;
}
catch (
System.Data.OleDb.OleDbException ex)
{