XML file size limitation?

V

Vitalik

Hello,

I'd like to load a spreadsheet in .xml file format into a Spreadsheet
component using its XMLURL property. Its size as reported by Windows
Explorer is 48,333 KB. Available physical RAM is > 120 MB. The error
message is: "Unspecified error" and is reported by
Microsoft.Office.Interop.Owc11 component. Even if it's not size related, I
still would like to know if there is any physical file size limit, since we
may encounter even larger files.

Thanks,
Vitaliy
 
A

Alvin Bruney - MVP ASP.NET

You are probably running into an upper end there. That's why i explain in
the black book that this type of load should best be done in CSV format
because the footprint is not as large. Basically, the rendering of the XML
data is what kills the OWC object - assuming that you are within the Excel
row limitation ofcourse.

--
Regards,
Alvin Bruney

Shameless Author Plug
[The Microsoft Office Web Components Black Book with .NET]
www.lulu.com/owc, Amazon, Barnes & Noble etc
Forth-coming VSTO.NET
 

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

Similar Threads

import XML data...Is there a size limit on the import? 0
Access-->XML-->Excel: Size Limitations? 0
ANN: XMLMax Virtual XML Editor Released 0
Excel file size limitation 5
xml import....Size limit?? Can the XML file be split?? 0
OWC10 xmlurl (passes) vs. OWC11 xmlurl (fails) 5
Access-->XML-->Excel: File size issue??? 0
Excel File Size Limit 4

Top