Maximum number of rows in an excel

[dssd]

I would be rendering a report into excel. What is the maximum number of rows that can be rendered? We might have a million rows that need to be displayed. I know a weird to display so many

[Cognos_World]

If you are using Excel 2007/ Excel 2010 the max number of rows in a worksheet is 1 million.
For Excel 2003 it was 65000.

Hope this helps.

[Grim]

Full details here:
http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx

PS. Don't use Cognos as an "interim" ETL tool to dump data to excel. Ask your DBA to do this if you need it. It's much faster.

[Lynn]

PS. Don't use Cognos as an "interim" ETL tool to dump data to excel. Ask your DBA to do this if you need it. It's much faster.

I'll second that!!

Also, I believe a result set that is more than 65,000 rows gives you multiple sheets in the file with no more than 65,000 on each. Cognos does this even when rendering to Excel 2007 for backward compatibility.

As noted in the article, a workaround is to render as CSV and then open in Excel.

http://www-01.ibm.com/support/docview.wss?uid=swg21419957

[paulym]

The article listed in the prior note refers to Cognos 8.  Does Cognos 10 still only allow 65,000 rows per worksheet?  Can this be changed to allow Excel 2007 row limits in Cognos 10?

Thank you.

[Lynn]

The link I posted lists applicable software versions as 8.3, 8.4, 8.4.1, 10.1

I am using Cognos 10 and the behavior is just as described. It splits data across worksheets at the 65K row mark.

Maybe someone on the admin side would know if there is any setting change to control it.