如何使用 PowerShell 从 SharePoint Online 下载文件夹？

要求：从 SharePoint Online 下载文件夹。

如何从 SharePoint Online 下载文件夹？

您是否想知道如何从 SharePoint Online 下载文件夹？好吧，这篇文章将向您展示如何操作！只需几个简单的步骤，您就可以在计算机上获得 SharePoint 文件夹的内容。在这篇博文中，我们将向您展示如何从 SharePoint Online 下载文件夹（并下载其中的文件！）。

假设您至少具有读取权限，请按照以下步骤从 SharePoint Online 下载文件夹：

1. 登录到 SharePoint Online 网站集，然后导航到 SharePoint 文档库或要下载的文件夹所在的父文件夹。
2. 右键单击文件夹 >> 从上下文菜单中选择“下载”。您还可以使用工具栏中的“下载”按钮。

3. 这将为您带来一个包含所选文件夹及其子文件夹及其文件的 Zip 文件。

   

很简单吧？现在，您终于可以直接使用所有这些文档，而无需在浏览器上打开另一个选项卡。让我们看看如何使用 PowerShell 下载 SharePoint Online 文件夹。

SharePoint Online：使用 PowerShell 下载文件夹

现在，当我们需要按计划重复或自动下载文件夹时，我们可以使用 PowerShell。这是我的 PowerShell，用于从 SharePoint Online 下载文件夹：

#Load SharePoint CSOM Assemblies
Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\ISAPI\Microsoft.SharePoint.Client.dll"
Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\ISAPI\Microsoft.SharePoint.Client.Runtime.dll"
 
Function Download-SPOFolder()
{ 
    param
    (
        [Parameter(Mandatory=$true)] [string] $SiteURL,
        [Parameter(Mandatory=$true)] [Microsoft.SharePoint.Client.Folder] $SourceFolder,
        [Parameter(Mandatory=$true)] [string] $TargetFolder
    )
    Try {
         
        #Create Local Folder, if it doesn't exist
        $FolderName = ($SourceFolder.ServerRelativeURL) -replace "/","\"
        $LocalFolder = $TargetFolder + $FolderName
        If (!(Test-Path -Path $LocalFolder)) {
                New-Item -ItemType Directory -Path $LocalFolder | Out-Null
        }
         
        #Get all Files from the folder
        $FilesColl = $SourceFolder.Files
        $Ctx.Load($FilesColl)
        $Ctx.ExecuteQuery()
 
        #Iterate through each file and download
        Foreach($File in $FilesColl)
        {
            $TargetFile = $LocalFolder+"\"+$File.Name
            #Download the file
            $FileInfo = [Microsoft.SharePoint.Client.File]::OpenBinaryDirect($Ctx,$File.ServerRelativeURL)
            $WriteStream = [System.IO.File]::Open($TargetFile,[System.IO.FileMode]::Create)
            $FileInfo.Stream.CopyTo($WriteStream)
            $WriteStream.Close()
            write-host -f Green "Downloaded File:"$TargetFile
        }
         
        #Process Sub Folders
        $SubFolders = $SourceFolder.Folders
        $Ctx.Load($SubFolders)
        $Ctx.ExecuteQuery()
        Foreach($Folder in $SubFolders)
        {
            If($Folder.Name -ne "Forms")
            {
                #Call the function recursively
                Download-SPOFolder -SiteURL $SiteURL -SourceFolder $Folder -TargetFolder $TargetFolder
            }
        }
     }
    Catch {
        write-host -foregroundcolor Red "Error Downloading Folder!" $_.Exception.Message
    }
}
 
#Set parameter values
$SiteURL="https://crescent.sharepoint.com"
$FolderRelativeUrl ="Shared Documents/Reports"
$TargetFolder="C:\Docs"
 
#Setup Credentials to connect
$Cred= Get-Credential
$Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.Username, $Cred.Password)
 
#Setup the context
$Ctx = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL)
$Ctx.Credentials = $Credentials

#Get the Web
$Web = $Ctx.Web
$Ctx.Load($Web)
$Ctx.ExecuteQuery()
$Web.ServerRelativeUrl+$FolderRelativeUrl
      
#Get the Folder
$SourceFolder = $Web.GetFolderByServerRelativeUrl($Web.ServerRelativeUrl+$FolderRelativeUrl)
$Ctx.Load($SourceFolder)
$Ctx.ExecuteQuery()

