tags:

views:

163

answers:

0
+1  Q: 

Where is list of defined format styles for Excel using the OpenXML sdk

I'm using the OpenXML SDK 2.0, and I want to know where the list of defined format styles (and their values) is kept. Specifically, I want to know date/time formats. I want to open an xcel file, read a cell, and try to determine (based on format/style) if it is a date or date time value. Conversely, if I write data to a xcel file, and I want a specific cell to be of a 'Date', what styleindex value do i use?

related questions

Mail Merge using the Open XML SDK
Open XML Spreadsheet style error
Create custom shape or connector in PowerPoint using code/script/definition
Why does T-SQL OpenXML bust with certain characters?
Best place for unique ID in DOCX (Open XML WordprocessingDocument)
how to create and download excel document using asp.net
Creating cell comments in an Excel Spreadsheet with OpenXML SDK
How to programmatically insert comments into a Microsoft Word document?
Adding Chart to WordprocessingML
Dynamically creating Office Open XML documents: update all fields on open
Recalculating Excel 2007 in OpenXMLSDK 1.0
Insert string values in to Excel 2007 using Open XML SDK 1.0
How do I convert Excel OpenXML shared strings to inline strings?
Inserting a Comment in Docx file *around* a text inside a run
Word 2007, Open XML - embedding an image
Printing an OOXML document without MS Word installed
What is the best way to populate a Word 2007 template in C#?
Editing Excel Spreadsheets easily with the SDK
How can I programatically use C# to append multiple DOCX files together?
Insert cell comments in excel programmaticaly.
How do I get the stream of header/footer in a WordprocessingDocument
Insert HTML into OpenXML Word Document (.Net)
How can I read a Word 2007 .docx file?
How do I convert a .docx to html using asp.net?
How can a Word document be created in C#?