Office Open XML and "Excel Object Model" and .Net RRS feed

  • 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.


    Wednesday, April 1, 2009 8:53 PM