locked
How to change ExportToExcel2007 to ExportToExcel2003 in SSRS RRS feed

  • Question

  • User269846090 posted

    I have generated SSRS report using reportviewer in SQL server-2008,  If i export that report to Excel that will generate Microsoft Excel-2003 thats fine.

    But now I upgraded the sql server to Sql server-2012, now i generating those reports , if i export that to Excel, It generating in Microsoft Excel-2007. But It should export to Excel-2003, How can i change that export from excel2007 to excel2003 for Sql server 2012 report viewer using SSRS?

    Wednesday, January 22, 2014 2:01 AM

Answers

  • User816363141 posted

    Hi,

    The previous version of the Excel rendering extension, compatible with Microsoft Excel 2003, is renamed to Excel 2003. Only the Excel rendering extension is available by default. You must update the Reporting Services configuration files to make the Excel 2003 rendering extension available. The content type of files generated by this renderer is application/vnd.ms-excel and the file name extension of files is .xls. This renderer provides backwards compatibility with Microsoft Excel 2003. To use the Excel renderer instead of the earlier Excel 2003 renderer, install the Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint.

    But the Microsoft Excel 2003 rendering extension is deprecated. The features are still available in the release in which they are deprecated; however the features are scheduled to be removed in a future release of SQL Server. Deprecated features should not be used in new applications.The Reporting Services BIFF8 rendering extensions Reporting Services reports to the Microsoft Word and Microsoft Excel 1997-2003 binary interchange file format. SQL Server 2012 includes extensions that render in the Microsoft Office 2007-2010 Open XML format.

    For more information, see

    http://msdn.microsoft.com/en-us/library/dd255234.aspx

    Deprecated Features in SQL Server Reporting Services in SQL Server 2012.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, January 24, 2014 12:30 AM