在C#里面如何将从SQL SERVER里面查到的数据输出到 EXCEL里面,谢谢

[panlei_pl]

急!!!!

[_jfeng]

ding

[jamesfay]

SQL可以直接完成，C#类似。

SELECT * FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\Finance\account.xls";
User ID=Admin;Password=;
Extended properties=Excel 5.0')...xactions

[AlexVS]

用C#编很快的,就一小段代码,而且可以转成不同的格式

代码如下:

Response.Clear();
Response.Buffer= true;
Response.Charset="GB2312";
Response.AppendHeader("Content-Disposition","attachment;filename=指定Excel文件名");
Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312");//设置输出流为简体中文
Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。(此项可改,如要输出WORD格式,则最后为ms-word)
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);
this.DataGrid1.RenderControl(oHtmlTextWriter); //此处为输出DataGrid控件的值,其他控件应该也可以,但必须为表格.而且BUTTUN和模板列不能输出,超链列可输出.如果有这些列,必须在之前把该列VISABLE属性定义为FALSE;
Response.Write(oStringWriter.ToString());
Response.End();