“ s”是什么？属性在XLSX中的单元格标记中表示 [英] What does the "s" attribute signify in a cell tag in XLSX

问题描述

在XLSX文件（Excel 2007）中工作表的XML中，具有 t属性等于 s的单元格标记是字符串类型。 c中的value标记需要通过sharedStrings文档进行查找和转换。但是，某些单元格具有s = 237且根本没有t属性。值标签具有一个整数，如39448，该整数与sharedStrings文档无关。在Excel中显示的值是日期1/1/2008。

In the XML of a worksheet in an XLSX file (Excel 2007) cell tags that have a "t" attribute equal to "s" are string types. The value tag inside the c needs to be looked up and converted via the sharedStrings document. But, some cells have s="237" and no t attribute at all. The value tag has an integer like 39448 which does not relate to the sharedStrings document. The value as it appears in Excel is a date 1/1/2008.

s属性在XLSX中的ac标签中表示什么？

What does the s attribute signify in a c tag in XLSX?

未知值

<c r="B47" s="237">
    <v>39448</v>
</c>

共享字符串值

<c r="C47" t="s">
    <v>7</v>
</c>

推荐答案

s属性指的是样式。 237是在styles.xml文件中定义的样式。

The s attribute refers to a style. "237" is a style defined in the styles.xml file.

< v> 39448< / v>

...最有可能是双重格式的日期。样式237告诉excel以日期格式显示 39448 。

...is most likely a date in double format. And the style 237 tells excel to display 39448 in date format.

您可以在此处看到一个示例： http：//blogs.msdn .com / b / brian_jones / archive / 2007/05/29 / simple-spreadsheetml-file-part-3-formatting.aspx

You can see an example of how this works here: http://blogs.msdn.com/b/brian_jones/archive/2007/05/29/simple-spreadsheetml-file-part-3-formatting.aspx

这篇关于“ s”是什么？属性在XLSX中的单元格标记中表示的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！