从Excel更新SharePoint列表（办公室365） [英] Update list in SharePoint from Excel (office 365)

问题描述

大家好，

我在这方面遇到了很多困难。我在SharePoint中有一个列表，我需要从Excel中的电子表格更新它。我可以将列表导出到Excel，但是如你所知，办公室不允许我直接从excel更新任何项目（我知道有
是一些添加，可以让你这样做，但似乎没有继续工作）。

我可以在Microsoft Access中链接它，并在Access中更新它，但我真的需要在Excel中。所以我考虑将Excel链接到我的Access数据库，因为Access链接到我的Sharepoint List，但这也没有用。现在我正在尝试在Excel中创建宏
，当我执行时，它会更改Access中的数据库，之后，Access可以更新Sharepoint List。但这似乎太复杂了，因为我在VBA编程中是相对论的。有什么方法可以做到这一点，使用
Excel SpreadSheet更新Sharepoint中的列表？是否有可能使用VBA？或者Office 365是否提供任何工具来帮助我？

谢谢，Igor。

解决方案

嗨lgor，

>>有什么方法可以做到这一点，使用Excel SpreadSheet更新Sharepoint中的列表？是否可以使用VBA ??

是否基于Excel SpreadShhet创建了SharePoint列表？如果是这样，下面的链接可能对您有用。

＃我可以使用excel电子表格更新SharePoint 365中的列表

https://social.msdn.microsoft.com/Forums/office/en-US/a5a8db56-4fc3-4ce9-8c8a-8d41df97a649/can-i-update-a-list -in-sharepoint-365-using-an-excel-shreadsheet？forum = sharepointgeneral

如果没有，我建议你试着参考下面的链接。但是，这也不容易。

＃通过VBA在Sharepoint列表中添加和更新单个项目

http://stackoverflow.com/questions/22450717/add-and-update-single-item -in-sharepoint-list-via-vba

＃通过VBA在Sharepoint列表中添加和更新单个项目

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

最诚挚的问候，

Edward

Hi all,

I'm having a lot of difficulties doing this. I have a list in SharePoint, and I need to update it from a spreadsheet in Excel. I can export the list to Excel, but as you know, office doesn't let me update any items directly from excel (I know that there was some add in which lets you do that, but that doesn't seem to work anymore).

I can link it in Microsoft Access, and update it in Access, but I really need to be in Excel. So i thought about linking Excel to my Access database, since Access is linked to my Sharepoint List, but that also didn't work. Now I'm trying to create a macro in Excel, that when I execute, it changes the database in Access, and after that, Access can update the Sharepoint List. But that seems too complicated, since I'm relativity in VBA programming. Is there any way I can do this, update a list in Sharepoint using an Excel SpreadSheet ?? Is it possible using VBA ?? Or does Office 365 provide any tool to help me on that ??

Thanks, Igor.

解决方案

Hi lgor,

>> Is there any way I can do this, update a list in Sharepoint using an Excel SpreadSheet ?? Is it possible using VBA ??

Is the SharePoint list created based on Excel SpreadShhet? If so, the link below might be useful to you.

# Can I update a list in SharePoint 365 using an excel shreadsheet

https://social.msdn.microsoft.com/Forums/office/en-US/a5a8db56-4fc3-4ce9-8c8a-8d41df97a649/can-i-update-a-list-in-sharepoint-365-using-an-excel-shreadsheet?forum=sharepointgeneral

If not, I suggest you try to refer below link. But, it is also not easy.

# Add and Update Single Item in Sharepoint List via VBA

http://stackoverflow.com/questions/22450717/add-and-update-single-item-in-sharepoint-list-via-vba

# Add and Update Single Item in Sharepoint List via VBA

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

Best Regards,

Edward

这篇关于从Excel更新SharePoint列表（办公室365）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！