通过Powershell导出所有SharePoint列表 [英] Export all SharePoint lists through powershell

问题描述

大家好，

我想从单独的excel中的网站和子网站中导出所有SharePoint列表.意味着我有5个列表的站点，还有一个又有5个列表的子站点，再到800个子站点.

I want to export all SharePoint lists from my sites and subsites in seperate excel . Means I have site in which 5 lists are there and have subsite which have again 5 lists , and again subsite ...till 800 .

我想编写Powershell，它将所有列表数据导出到excel(5个列表中为5个excel)，而导出为800个.

I want to write Powershell which will export all lists data into excel (5 excel for 5 lists) and same for 800.

有人对此有代码吗，我想动态地做，意味着应该在第一个Subsite文件夹中创建并添加excel，然后在2站点新建文件夹并在其中导出excel.像这样的东西.

Does anybody have code for this , i want to do dynamically , means for 1st Subsite folder should get created and added excel there , then for 2 site new folder and export excel there . Something like this.

Powershell将是不错的选择

Powershell will be good option

如果您认为答案有帮助或正确，请标记答案.

Please mark answer , if you think answer is helpful or correct.

推荐答案

嗨

这是一个如何将列表项导出到csv文件的示例

this is an example how to export list items to a csv file

https://kmlsp.wordpress.com/2014/08/04/how-to-export-sharepoint-list-to-csv-file-by-powershell/

并删除|第25行的where-object

and remove | where-object from line 25

如果您需要更多详细信息，请告诉我

Let me know if you need more details

这篇关于通过Powershell导出所有SharePoint列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！