Improvements Made to the Final Open XML SDK 2.0 compared to the December 2009 CTP

re: Improvements Made to the Final Open XML SDK 2.0 compared to the December 2009 CTP

Zeyad Rajabi — Thu, 27 May 2010 18:52:07 GMT

Thanks for the suggestions guys. I will plan on writing some future posts on these topics.

@adamm_wr - The issue may be due to the encoding of the XML parts. Make sure the encoding is UTF based rather than ANSI.

re: Improvements Made to the Final Open XML SDK 2.0 compared to the December 2009 CTP

Mike — Wed, 26 May 2010 15:53:23 GMT

More more thing...my code needs to run on big unix box. What needed is open source c++ lib for xlsx.

re: Improvements Made to the Final Open XML SDK 2.0 compared to the December 2009 CTP

adamm_wr — Wed, 26 May 2010 00:08:34 GMT

@mike

from my understanding the Open XML sdk is designed for manipulating the underlying XML of the Open XML documents, not for analyzing or data processing.

There exists a oledb driver for connecting to excel documents that would allow you to pull out information using SQL syntax. its named "Microsoft.ACE.OLEDB.12.0" for xlsx, xlsm, xlsb files. We use this in our software product and we have tested it on excel files with 100,000 rows.

re: Improvements Made to the Final Open XML SDK 2.0 compared to the December 2009 CTP

adamm_wr — Wed, 26 May 2010 00:00:57 GMT

Hi brian,

I am having trouble with the validation code posted in this post:

blogs.msdn.com/.../finding-open-xml-errors-with-open-xml-sdk-validation.aspx

i would post in comments but they are disabled for that post.

there is a forum post that outlines the problem similar to mine:

social.msdn.microsoft.com/.../a516bed7-05d7-4d58-8348-0a3a0c5af966

re: Improvements Made to the Final Open XML SDK 2.0 compared to the December 2009 CTP

Mike — Thu, 13 May 2010 17:01:35 GMT

Can SDK 2.0 parse very very large xl documents(BILLIONS cells) with speed and small memory foot print? If it builds the entire DOM in-memory then this will NOT work. It should use SAX parsing with some type of off memory caching and transparent to developers/APIs.

May be this is documented somewhere that I have not found as am just starting to upgrade my code to OpenXML from c++/biff8. Am building server side application for very high volume and performance XL streaming.

-Mike

re: Improvements Made to the Final Open XML SDK 2.0 compared to the December 2009 CTP

abelmebratu — Wed, 12 May 2010 19:22:16 GMT

Can you show us how to copy/export a worksheet from one workbook to another?

Thank you,

- Abel