获取共享列表的所有项目以excel [英] Get all the items of sharepoint list to excel

问题描述

大家好，

我在SharePoint在线站点中有一个列表，我需要将所有导出到Excel工作表中.

I have a list in SharePoint online site and I need to get all the exported to excel sheet.

我当然已经从SharePoint导出到excel选项，但是我需要直接将数据导入excel，并且每当打开excel时，都需要自动刷新.

Of course I have export to excel option from SharePoint but Instead I need to get data into excel directly and whenever excel gets opened, that need to be auto refreshed.

请咨询.

此致

Chaitanya.

Chaitanya.

推荐答案

您好Chaitanya-不确定如何在线运行，但请参阅以下链接以了解如何完成:

Hi Chaitanya- not sure how this will work for online, but see the following link on how it's done:

https://blogs.technet.microsoft.com/excel_services__powerpivot_for_sharepoint_support_blog/2013/07/11/excel-services-using-a-sharepoint-list-as-a-data-source/

这篇关于获取共享列表的所有项目以excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！