Help with SpreadsheetDocument Stylesheet RRS feed

  • Question

  • Can someone share with me the process of creating and using the stylesheet fonts and cellformats, please? I am completely stock and cannot find infor anywhere on the web. Basically I want to create a stylesheet, set some fonts and cellformats, then when I create a cell I want to tell the cell to use a specific stylesheet / cellformat.

    thanks a bunch.
    Thursday, October 29, 2009 1:42 PM

All replies

  • Have you tried DocumentReflector, released with Open XML SDK v2.0 CTP?  It can generate code to reproduce the given Office document.

    You can first create an excel document with all the cell formating you wanted, then retrieve the generated code by reflecting this document with DocumentReflector tool. The process of creating and using stylesheet fonts and cellformats will be presented in the geneated code.

    It is a great tool for learning Open XML SDK.
    Monday, November 2, 2009 7:47 AM