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

http://excelpackage.codeplex.com/

And the documentation : http://excelpackage.codeplex.com/wikipage?title=Creating%20an%20Excel%20spreadsheet%20from%20scratch&referringTitle=Home
Sum Green replied to Priya on 24-Feb-13 08:47 PM
        Workbook book = new Workbook();
        book.LoadFromFile(@"Test.xlsx");
        Worksheet sheet = book.Worksheets[0];
        sheet.Name = "Address";

I use the ASP.NET Excel library introduced in this project: http://spreadsheet.codeplex.com/