#Call the function to download a Folder
Download-SPOFolder -SiteURL $SiteURL -SourceFolder $SourceFolder -TargetFolder $TargetFolder 

PnP PowerShell 从 SharePoint Online 下载文件夹

如何使用 PowerShell 从 SharePoint 下载文件夹？那么，此 PnP PowerShell 脚本使用 Get-PnPFolder 和 Get-PnPFile cmdlet 将所有文件和子文件夹从 SharePoint Online 文档库中的特定文件夹下载到本地目录。

#Function to Download All Files from a SharePoint Online Folder - Recursively  
Function Download-SPOFolder([Microsoft.SharePoint.Client.Folder]$Folder, $DestinationFolder)
{  
    #Get the Folder's Site Relative URL
    $FolderURL = $Folder.ServerRelativeUrl.Substring($Folder.Context.Web.ServerRelativeUrl.Length)
    $LocalFolder = $DestinationFolder + ($FolderURL -replace "/","\")
    
    #Create Local Folder, if it doesn't exist
    If (!(Test-Path -Path $LocalFolder)) {
            New-Item -ItemType Directory -Path $LocalFolder | Out-Null
            Write-host -f Yellow "Created a New Folder '$LocalFolder'"
    }
           
    #Get all Files from the folder
    $FilesColl = Get-PnPFolderItem -FolderSiteRelativeUrl $FolderURL -ItemType File 
    #Iterate through each file and download Sourcefile
    Foreach($File in $FilesColl)
    {
        Get-PnPFile -ServerRelativeUrl $File.ServerRelativeUrl -Path $LocalFolder -FileName $File.Name -AsFile -force
        Write-host -f Green "`tDownloaded File from '$($File.ServerRelativeUrl)'"
    }
    
    #Get Subfolders of the Folder and call the function recursively
    $SubFolders = Get-PnPFolderItem -FolderSiteRelativeUrl $FolderURL -ItemType Folder
    Foreach ($Folder in $SubFolders | Where {$_.Name -ne "Forms"})
    {
        Download-SPOFolder $Folder $DestinationFolder
    }
}  

#Set Parameters
$SiteURL = "https://crescent.sharepoint.com/sites/marketing"
$FolderSiteRelativeURL = "/Team Documents/2018"
$DownloadPath ="C:\Docs" #TargetFilePath
 
#Connect to PnP Online
Connect-PnPOnline -Url $SiteURL -Interactive
 
#Get the folder to download
$Folder = Get-PnPFolder -Url $FolderSiteRelativeURL
 
#Call the function to download all files from a folder
Download-SPOFolder $Folder $DownloadPath

从较大的文档库下载文件夹及其子文件夹和文件

虽然上述脚本工作得很好，但我们可能会在较大的库上遇到超出 Listview 阈值的问题。为了缓解该问题，以下是我的备用脚本，用于将文件从 SharePoint Online 文件夹下载到本地磁盘：

#Set Parameters
$SiteURL = "https://Crescent.sharepoint.com/sites/marketing"
$FolderServerRelativeURL = "/Sites/Marketing/Shared Documents/New"
$DownloadPath ="C:\Docs\New"
  
#Connect to PnP Online
Connect-PnPOnline -Url $SiteURL -Interactive
$Web = Get-PnPWeb

#Get the Folder to download
$Folder = Get-PnPFolder -Url $FolderServerRelativeURL -Includes ListItemAllFields.ParentList
#Get the Folder's Site Relative URL
$FolderSiteRelativeURL = $FolderServerRelativeUrl.Substring($Web.ServerRelativeUrl.Length)

$List = $Folder.ListItemAllFields.ParentList
#Get all Folders from List - with progress bar
$global:counter = 0;
$ListItems = Get-PnPListItem -List $List -PageSize 500 -Fields FileLeafRef -ScriptBlock { Param($items) $global:counter += $items.Count; Write-Progress -PercentComplete `
                ($global:Counter / ($List.ItemCount) * 100) -Activity "Getting Items from List:" -Status "Processing Items $global:Counter to $($List.ItemCount)";} | Where {$_.FieldValues.FileRef -like "$($FolderServerRelativeUrl)*"} 
Write-Progress -Activity "Completed Retrieving Items from Folder $FolderServerRelativeURL" -Completed

#Get Subfolders of the Folder
$SubFolders = $ListItems | Where {$_.FileSystemObjectType -eq "Folder" -and $_.FieldValues.FileLeafRef -ne "Forms"}
$SubFolders | ForEach-Object {
    #Ensure All Folders in the Local Path
    $LocalFolder = $DownloadPath + ($_.FieldValues.FileRef.Substring($Web.ServerRelativeUrl.Length)) -replace "/","\"
    #Create Local Folder, if it doesn't exist
    If (!(Test-Path -Path $LocalFolder)) {
            New-Item -ItemType Directory -Path $LocalFolder | Out-Null
    }
    Write-host -f Yellow "Ensured Folder '$LocalFolder'"
}
#Get all Files from the folder
$FilesColl =  $ListItems | Where {$_.FileSystemObjectType -eq "File"}
#Iterate through each file and download
$FilesColl | ForEach-Object {
    $FileDownloadPath = ($DownloadPath + ($_.FieldValues.FileRef.Substring($Web.ServerRelativeUrl.Length)) -replace "/","\").Replace($_.FieldValues.FileLeafRef,'')
    Get-PnPFile -ServerRelativeUrl $_.FieldValues.FileRef -Path $FileDownloadPath -FileName $_.FieldValues.FileLeafRef -AsFile -force
    Write-host -f Green "Downloaded File from '$($_.FieldValues.FileRef)'"
}

若要从 SharePoint Online 文档库下载所有文件和文件夹，请使用： PowerShell 从 SharePoint Online 库下载所有文件

经常问的问题：

如何使用 PnP PowerShell 从 SharePoint 下载文件？

若要使用 PnP PowerShell 从 SharePoint 下载文件，请先使用 Connect-PnPOnline cmdlet 连接到 SharePoint Online 网站。然后使用 PnP PowerShell cmdlet“Get-PnPFile”从 SharePoint Online 下载文件。例如，以下 PowerShell 脚本从 SharePoint Online 网站下载名为“Document.docx”的文件并将其保存到 C:\Temp 文件夹： Get-PnPFile -Url “/sites/yoursite/Shared Documents/Document.docx” -Path“C:\Temp” -FileName“Document.docx”
更多信息：用于从 SharePoint Online 下载文件的 PowerShell

如何将文件和文件夹上传到 SharePoint Online？

要将文件和文件夹上传到 SharePoint Online，请执行以下步骤： 导航到要上传文件夹的 SharePoint Online 文档库。单击工具栏中的“上传”按钮，然后选择“文件夹”选项。浏览到要上传的文件夹的位置，选择文件夹并单击“上传”按钮。或者，您可以使用 PowerShell 上传文件夹及其文件：使用 PowerShell 将文件夹上传到 SharePoint Online

如何在 SharePoint 中与组织外部的人员共享文件夹？

要在 SharePoint Online 中与组织外部的人员共享文件夹，您必须首先确保为您的域和网站启用外部共享。确认后，您可以通过选择特定文件夹、单击“共享”并输入他们的电子邮件地址来授予他们访问特定文件夹的权限。您还可以选择设置文件夹的特定权限，例如只读或编辑访问权限。更多信息请参见：如何与外部用户共享 SharePoint 上的文件夹？

如何将 SharePoint 文件夹同步到本地驱动器？

要将 SharePoint 文件夹同步到本地驱动器，请使用 OneDrive 同步客户端。首先，确保您的计算机上安装了 OneDrive 应用。然后，导航到要同步的 SharePoint 文件夹并单击“同步”按钮。这将打开 OneDrive 同步客户端，并提示您选择本地驱动器上要同步文件夹的位置。选择位置后，文件夹将开始同步，对 SharePoint 文件夹所做的任何更改都将反映在本地文件夹中。更多信息请参见：如何将 SharePoint 同步到本地文件夹？

如何将 SharePoint 文件夹映射到网络驱动器？

要将 SharePoint 文件夹映射到网络驱动器，请按照以下步骤操作。首先，打开文件资源管理器，右键单击“此电脑”，然后选择“映射网络驱动器”。然后，选择要使用的驱动器号并输入 SharePoint 站点的 URL。最后，输入您的登录凭据并选择要映射的文档库。更多：如何将 SharePoint 映射到网络驱动器？