我认为使用Excel功能可以更轻松地实现此要求比如vba，你可以查看下面的线程进行演示。

https://www.ablebits.com/office-addins-blog/2017/11/08 / merge-multiple-excel-files-into-one /

如果您需要关于excel定制的进一步帮助，我建议你在下面的excel论坛上发帖，这样你就会得到最合格的受访者群，而定期阅读论坛的其他合作伙伴可以分享他们的知识。

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