SSRS 2012 - Excel Renderer for Microsoft Excel 2007-2010 and Microsoft Excel 2003

Excel Renderer for Microsoft Excel 2007-2010 and Microsoft Excel 2003

The Reporting Services Excel rendering extension, new in SQL Server 2012, renders a report as an Excel document that is compatible with Microsoft Excel 2007-2010 as well as Microsoft Excel 2003 with the Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint installed. The format is Office Open XML and the file extension is XLSX.

This Excel-rendering extension removes limitations of the earlier version, compatible with Excel 2003. The following lists the improvement in the rendering extension:

• Maximum rows per worksheet is 1,048,576.
• Maximum columns per worksheet is 16,384.
• Number of colors allowed in a worksheet is approximately 16 million (24-bit color).
• ZIP compression provides smaller files sizes.