Comments by Member 10678104 (Top 7 by date)

Can anyone has another approach for this??

@Nathan Minier. I have already implemented this. multiple dataset in multiple sheet of same excel file. But I want multiple dataset to be export in "Multiple Excel file" not sheets of single excel

Tried this code. but on button click it opens only on file

public static void Exportds2Multiplesheets(DataSet ds, string Filename)
{
if (ds.Tables.Count == 0)
throw new ArgumentException("DataSet needs to have at least one DataTable", "dataset");
HttpResponse Response = System.Web.HttpContext.Current.Response;
string Fname = Filename + ".xlsx";
using (XLWorkbook wb = new XLWorkbook())
{
wb.Worksheets.Add(ds);
wb.Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Center;
wb.Style.Font.Bold = true;

Response.Clear();
Response.Buffer = true;
Response.Charset = "";
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.AddHeader("content-disposition", "attachment;filename=" + Fname);

using (MemoryStream MyMemoryStream = new MemoryStream())
{
wb.SaveAs(MyMemoryStream);
MyMemoryStream.WriteTo(Response.OutputStream);

Response.Flush();
Response.End();
}
}
using (XLWorkbook wb1 = new XLWorkbook())
{
wb1.Worksheets.Add(ds);
wb1.Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Center;
wb1.Style.Font.Bold = true;

Response.Clear();
Response.Buffer = true;
Response.Charset = "";
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.AddHeader("content-disposition", "attachment;filename=" + Fname);

using (MemoryStream MyMemoryStream = new MemoryStream())
{
wb1.SaveAs(MyMemoryStream);
MyMemoryStream.WriteTo(Response.OutputStream);

Response.Flush();
Response.End();
}
}
}