将excel行添加到列表 [英] adding excel rows to list

查看:74
本文介绍了将excel行添加到列表的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

大家好.我有一个Excel文档,其中包含几百行和10列.我想将excel文档上载到共享点,以便将每一行都列为一个列表项.我知道我可以将Excel文档上传为列表,但是我的Excel 该文档每周更新一次,因此我希望能够上传下一个excel列表,并且它将使用新项目更新该列表.谢谢!

Hi all. I have an excel document that has a couple hundred rows, and 10 columns. I'd like to upload the excel document to sharepoint, so that each individual row will be listed as a list item. I know I can upload an excel document as a list, but my excel document is updated every week, so I'd like the ability to upload the next excel list, and it'll update the list with the new items. Thanks!

推荐答案

您可以通过Macros或CSOM来实现.

You can achieve this through Macros or CSOM .

https://sharepoint.stackexchange .com/questions/93181/add-and-update-single-item-in-sharepoint-list-via-vba

https://sharepoint.stackexchange.com/questions/34433/update-sharepoint -list-using-excel


这篇关于将excel行添加到列表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