none
Exporting data to Excel from rdl file (SSRS report) RRS feed

  • Question

  • A report contains 103762 rows and when I am trying to export the data to Excel it is throwing an error "Excel rendering extension: the number of rows exceeds the maximum rows per sheet in this format. Requested rows: 103762, maximum number of rows: 65536". No error occurs when exporting data from reports when the report contains rows less than 65536.

    Please suggest.


    Wednesday, February 11, 2015 11:38 AM

Answers

  • Older versions of Excel (.xls extension) were limited to 64k rows and 256 columns. Newer versions allow for something over a million. Any chance you're using an older version?

    Also, if you're using an integer variable to point to rows, integers end at 65K so switch to double.

    Wednesday, February 11, 2015 12:53 PM