Tuesday, March 27, 2012

Excel export problem

Hi,
When you want to use the Excel export function, you may never get the export
even if it is less than 64K rows.
I suspect that the xml format of the generated file is so large that the
client computer runs out of memory.
For a 64K rows export, the xml is probably 64M rows?
Any Excel binary export format in sight?
Thanks
PhilippeSP1 (released today) supports native Excel format export.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Philippe Cand" <please_reply_only@.NG.com> wrote in message
news:uzm7QyOWEHA.2196@.TK2MSFTNGP10.phx.gbl...
> Hi,
> When you want to use the Excel export function, you may never get the
> export
> even if it is less than 64K rows.
> I suspect that the xml format of the generated file is so large that the
> client computer runs out of memory.
> For a 64K rows export, the xml is probably 64M rows?
> Any Excel binary export format in sight?
> Thanks
> Philippe
>

No comments:

Post a Comment