How to insert a cell with a format style? RRS feed

  • Question

  • I am generating excel 2007 docs with OPENXML SDK CTP 2.0 AUG.
    It works okay. But I insert my datetime value as oadate, datatype = cellvalues.Number.
    it insert the correct value but without any format.
    I only know it has something to do with style.xml and numFmt
    Could someone tell me how to do it with the SDK?   (no hard code.)
    Friday, December 11, 2009 9:59 AM


  • Thanks for your question.

    You are correct. To fomrat a cell, you need to and numFmt in style.xml. The best way to learn how to format a cell with the SDK is to use the Productivity Tool released with OpenXML SDK 2.0 Dec CTP. You can download it from 

    The productivity tool in this release has the functionalities to compare two office documents in Open XML Level (Open XML Diff), Reflect an office document to corresponding C# code using SDK (Document Reflector), and Generating C# code with SDK to reflect the differences between two office doucments (Code For Diff).

    In your case, you can create an empty excel document as the source document, then format a cell with desired format and save as the target document. Comparing two documents with the productivity tool's Open XML Diff function to see which open xml part/elements you need to change. Or you can use the Code For Diff function to generate C# code for the difference between your source and target documents.

    By either way, you should be able to create/apply a style to a cell.


    • Marked as answer by Maxi Ng Monday, December 14, 2009 2:58 AM
    Monday, December 14, 2009 2:36 AM