SSRS report - export to Excel

Question

I am exporting a report into excel which runs in ReportViewer in Local Mode - NO SSRS server.
The command is this:
ReportViewer1.LocalReport.Render("EXCEL", null, out mimeType, out encoding, out extension, out streamids, out warnings);

That creates xls file, while I want xlsx. Is that possible?

Thanks

Answer 1

That creates xls file, while I want xlsx. Is that possible?

You already use the format parameter "EXCEL", there is no other for Excel format and if you get XLS, then may because you use an old version of ReportViewer.

Answer 2

Hi @mark goldin ,
By right-clicked on the project ，choose ‘manage NuGet packages ’ ，in the installed segment，you can search for the ‘ ReportViewer’ ，and then you will get the ReportViewer installed version .

Best Regards,
Isabella

---

If the answer is the right solution, please click "Accept Answer" and upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

Hi @mark goldin ，

I think this is the latest ，you can choose the Browser segment ，and search for it .

Best Regards,
Isabella

Answer 4

render to EXCELOPENXML

use this to get the available modes

      var rv = new Microsoft.Reporting.WinForms.ReportViewer(); // Corrected namespace and class instantiation

      foreach (var re in rv.LocalReport.ListRenderingExtensions())

      {

          Debug.WriteLine(re.Name.ToString());

      }

      //Excel

      //EXCELOPENXML

      //IMAGE

      //PDF

      //WORD

      //WORDOPENXML