Examples of programming with SpreadsheetML

Erika is working on pulling together more coding examples for the OpenXML formats. We’ve seen a bunch of stuff around WordprocessingML, and now they are starting to work on some good examples with SpreadsheetML and PresentationML. So if you’ve ever wanted to build processes that consumed or generated Excel files, here a great starting point: http://blogs.msdn.com/erikaehrli/archive/2007/03/08/VisualHowTosExcel2007TheOfficeOpenXmlFormats.aspx

We’ve had folks asking for years if there could be an easier way to work against Excel files outside of Excel (for server side processing, etc.). The earlier version of the SpreadsheetML format introduced in Office XP was a great first step, but now with the new SpreadsheetML that’s part of the OpenXML formats you have complete control.


Comments (2)

  1. Luciano says:

    where’s the problem with the CSV exporting?

  2. nksingh says:

    CSV doesn’t contain all the formatting or formulae that might be in an excel sheet.  I think the point of SpreadsheetML is to be able to work on the spreadsheet itself, not only on the data.

    E.g:  if you don’t like the 1900 bug so much, you could write an app to inspect the XML for your spreadsheet and make conversions to eliminate those formulas.