본문 바로가기

SW/C#

[C#] Dataset 을 엑셀파일로 다운로드

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();

        }
    }
}