如何从Excel VBA宏生成XML？ [英] How to generate XML from an Excel VBA macro?

问题描述

所以，我有一堆以Excel电子表格形式发送给我们的内容。我需要把这个内容推入另一个系统。另一个系统从XML文件接收其输入。我可以手动完成所有这一切（相信我，管理层没有问题，让我做到这一点），但是我希望有一个简单的方法来编写一个可以生成需要的XML的Excel宏。这对我来说似乎是一个更好的解决方案，因为这是一个需要定期重复的工作（我们将在Excel表中获得大量内容），只需要一个批处理工具就可以实现。

So, I've got a bunch of content that was delivered to us in the form of Excel spreadsheets. I need to take that content and push it into another system. The other system takes its input from an XML file. I could do all of this by hand (and trust me, management has no problem making me do that!), but I'm hoping there's an easy way to write an Excel macro that would generate the XML I need instead. This seems like a better solution to me, as this is a job that will need to be repeated regularly (we'll be getting a LOT of content in Excel sheets) and it just makes sense to have a batch tool that does it for us.

但是，我从未试过从Excel电子表格生成XML。我有一点VBA知识，但我是XML的新手。我想我在谷歌的这个问题是，我甚至不知道Google是怎么回事。任何人都可以给我一个方向让我开始吗？我的想法听起来像是正确的方法来解决这个问题，还是我忽略了一些明显的东西？

However, I've never experimented with generating XML from Excel spreadsheets before. I have a little VBA knowledge but I'm a newbie to XML. I guess my problem in Googling this is that I don't even know what to Google for. Can anyone give me a little direction to get me started? Does my idea sound like the right way to approach this problem, or am I overlooking something obvious?

谢谢StackOverflow！

Thanks StackOverflow!

推荐答案

请参阅将Excel导出到VBA中的XML 帮助。

这篇关于如何从Excel VBA宏生成XML？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！