基于excel中多个工作表的数据创建XML文件 [英] Create XML file based on data from multiple sheets in excel
问题描述
我是sharepoint的新手。我有一个sharepoint页面。我想做的是，有一个页面，它有一个按钮来浏览并从本地驱动器中选择特定的Excel文件，然后使用excel内的多个工作表中的数据，并创建一个xml文件
其中它包含来自该excel文件的所有数据，带有下载按钮，所以一旦创建我可以下载到本地硬盘......是否可以这样做？请提供建议和指导。
非常感谢。
Br，FM
< span style ="color：＃1F497D">
我认为使用Excel功能可以更轻松地实现此要求比如vba，你可以查看下面的线程进行演示。
https://www.ablebits.com/office-addins-blog/2017/11/08 / merge-multiple-excel-files-into-one /
如果您需要关于excel定制的进一步帮助，我建议你在下面的excel论坛上发帖，这样你就会得到最合格的受访者群，而定期阅读论坛的其他合作伙伴可以分享他们的知识。
< a href ="https://social.msdn.microsoft.com/Forums/en-us/home?forum=exceldev"> https://social.msdn.microsoft.com/Forums/en-us/home?forum = exceldev
无论如何，如果你需要在SharePoint门户网站上做，你可以使用js实现这一目标的库。
多个文件选择对话框。
http://blueimp.github.io/jQuery-File-Upload /
通过ExcelPlus读/写excel文件。
https://aymkdn.github.io/ExcelPlus/
最好的问候，
利
Hi ,
i am new to sharepoint. I have a sharepoint page. What i would like to do, is to have a page, where it has a button to browse and select particular excel file from local drive, then use the data from multiple sheets inside the excel, and create an xml file where it contains all the data from that excel file, with download button so once create i can download to local hardrive...... Is it possible to do this? Please advice and guidance.
thank you very much.
Br,FM
Hi,
I think this requirement can be achieve more easily with excel function such as vba, you could check below thread for demo.
https://www.ablebits.com/office-addins-blog/2017/11/08/merge-multiple-excel-files-into-one/
If you need further assistance about excel customization, I would suggest you post in excel forum below so you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge.
https://social.msdn.microsoft.com/Forums/en-us/home?forum=exceldev
Anyway, if you need do in SharePoint portal, you could use js libraries to achieve this.
Multiple files selection dialog.
http://blueimp.github.io/jQuery-File-Upload/
Read/write excel file by ExcelPlus.
https://aymkdn.github.io/ExcelPlus/
Best Regards,
Lee
这篇关于基于excel中多个工作表的数据创建XML文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
