寻找 Excel 的 .xlsx XML 格式的清晰描述

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/4886027/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-06 13:33:40  来源:igfitidea点击:

Looking for a clear description of Excel's .xlsx XML format

xmlexcelsyntaxformatxlsx

提问by none

Microsoft Excel's ".xlsx" files are zip files that each contain a set of files.

Microsoft Excel 的“.xlsx”文件是 zip 文件,每个文件都包含一组文件。

Could someone please provide a link that concisely describes the full structure/syntax/markup/format of the embedded .xmlfiles (the headers are less interesting)?

有人可以提供一个链接,简要描述嵌入.xml文件的完整结构/语法/标记/格式(标题不太有趣)?

For example, it's hard to find online explanations on what the c, t, and selements represent.

例如,很难找到什么网上的解释ct以及s元素表示。

回答by Oliver Bock

This PowerPoint deck, entitled "SpreadsheetML Basics", from Microsoft, provides a good overview. It is a 30-page presentation including diagrams, and it is not practical to include its contents here.

这个来自 Microsoft 的题为“SpreadsheetML Basics”的PowerPoint 幻灯片提供了很好的概述。这是一个 30 页的演示文稿,包括图表,在此处包含其内容是不切实际的。

Four different stackoverflow reviewers have jumped on this post to delete it because the stackoverflow policy objects to simple links. I do not think that is appropriate to this question, because this document is exactly what has been requested. However I cannot be bothered to spend more time on it and (for example) spend an hour trying to summarise some portions to make them happy. If they want to delete again, then good luck to them.

四个不同的 stackoverflow 审阅者跳上这篇文章将其删除,因为 stackoverflow 策略反对简单的链接。我认为这不适合这个问题,因为这份文件正是我们所要求的。然而,我不想花更多的时间在上面,并且(例如)花一个小时试图总结一些部分让他们开心。如果他们想再次删除,那么祝他们好运。

回答by ashleedawg

This is an old question -- but the Excel XML (ISO/IEC 29500) standard is now well documented in varying degrees of detail. For example see thisand thisand parsing discussion here.

这是一个古老的问题——但是 Excel XML (ISO/IEC 29500) 标准现在已经以不同程度的详细程度很好地记录在案。例如,在此处查看以及解析讨论。