[Office] Office Open XML (xlsx).md

[Office] Office Open XML (xlsx).md

[Office] Office Open XML (xlsx)

概要

拡張子「xlsx」のOffice Open XMLフォーマットについて。

仕様

Microsoft

• Office (2007) Open XML ファイル形式の概要
• SpreadsheetML ドキュメントの構造 (Open XML SDK) | Microsoft Docs

ECMA

• Standard ECMA-376 Office Open XML File Formats

ISO

• ISO/IEC 29500-2:2012(en): Office Open XML File Formats — Part 2
• ISO/IEC 29500-3:2012(en): Office Open XML File Formats — Part 3

numFmt (Number Format)

「ECMA-376 5th edition Part 1」-> "Ecma Office Open XML Part 1 - Fundamentals And Markup Language Reference.pdf" -> [18.8.30 numFmt (Number Format)] より引用。

18.8.30 numFmt (Number Format)

This element specifies number format properties which indicate how to format and render the numeric value of a cell.

...(中略)...

All Languages

ID	formatCode
0	General
1	0
2	0.00
3	#,##0
4	#,##0.00
9	0%
10	0.00%
11	0.00E+00
12	# ?/?
13	# ??/??
14	mm-dd-yy
15	d-mmm-yy
16	d-mmm
17	mmm-yy
18	h:mm AM/PM
19	h:mm:ss AM/PM
20	h:mm
21	h:mm:ss
22	m/d/yy h:mm
37	#,##0 ;(#,##0)
38	#,##0 ;[Red](#,##0)
39	#,##0.00;(#,##0.00)
40	#,##0.00;[Red](#,##0.00)
45	mm:ss
46	[h]:mm:ss
47	mmss.0
48	##0.0E+0
49	@

...(中略)...

Attributes	Description
formatCode (Number Format)	The number format code for this number format. The possible values for this attribute are defined by the ST_Xstring simple type (§22.9.2.19).
numFmtId (Number Format Id)	Id used by the master style records (xf's) to reference this number format. The possible values for this attribute are defined by the ST_NumFmtId simple type (§18.18.47).

参考情報

• javascriptでXLSXをプレーンテキストに - Qiita