OpenXML SDK电子表格入门套件 [英] OpenXML SDK Spreadsheet starter kits

问题描述

我正在尝试通过OpenXML SDK Spreadsheet API开始使用Excel文档。
但是我没有找到任何好的指南，甚至没有发现如何从头创建一个xlsx文件的例子。只有如何打开一个现有的文档并修改它。

I am trying to start working with Excel documents through the OpenXML SDK Spreadsheet API. But I haven't found any good guides or even examples on how to create a xlsx file from scratch. Only how to open an existing document and modify it.

我一直在考虑拥有一个空的模板文件，并复制一份然后开始我的处理。但它感觉正确。这可能比较容易，但是我不太会喜欢使用一种技术，我觉得我至少懂了漂亮。

I have been thinking on having a empty template document and make a copy of it an then begin my proccessing on it. But it doesent feel right. It might be easier but I not comfortable using a technique I dont feel that I understand "pretty" good at least.

所以我的问题是：有没有人有任何好的提示在文章或书籍或任何其他类型的资源解释API？

So my question is: Does anyone have any good tips on articles or books or any other type of resource that explains the API?

提前感谢。
/ johan

Thanks in advance. /johan

推荐答案

你最好的选择是下载 OpenXml SDK 2.0 并进行安装。安装完成后，请检查Tools目录中的DocumentReflector.exe工具。使用此工具，您可以破解一个现有的xslx文档（或docx或pptx）。一旦打开，应用程序将显示一个部件的树状视图，一个给定零件的xml面板以及从头开始生成文档所需的代码。

Your best bet is to download the OpenXml SDK 2.0 and install. Once installed, check the Tools directory for a tool called DocumentReflector.exe. Using this tool you can "crack open" an existing xslx document (or docx or pptx). Once opened, the application will show you a treeview of the parts, a panel with the xml for a given part and the code required to generate the document from scratch.

应该给你一个很好的开始，让你真正了解SpreadsheetML语法（我用这个工具学习WordProcessingML，它真的有帮助！）。

This should give you a great start and get you to really understand the SpreadsheetML syntax (I used this tool to learn WordProcessingML and it REALLY helped!).

另请参见如何使用asp.net创建和下载excel文档

这篇关于OpenXML SDK电子表格入门套件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！