/// <summary>
/// DataSet를 액셀로 저장한다
/// </summary>
/// <param name="oPage">Page</param>
/// <param name="dl">DataReader</param>
/// <param name="fname">저장할 파일명</param>
public static void SaveExcel(Page oPage, DataSet ds, string fname)
{
 DataGrid dg = new DataGrid();

 dg.DataSource = ds;
 dg.DataBind();

 string sFileName = fname + "_" + DateTime.Now.ToString("yyyyMMdd") + ".xls";
 oPage.Response.Clear();
 oPage.Response.AddHeader("content-disposition", "attachment;filename=" + sFileName);
 oPage.Response.ContentType = "application/vnd.xls";
 oPage.Response.Write("<META HTTP-EQUIV=\"Content-Type\" CONTENT=\"text/html; charset=utf-8\">");

 System.IO.StringWriter stringWriter = new System.IO.StringWriter();
 System.Web.UI.HtmlTextWriter htmlWriter = new HtmlTextWriter(stringWriter);
 dg.RenderControl(htmlWriter);

 oPage.Response.Write(stringWriter.ToString());
 oPage.Response.End();
}

'ASP.NET' 카테고리의 다른 글

이메일 유효 테스트  (0) 2015.05.28
Base64 Encode & Decode  (0) 2015.05.28
문자열을 MD5로 암호화  (0) 2015.05.28
Html 태그 없애기  (0) 2015.05.28
지정한 길이만큼 랜덤으로 문자열를 만들어 반환한다  (0) 2015.05.28
Posted by 따랑
,