Problems sending large spreadsheets to client

J

Josh

My OWC11 ASP.Net application uses the server version of the spreadsheet
component to generate XML data that it then sends to a client version of the
spreadsheet component. It does this in (I believe) the typical way (i.e.,
Response.Write oSS.XMLData).

For small to medium size spreadsheets, this works just fine.

However, when the spreadsheet gets big (say more than 1m of XML) I start
getting the following error message:

The Microsoft Office Component could not load the XML data.
An XML spreadsheet document must contain a <Workbook> tag as its root
node.

I've examined both small (working) and large (failing) XML produced on the
server and they all look OK (i.e., they start with "<ss:Workbook ..." and
end with "</ss:Workbook>")

Any thoughts? Is there some limit on the size of the string you can
Response.Write in ASP.Net?

TIA,

josh
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top