Export excel with multiple sheets using html content

I have a C# code to export excel using html string for one data table. The code shown below.Using this code created single excel sheet with html string for one data table.But I don't know how to create multiple sheets with html string with these method for multiple data tables. Is there any way to add multiple sheets using this method or any other method?

private void ExportToExcel(string fileName, string contentType, DataTable dt, string RptName)

{

var ColumnCount = dt.Columns.Count;

GridView gv = new GridView();

var reportName = fileName;

var reportPritedOn = DateTime.Now.ToString("dd/MM/yyyy");

StringBuilder reportHtml = new StringBuilder();

gv.DataSource = dt;

gv.DataBind();

reportHtml.Append("" +

"");

reportHtml.Append("

");

Response.ClearContent();

Response.Buffer = true;

Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", reportName));

Response.ContentType = contentType;

StringWriter objSW = new StringWriter();

HtmlTextWriter objTW = new HtmlTextWriter(objSW);

Control parent = gv.Parent;

int GridIndex = 0;

if (parent != null)

{

GridIndex = parent.Controls.IndexOf(gv);

parent.Controls.Remove(gv);

}

gv.RenderControl(objTW);

if (parent != null)

{

parent.Controls.AddAt(GridIndex, gv);

}

reportHtml.Append("

" + RptName + "

");

reportHtml.Append(objSW.ToString());

reportHtml.Append("");

Response.Output.Write(reportHtml.ToString());

Response.Flush();

Response.End();

}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Rajkiran Swain8y ago
https://github.com/clarketm/TableExport/issues/64

https://stackoverflow.com/questions/48071464/export-excel-with-multiple-sheets-using-html-content-for-dataset

https://github.com/SheetJS/js-xlsx/issues/664