
/**//// <summary>
/// 匯出Excel
/// </summary>
/// <param name="ds">數據集</param>
public static void InitExcel(DataSet ds)
...{
DataGrid dgExport = null;
StringWriter strWriter = null;
HtmlTextWriter htmlWriter = null;
System.Data.DataTable dt = ds.Tables[0];
for( int i=0; i < dt.Rows.Count; i++ ) 
...{
for( int j=0; j < dt.Columns.Count; j++ )
...{
string temp = dt.Rows[i][j].ToString();
bool flag = false;
while(temp.IndexOf(" ") != -1)
...{
temp = temp.Replace(" "," <br> ");
flag = true;
}
if( flag )
dt.Rows[i][j] = temp;
}
}
if( dt != null ) 
...{
HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";
HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF8;
HttpContext.Current.Response.Charset = "";
strWriter = new StringWriter();
htmlWriter = new HtmlTextWriter(strWriter);
dgExport = new DataGrid();
dgExport.DataSource = dt.DefaultView;
dgExport.AllowPaging = false;
dgExport.HeaderStyle.ForeColor = System.Drawing.Color.White;
dgExport.HeaderStyle.BackColor = System.Drawing.Color.Gray;
dgExport.DataBind();
dgExport.RenderControl(htmlWriter);
HttpContext.Current.Response.Write(strWriter.ToString());
HttpContext.Current.Response.End();
}
}
本文介紹了一種將數據集(DataSet)匯出為Excel文件的方法。該方法通過對數據進行處理,確保數據能在Excel中正確顯示,包括對特殊字符的轉換及格式調整等。
2245

被折叠的 条评论
为什么被折叠?



