CODEWITHSUNDEEP
c#asp.netexport-to-excel
Pod Mays
Pod Mays

Reputation: 2583

Export to Excel, and change Sheet name

Here's the code I'm using:

HttpContext.Current.Response.Clear();
HttpContext.Current.Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "Single_Raw.xls"));
HttpContext.Current.Response.ContentType = "application/ms-excel";

using (StringWriter sw = new StringWriter())
{
    using (HtmlTextWriter htw = new HtmlTextWriter(sw))
    {
        Table tb = new Table();
        TableRow tr = new TableRow();

        tr.Cells.Add((rawRow((lblPOR1.Text.Substring(0, 4)), (lblPOR1.Text.Substring(5, 3)), (lblPOR1.Text.Substring(9, 3)), lblPNL.Text.ToString())));

        TableCell cell3 = new TableCell();
        cell3.Text = " ";

        TableRow tr2 = new TableRow();
        tr2.Cells.Add((rawRow((lblPOR2.Text.Substring(0, 4)), (lblPOR2.Text.Substring(5, 3)), (lblPOR2.Text.Substring(9, 3)), lblPNL.Text.ToString())));

        tb.Rows.Add(tr);
        tb.Rows.Add(tr2);

        tb.RenderControl(htw);

        HttpContext.Current.Response.Write(sw.ToString());
        HttpContext.Current.Response.End();
    }
}

It can specify the filename but not the Sheet name. Is it possible?

Upvotes: 2

Views: 4317

Answers (1)

Shoban
Shoban

Reputation: 23016

I am using ExcelPackage to generate excel sheets and you have the option to specify sheet name too.

Example :

ExcelWorksheet worksheet = xlPackage.Workbook.Worksheets.Add("Tinned Goods");

Upvotes: 1

Related Questions