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

Question

I am using the OpenXML SDK 2.0, and I want to know where the list of styles of a certain format (and their values) is stored. In particular, I want to know the date and time formats. I want to open an xcel file, read a cell and try to determine (based on format / style) if this is a date or date value. Conversely, if I write data to an xcel file and I want a specific cell to be “Date”, what value do I use for the indexIex style?

Answer 1

This article may help. It shows how to add style to a cell.

, , .

Answer 2

(- xlsx). , datetime . Excel , .