OWC10 and XLMData

[Dorota Papiernik]

Hi,
I use OWC10 Spreadsheet in my application (Win Form). I use XMLData property
of a spreadsheet object to save user work in spreadsheet to txt file (The
value of XMLData property is written to txt file ). When user want to come
back to his previous work he just has to open txt file where his work
(XMLData) has been written. It is done by operations:

string strXML;
AxOWC10.AxSpreadsheet xlsSpread

/*1*/ strXML = openReader.ReadToEnd(); // previous saved XMLData is reading
from txt file
/*2*/ xlsSpread.XMLData = strXML;

One of users has created a big report in OWC10 Spreadsheet (report has 100
sheets) and has saved the XMLData to txt file. File with XMLData has size
50MB. Now when he tries to read this XMLData from file (line /*1*/) and set
XMLData property of a spreadsheet object (line /*2*/) he has an error in line
/*2*/ : "Unspecified error". Operation in line /*1*/ is OK.
Is there any limits on XMLData property of a spreadsheet object. How big
XMLData can be to work properly?

Thank you for any information
Dorota Papiernik

 

[Alvin Bruney [MVP]]

Not necessarily an OWC error, you can't move that much data in a web page to
begin with. Trim the working set to a few sheets. Explain to the user that
this is a web limitation.

 

[Dorota Papiernik]

Thank you Alvin for the answer.
I have not put OWC Spreadsheet on web page. I use it in my Windows
Application (Visual Studio 2003 project, C#). I’m using OWC on my windows
form. So this is not web limitation.

Regards,
Dorota Papiernik

 

[Alvin Bruney [MVP]]

Sorry about jumping the gun. The limitation exists in the OWC render
process. It will load the data, however when it attempts to render the data,
it will lock up. If you can't absolutely reduce the dataset, you can handle
the onload event and set a smaller used range. See if that helps.

I've found that converting the XMLDATA to CSVDATA format will allow the
component to load allow more data because XML is inherently heavier than CSV
format. That would be your second option to try out. However, you will lose
the ability to format the data.

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless author plug
Excel Services for .NET is coming...
OWC Black book on Amazon and
www.lulu.com/owc

 

[Dorota Papiernik]

Alvin, thank you for your reply and for information.

Regards,
Dorota Papiernik