到MSOffice或Excel的GridView

codeprelang="c#"Response.Clear(); Response.Buffer=spanclass="code-keyword"true/span; Response.AddHeader(spanclass="code-string""/spanspanclass="code-string"content-disposition"/span, spanclass="code-string""/spanspanclass="code-string"attachment;filename=GridViewExport.csv"/span); Response.Charset=spanclass="code-string""/spanspanclass="code-string""/span; Response.ContentType=spanclass="code-string""/spanspanclass="code-string"application/text"/span;  GridView1.AllowPaging=spanclass="code-keyword"false/span; GridView1.DataBind();  StringBuildersb=spanclass="code-keyword"new/spanStringBuilder(); spanclass="code-keyword"for/span(spanclass="code-keyword"int/spank=spanclass="code-digit"0/span;k<GridView1.Columns.Count;k++){ spanclass="code-comment"///spanspanclass="code-comment"addseparator/spansb.Append(GridView1.Columns[k].HeaderText+spanclass="code-string"'/spanspanclass="code-string",'/span); } spanclass="code-comment"///spanspanclass="code-comment"appendnewline/spansb.Append(spanclass="code-string""/spanspanclass="code-string"\r\n"/span); spanclass="code-keyword"for/span(spanclass="code-keyword"int/spani=spanclass="code-digit"0/span;i<GridView1.Rows.Count;i++){ spanclass="code-keyword"for/span(spanclass="code-keyword"int/spank=spanclass="code-digit"0/span;k<GridView1.Columns.Count;k++){ spanclass="code-comment"///spanspanclass="code-comment"addseparator/spansb.Append(GridView1.Rows[i].Cells[k].Text+spanclass="code-string"'/spanspanclass="code-string",'/span); } spanclass="code-comment"///spanspanclass="code-comment"appendnewline/spansb.Append(spanclass="code-string""/spanspanclass="code-string"\r\n"/span); } Response.Output.Write(sb.ToString()); Response.Flush(); Response.End();/pre/code不要忘记添加这些命名空间-codeprelang="cs"spanclass="code-keyword"using/spanSystem.IO;spanclass="code-keyword"using/spanSystem.Text;/pre/code
乌玛・尚卡尔帕特尔

imgsrc=http://www.orcode.com/img/ico/smiley_smile.gif上面的链接，用于将数据导出到Excel中......{A}使用上述链接到C＃转换为VB...{S0的}
NikulDarji

使用DataTable的以EXCELL为codeprelang="cs"spanclass="code-keyword"private/spanspanclass="code-keyword"void/spanExportDataTable(DataTabledt){spanclass="code-keyword"string/spanattachment=spanclass="code-string""/spanspanclass="code-string"attachment;filename=a.xls"/span;HttpContext.Current.Response.Clear();HttpContext.Current.Response.AddHeader(spanclass="code-string""/spanspanclass="code-string"content-disposition"/span,attachment);HttpContext.Current.Response.ContentType=spanclass="code-string""/spanspanclass="code-string"application/vnd.ms-excel"/span;spanclass="code-keyword"string/spansTab=spanclass="code-string""/spanspanclass="code-string""/span;spanclass="code-keyword"foreach/span(DataColumndcspanclass="code-keyword"in/spandt.Columns){HttpContext.Current.Response.Write(sTab+dc.ColumnName);sTab=spanclass="code-string""/spanspanclass="code-string"\t"/span;}HttpContext.Current.Response.Write(spanclass="code-string""/spanspanclass="code-string"\n"/span); spanclass="code-keyword"int/spani;spanclass="code-keyword"foreach/span(DataRowdrspanclass="code-keyword"in/spandt.Rows){sTab=spanclass="code-string""/spanspanclass="code-string""/span;spanclass="code-keyword"for/span(i=spanclass="code-digit"0/span;i<dt.Columns.Count;i++){HttpContext.Current.Response.Write(sTab+dr[i].ToString());sTab=spanclass="code-string""/spanspanclass="code-string"\t"/span;}HttpContext.Current.Response.Write(spanclass="code-string""/spanspanclass="code-string"\n"/span);}HttpContext.Current.Response.End();}/pre/code的|桑杰古普塔
您好，

看我的答案:马丁Arapovic

|你可以试试这个工具{A3}
乌玛・尚卡尔帕特尔:嗨，使用下面的文章，它是我写的，我已经使用这个。它将提供格式Excel作为用户定义的格式。
{A4纸}

任何帮助，你可以写信给我。不要犹豫，{S}

Sarvesh库马尔・古普塔
也许，你可以使用Qt库首先〜〜很容易得到的〜〜