UrbanPro
true
default_background

Learn .NET MVC from the Best Tutors

  • Affordable fees
  • 1-1 or Group class
  • Flexible Timings
  • Verified Tutors
✕

Search in

Export To Excel using StringBuilder in ASP.net MVC C#

M
Mohammad Shafi
18/10/2016 0 View Comments1
 public ActionResult Export()  
   {  
     StringBuilder sb = new StringBuilder();  
     //static file name, can be changes as per requirement  
     string sFileName = "filename.xls";  
     //Bind data list from edmx  
     var Data = objEntities.citymaster.Take(10).ToList();  
     if (Data != null && Data.Any())  
     {  
       sb.Append("<table style='1px solid black; font-size:12px;'>");  
       sb.Append("<tr>");  
       sb.Append("<td style='width:120px;'><b>City Name</b></td>");  
       sb.Append("<td style='width:300px;'><b>City Code</b></td>");  
       sb.Append("</tr>");  
       foreach (var result in Data)  
       {  
         sb.Append("<tr>");  
         sb.Append("<td>" + result.sCityName + "</td>");  
         sb.Append("<td>" + result.sCityCode + "</td>");  
         sb.Append("</tr>");  
       }  
     }  
     HttpContext.Response.AddHeader("content-disposition", "attachment; filename=" + sFileName);  
     this.Response.ContentType = "application/vnd.ms-excel";  
     byte[] buffer = System.Text.Encoding.UTF8.GetBytes(sb.ToString());  
     return File(buffer, "application/vnd.ms-excel");  
   }  
0 Dislike
Follow 1 Loading Spinner
Default Profile Photo

Please Enter a comment

Submit

N

N Chaitanya Reddy | 29/04/2020

Hi.. unable to open file in excel file, it is opening when tried to open a file in notepad which contains html code in string builder. Please help..

0 0

Other Lessons for You

While Working, Always Enhance Your Education !!
In Any sector or domain every one must upgrade their education academically or professioally. Since so many times our Woring Knowledge is good but academicically we are week at this front. For Excel...
Profile Photo

Inversion of Control
Problem You have classes that have dependencies on services or components whose concrete type is specified at design time. In this example, ClassA has dependencies on ServiceA and ServiceB. Figure 1 illustrates...
Profile Photo

Programming Practice Technique
Any Programming Language required an Algorithm. Algorithm - It is the finite set of instructions in which each and every instruction has the meaning, instructions are not ambiguous and all the instructions...
Profile Photo

Working with Delegates & Events in .NET
Events & Delegates A delegate is a reference type derived from the System.Delegate class which can be used to call methods of same matching signature.As you all know signature of a method is defined...
Profile Photo

Angular-2 Developer Training Program Syllabus
Angular2 Developer Training Program Syllabus: Introduction to Angular2. Why Angular2. Angular2 Features: Components, Services and Typescript. Angular2 Components: Templates, Modules, Services...
Profile Photo

Looking for .NET MVC ?

Learn from Best Tutors on UrbanPro.

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you
X

Looking for .NET MVC Classes?

The best tutors for .NET MVC Classes are on UrbanPro

  • Select the best Tutor
  • Book & Attend a Free Demo
  • Pay and start Learning

Learn .NET MVC with the Best Tutors

The best Tutors for .NET MVC Classes are on UrbanPro

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more