excel xml单元格属性值是什么意思? [英] What do excel xml cell attribute values mean?
问题描述
查看excel电子表格的xml,我看到sheetData / row下的这些单元格:
Looking at the xml of an excel spreadsheet, I see these cells under sheetData/row:
<c r="T1" s="23" t="s"><v>17</v></c>
<c r="AP1" s="98"><v>28</v></c>
通过查看电子表格,我可以看到第一个单元格是一个字符串(我可以看在sharedStrings文件中),并且我知道第二个是值28,从中我假设如果一个单元格具有属性 t =s
,它是一个字符串,否则它是一个值。这是正确的吗?
By looking at the spreadsheet, I can see that the first cell is a string (which I can look up in the sharedStrings file), and I know that the second one is the value "28", from which I hypothesise that if a cell has the attribute t="s"
, it is a string, otherwise it is a value. Is this correct?
我猜,r,s和t代表行,风格和类型,但有人可以澄清我的意思是什么,他们的价值观是什么?例如,我看到一些具有属性t =str的单元格,是否与s相同或是否意味着特殊?
I am guessing that the r, s, and t stand for 'row', 'style', and 'type', but can someone clarify for me what they mean and what the possible values for them are? E.g, I see some cells with the attribute t="str", is that the same as "s" or does it mean something special?
我找不到任何文档或规范的excel xml文件,所以如果这样的事情存在,这将是有用的指向它的方向。
I couldn't find any documentation or specification for the excel xml files, so if such a thing exists it would be helpful to be pointed in it's direction.
推荐答案
ul>
r
=参考 s
=样式索引 t
=单元格数据类型r
= References
= Style Indext
= Cell Data Type-
b
- boolean -
d
日期为ISO8601格式 -
e
- 错误 -
inlineStr
- 不使用共享字符串表的字符串 -
n
- 数字 -
s
- 共享字符串 -
str
- 公式字符串 b
- booleand
- date in ISO8601 formate
- errorinlineStr
- string that doesn't use the shared string tablen
- numbers
- shared stringstr
- formula string
Cell
类的文档是这里
可能的单元格数据类型是:
The possible cell data types are:
这些值在ECMA-376标准的第18.18.11节中,可以在这里(具体来说,它们在ECMA-376第4版第1部分下载的PDF文件的第2442-2443页)
These values are in section 18.18.11 of the ECMA-376 standard which can be found here (specifically they are on pages 2442-2443 of the PDF file in the ECMA-376 4th edition part 1 download)
在PDF文件的后面查看XML模式,使用 t
属性是可选的,默认值为 n
- 即一个数字
Looking at the XML schema later in that PDF file, the use of the t
attribute is optional and the default value is n
- i.e. a number
这篇关于excel xml单元格属性值是什么意思?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!