Showing posts with label suspect. Show all posts
Showing posts with label suspect. Show all posts

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
>