Excel将一个字段添加到Xml映射 [英] Excel Add A Field To An Xml Map

问题描述

我在Excel 2010工作表上有一个XML映射，我定期从XML文件的内容中刷新。我最近在XML数据中添加了一个新的字段，并希望将其显示在我的XML地图上。

我只想添加新的字段，但它似乎虽然不得不重新导入整个结构，但我不想这样做，因为它将需要重新开发很多自定义格式。

任何帮助赞赏。

解决方案

将xlsx解压缩为zip，并且可以手动进行更改，而无需删除并按照本网站上的说明再次添加映射：
http://davidovitz.blogspot.com/2010/05/howto-refresh-xml-schema-in-excel.html

I've a XML map on an Excel 2010 worksheet, that I refresh from the contents of an XML file on a regular basis. I recently added a new field to the XML data and wish this to show up on my XML map.

I simply want to be able to add the new field however it appears although ill have to import the whole structure again, I dont want to do this as it will require redeveloping alot of custom formating.

Any help appreciated.

解决方案

I extracted the xlsx as a zip and was able to make the changes manually without having to delete and add the mappings again following the instructions on this site: http://davidovitz.blogspot.com/2010/05/howto-refresh-xml-schema-in-excel.html

这篇关于Excel将一个字段添加到Xml映射的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！