XLS Report - maximum rows?

rbuser

Hi Im using RB Pro 12.03 and was wondering if there is a limit to the amount
of rows that can be exported when using the XLS Report option?

I know in the later editions of Excel they can read more than the old limit
of 65,000 rows.

I have a report with 140,000 rows but is unable to be opened in Excel.

Regards,

Luke Johnston


__________ Information from ESET NOD32 Antivirus, version of virus signature database 5835 (20110131) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

nardmoseley

The XLS format has a maximum of 65,536 rows. (I don't know why MS decided
not
to take this format forward. To date, the XLS format retains the same max
row limitation.)

The latest versions of Office and Excel introduced the Office Open XML
format, which for Excel includes XLSX, XLSM, XLTX, XLTM, XLAM, and XLSB.
The Office Open XML format is an XML based format and has no relation to the
XLS format.

Here are a couple of links with more details...

http://en.wikipedia.org/wiki/Office_Open_XML

http://blogs.msdn.com/b/excel/archive/2006/07/20/671995.aspx

For your requirement you could try breaking output into different
sections. - produce multiple XLS documents.

For the future, perhaps ReportBuilder will add an XLSXReportDevice, thanks
for the feedback.



--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com

"

rbuser

Hi Nard,

I would love to see the new office or open office xml formats supported by
RB.
Editting or post processing a word document (*.docx or *.odt) would then be
more feasible.

Kind regards,
Jeroen R?ttink

rbuser

I would love to see support for later format Excel files that support more
than 65,536 rows.