How to generate genuine excel report using string builder with C# code

In this article, I would like to explain "How to generate genuine excel report using string builder with Asp.net and C# code.In previous article i have already explained about PDF generation Generate Random Password for PDF with asp.net and Create Password protected PDF using iTextsharp with asp.net and c# .
Here I am going to explain about "Generation genuine excel report using string builder with Asp.net and C# code ". 

Please follow the steps

Step 1: Open visual studio from start menu. 
Step 2: In Visual studio in file menu create one new project 
Step 3: In Aspx page create on button using below tag

Step 4: Call one method with the GetGenuineExcelreport() btngenuineExcel_Click event as below

 

 protected void btngenuineExcel_Click(object sender, EventArgs e)
 {
  GetGenuineExcelreport("Excelreport"); // here "Excelreport" means your excel file name
 }

Step 5: Under GetGenuineExcelreport( string name) method write following code 

Step 6:Please add the following code in button click event

public void GetGenuineExcelr(string name)
        {
            string fileName = "attachment;fileName=" + name;

            Response.ContentType = "application/vnd.ms-excel";

            fileName = fileName + ".xls";

            Response.AddHeader("Content-Disposition", fileName);

            string[] font = new string[] {"Verdana", "Arial", "Sans-Serif" };

            Response.Charset = "";

            this.EnableViewState = false;

            StringBuilder sb = new StringBuilder(); 
            // Here we can find StringBuilder calss using using System.Text name space
            sb.Append("Write your Text Here");

            StringWriter strwiriter = new StringWriter();

            strwiriter.Write(sb.ToString());

            HtmlTextWriter ohtmltextwriter = new HtmlTextWriter(strwiriter);

            Repeater rt = new Repeater();

            rt.RenderControl(ohtmltextwriter);

            Response.Write(strwiriter.ToString());

            Response.End();
            
        }

Step 7: Now run the application and click on "GenerateGenuineExcel" button the excel report will generate..you can customize your own data or from data set data. 

That's it..Happy coding. 

Please let me know if you any issues..