从文档库中读取Excel数据并将数据上传到列表 [英] Read excel data from document library and upload data to list

问题描述

我需要从上传到文档库中的excel文件中读取数据，并且excel记录需要插入到其他自定义列表中.

I have a requirement to read data from excel file which uploaded in the document library and the excel records need to be inserted to the other custom list. 

我的环境是SharePoint Online，因此无法使用任何服务器端代码.

My environment is SharePoint online, hence it is not possible to user any server side code.

对此有任何帮助，我们深表感谢.预先感谢.

Any help on this is appreciated. Thanks in advance.

推荐答案

<跨度样式="margin:0px; color:#1f497d; text-decoration:none"> https://xxx.sharepoint.com/sites/lee/_vti_bin/ExcelRest.aspx/MyDoc2/lee.xlsx/model/Ranges('Sheet1 ！A1 | G5')

https://blogs .office.com/2013/12/17/excel-rest-api-in-sharepoint-online/

https://msdn .microsoft.com/en-us/library/office/jj163211.aspx?f = 255& MSPPError = -2147217396

  ;

CRUD JSOM.

https://msdn.microsoft.com/zh-我们/library/office/jj163201.aspx

  ;

最佳问候

Lee

这篇关于从文档库中读取Excel数据并将数据上传到列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！