SW/C#
[C#] Dataset 을 엑셀파일로 다운로드
류관장
2019. 9. 19. 17:06
public void GridToExcel(DataSet ds)
{
using (XLWorkbook wb = new XLWorkbook())
{
wb.Worksheets.Add(ds);
Response.Clear();
Response.Buffer = true;
Response.Charset = "";
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.AddHeader("content-disposition", "attachment;filename=Excel.xlsx");
using (MemoryStream MyMemoryStream = new MemoryStream())
{
wb.SaveAs(MyMemoryStream);
MyMemoryStream.WriteTo(Response.OutputStream);
MyMemoryStream.Close();
Response.Flush();
Response.End();
}
}
}