C#里面 将DataGridView 里面所有数据导入到 EXECL中去 急!!在线等!!!! 小弟对这方面不是很懂,请各位朋友给点点例子,别只大概的指点,谢谢!!! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 可以利用sql语句,把datagridview中的数据导入excel里 有几种方式:1.采用excel组件:首先添加对excel的引用而后using Microsoft.Office.Interop.Excel; private void ExportToExcel() { ApplicationClass excel = new ApplicationClass(); excel.Application.Workbooks.Add(XlWBATemplate.xlWBATWorksheet); //注:这里的ds就是你获得的datagridview的数据源dataset for (int i = 1; i <= ds.Tables[0].Columns.Count; i++) { excel.Cells[1, i] = ds.Tables[0].Columns[i - 1].ColumnName.ToString().ToUpper(); } for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { for (int j = 0; j < ds.Tables[0].Columns.Count; j++) { excel.Cells[i + 2, j + 1] = ds.Tables[0].Rows[i][j].ToString(); } } excel.Visible = true; excel.ScreenUpdating = true; } DataGrid导出excel导出Excel:private void OutExcel(DataGrid dg ,string name,string type){ dg.Visible=true;Response.Clear(); Response.Buffer= true; Response.Charset="GB2312";Response.AppendHeader("Content-Disposition",name);Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312");Response.ContentType = type;dg.EnableViewState = false;System.IO.StringWriter oStringWriter = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);dg.RenderControl(oHtmlTextWriter); Response.Write(oStringWriter.ToString());Response.End();} 如果要导出真正的excel参考http://www.google.com/search?hl=en&q=OleDB+Excel+site%3Acsdn.net Execl的保存路径怎么设置呢? GDI+绘制的饼图为什么显示不出来?? C#问题,高手来啊 C# 操作access数据库 关于显示接口,如何调用? select case 在c#如何用? 将数据导入电子表格时,如何设置电子表格的格式? 怎样托动一个没有标题栏的窗体!!!!100分 Log回报功能,求思路 求教 关于c#的线程问题 关于访问类实例化对象 c#中不明白的地方。。
1.采用excel组件:首先添加对excel的引用
而后using Microsoft.Office.Interop.Excel; private void ExportToExcel()
{
ApplicationClass excel = new ApplicationClass();
excel.Application.Workbooks.Add(XlWBATemplate.xlWBATWorksheet); //注:这里的ds就是你获得的datagridview的数据源dataset
for (int i = 1; i <= ds.Tables[0].Columns.Count; i++)
{
excel.Cells[1, i] = ds.Tables[0].Columns[i - 1].ColumnName.ToString().ToUpper();
}
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
for (int j = 0; j < ds.Tables[0].Columns.Count; j++)
{
excel.Cells[i + 2, j + 1] = ds.Tables[0].Rows[i][j].ToString();
}
}
excel.Visible = true;
excel.ScreenUpdating = true;
}
private void OutExcel(DataGrid dg ,string name,string type)
{ dg.Visible=true;
Response.Clear();
Response.Buffer= true;
Response.Charset="GB2312";
Response.AppendHeader("Content-Disposition",name);
Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312");
Response.ContentType = type;
dg.EnableViewState = false;
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
dg.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();
}