winform中如何把datagrid中的数据写入excel2003中,有详细代码更好
解决方案 »
- 求C#版QQ农场外挂
- 求各位给个项目给我做练习。
- 在鼠标停留时如何改变GridView某一行的颜色
- 如果一场比赛一个队 胜/平/负 的概率都是1/3, 求今晚 罗马尼亚/意大利/法国 出线的概率各是多少?
- XMLHTTPRequest和HttpWebRequest的问题,即向网址发送和接收XML的问题
- 急求《C语言程序设计〉(谭浩强),下载不了!!!
- datagridview合并单元格问题
- 请问我的窗体按最大化时如何将控件均分的出现在窗口中?
- 菜鸟问题!
- 出出主意!我准备装机去搞VS。NET,什么样的好呢?关键是要省一些银子!
- 请版主,思归等高手帮忙。EXCEL难题。
- 关于excel表格倒入dataGrid的问题
private void CreateExcel(string strName,DataTable dt)
{
Excel._Application excel= new Excel.ApplicationClass();;
int rowIndex=1;
int colIndex=0;
System.Reflection.Missing miss = System.Reflection.Missing.Value;
Excel.Workbooks objbooks = (Excel.Workbooks)excel.Workbooks;
Excel.Workbook objbook = (Excel.Workbook)(objbooks.Add(miss));
Excel.Worksheet objsheet = (Excel.Worksheet)objbook.ActiveSheet; foreach(DataColumn col in dt.Columns)
{
colIndex++;
excel.Cells[1,colIndex]=col.ColumnName;
} foreach(DataRow row in dt.Rows)
{
rowIndex++;
colIndex=0;
foreach(DataColumn col in dt.Columns)
{
colIndex++;
excel.Cells[rowIndex,colIndex]=row[col.ColumnName].ToString();
}
}
objsheet.SaveAs (strName,miss,miss,miss,miss,miss,Excel.XlSaveAsAccessMode.xlNoChange,miss,miss);
objbook.Close(false,miss,miss);
objbooks.Close();
excel.Quit(); //System.Runtime.InteropServices.Marshal.ReleaseComObject();
System.Runtime.InteropServices.Marshal.ReleaseComObject(objsheet);
System.Runtime.InteropServices.Marshal.ReleaseComObject(objbook);
System.Runtime.InteropServices.Marshal.ReleaseComObject(objbooks);
System.Runtime.InteropServices.Marshal.ReleaseComObject(excel);
GC.Collect();
}
出处
if(DataGrid1.Items.Count==0)
{
Response.Write("<script>alert('对不起,你没有查询到任何记录,不能导出数据')</script>");
}
else
{ Response.Clear();
Response.Buffer= true;
Response.Charset="GB2312";
Response.AppendHeader("Content-Disposition","attachment;filename=FileName.xls");
Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312");
//设置输出流为简体中文
Response.ContentType = "application/ms-excel";
//设置输出文件类型为excel文件。
this.EnableViewState = false;
System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN",true);
System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad);
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
DataGrid1.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();
}
^_^,也是论坛上看到的,自己没调过,试试看@