通过Powershell导出所有SharePoint列表

大家好，

我想从单独的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.