Office Open XML, Excel Object Model and .Net

Question

Hi all.  I have a question regarding OfficeOpen XML and the.Net platform.  I work with Excel via Automation using VB.  I want to understand how the new XML formats for Excel 2007 are going to affect my approach to developing solutions for Excel.  Typically I use Automation by referencing the Excel Object Model 12.0 in my VB projects.  This allows me to access the Excel Object Model and the project runs by opening Excel on the client side. 

As I move forward, I now know that I can work with the Office Open XML and Open Document Format (ODF) for all spreadsheets.  If I decide to move towards a web-based solftware solution (say ASP.Net) and focus on the new XML format (Office Open XML and ODF), does this imply that I will no longer use the Excle Object Model via Automation?  Does this mean that I have to learn a new Object model for Excel XML and ODF?  Assume further that I may want to dump the spreadsheets into a SQL/Oracle Server at some point and reassemble them.  How do these new formats aid me in doing so?

I cannot seem to find any information to answer these questions.

Thanks

EM

Answer 1

Thanks for your post, however I regret to inform you this is not the correct forum to get you the answers you need. This forum is for supporting Microsoft Open Protocol Documentation.

Please re-post your question at the following forum and they should be able to assist you:

http://openxmldeveloper.org/forums/default.aspx

Thanks!

Hongwei Sun -MSFT

---

Hongwei Sun -MSFT