将Excel工作表转换为XML [英] Convert excel sheet to XML

问题描述

大家好，



我想创建一个浏览excel文档并将其内容转换为xml格式的基本应用程序，任何帮助都会有所帮助。



谢谢，

Kiran

解决方案

没有这样的事情只是XML格式。 XML是一种适用于多种格式的媒体。这样，这个问题没有充分的意义。我只想提醒您注意.XLSX Excel文档已经是XML;你只需要解压缩文件，这实际上是一种ZIP格式。您可以在这里了解格式：

http://en.wikipedia.org/wiki/Office_Open_XML_file_formats [ ^ ]，

http://en.wikipedia.org/wiki/Office_Open_XML [ ^ ]。



你打算怎么做是你的事。从你的问题来看，我不确定你真的知道什么。







要使用ZIP，您可以使用#ziplib：

http://www.icsharpcode.net/ opensource / sharpziplib / [ ^ ]。



另一个选择是使用SevenZipSharp，一个着名的7-Zip的.NET包装器：

http://en.wikipedia.org/wiki/7-Zip [ ^ ]，

http：// sevenzipsharp.codeplex.com/ [ ^ ]。



两个ZIP库都是开源的。



祝你好运，

-SA

取值ee他的文章是否可以提供帮助

从XML生成Excel并从Excel生成XML [ ^ ]

Hi All,

I want to create a basic application that browses a excel document and converts its contents into a xml format, any help would be helpful.

Thanks,
Kiran

解决方案

There is no such thing as just "XML format". XML is a kind of a media for many formats. This way, the question does not have a full sense. I just want to bring to your attention that an .XLSX Excel document is already XML; you only need to unpack the file, which is actually is a ZIP format. You can learn about the format here:
http://en.wikipedia.org/wiki/Office_Open_XML_file_formats[^],
http://en.wikipedia.org/wiki/Office_Open_XML[^].

What you are going to do with that is your business. From your question, I''m not sure you really know what.

[EDIT]

For working with ZIP, you can use #ziplib:
http://www.icsharpcode.net/opensource/sharpziplib/[^].

Another option is using SevenZipSharp, a .NET wrapper of the famous 7-Zip:
http://en.wikipedia.org/wiki/7-Zip[^],
http://sevenzipsharp.codeplex.com/[^].

Both ZIP libraries are open-source.

Good luck,

—SA

See whether his article can help
Generate Excel from XML and Generate XML from Excel[^]

这篇关于将Excel工作表转换为XML的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！