ASP.NET - Naming Excel Sheet without using Excel Application class

Asked By Priya on 18-Feb-13 05:20 AM
Hi All,
I am creating an Excel sheet using HtmlTextWriter and HttpContext.Current.Response. The file is getting creating successfully but the sheet gets a the name "Sheet1" by default.
I need to rename this sheet name but without using the Microsoft Office Excel Interop services.
Kindly help.
Danasegarane Arunachalam replied to Priya on 18-Feb-13 06:45 AM
That is not possible using default HtmlTextWriter. And you could try the

And the documentation :
Sum Green replied to Priya on 24-Feb-13 08:47 PM
        Workbook book = new Workbook();
        Worksheet sheet = book.Worksheets[0];
        sheet.Name = "Address";

I use the ASP.NET Excel library introduced in this project: