try
{
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=e:\\aa.xls;Extended Properties=Excel 8.0;";
OleDbConnection conn = new OleDbConnection(strConn);
System.Data.OleDb.OleDbCommand cmd = new OleDbCommand();
conn.Open();
cmd.Connection = conn;
for (int i = 0; i < dgv.Rows.Count; i++)
{
cmd.CommandText = "INSERT INTO [sheet1$] (aa,bb) VALUES('" + dgv.Rows[i].Cells[0].Value + "','"
+ dgv.Rows[i].Cells[1].Value + "')"; cmd.ExecuteNonQuery();
}
conn.Close();
}
catch (System.Data.OleDb.OleDbException ex)
{
System.Diagnostics.Debug.WriteLine("写入Excel发生错误:" + ex.Message);
}
{
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=e:\\aa.xls;Extended Properties=Excel 8.0;";
OleDbConnection conn = new OleDbConnection(strConn);
System.Data.OleDb.OleDbCommand cmd = new OleDbCommand();
conn.Open();
cmd.Connection = conn;
for (int i = 0; i < dgv.Rows.Count; i++)
{
cmd.CommandText = "INSERT INTO [sheet1$] (aa,bb) VALUES('" + dgv.Rows[i].Cells[0].Value + "','"
+ dgv.Rows[i].Cells[1].Value + "')"; cmd.ExecuteNonQuery();
}
conn.Close();
}
catch (System.Data.OleDb.OleDbException ex)
{
System.Diagnostics.Debug.WriteLine("写入Excel发生错误:" + ex.Message);
}
如果想直接操作excel的话
可以引用excel.dll等三个文件
然后就可以直接操作execl了
包括建立新文件或者在文件内操作具体的单元格有问题的话可以给我发邮件交流
{
try
{
HttpResponse resp;
resp = Page.Response;
resp.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
resp.AppendHeader("Content-Disposition", "attachment;filename=" + FileName);
string colHeaders = "", ls_item = "";
int i = 0; //定义表对象与行对像,同时用DataSet对其值进行初始化
DataTable dt = ds.Tables[0];
DataRow[] myRow = dt.Select("");
//取得数据表各列标题,各标题之间以\t分割,最后一个列标题后加回车符
for (i = 0; i < dt.Columns.Count - 1; i++)
{
colHeaders += dt.Columns[i].Caption.ToString() + "\t";
}
colHeaders += dt.Columns[i].Caption.ToString() + "\n";
//向HTTP输出流中写入取得的数据信息
resp.Write(colHeaders);
//逐行处理数据
foreach (DataRow row in myRow)
{
//在当前行中,逐列获得数据,数据之间以\t分割,结束时加回车符\n
for (i = 0; i < dt.Columns.Count - 1; i++)
{
ls_item += row[i].ToString() + "\t";
}
ls_item += Tools.DeptName(row[i].ToString()) + "\n";
//当前行数据写入HTTP输出流,并且置空ls_item以便下行数据
resp.Write(ls_item);
ls_item = "";
} //写缓冲区中的数据到HTTP头文件中
resp.End();
}
catch (Exception ex)
{
MessageBox.Show(this, ex.Message);
}
}