Need PS to export sharepoint form library columns to a excel file.

See more:

PowerShell

SharePoint2013

I have a infopath form library which as all the form data in columns. I need a Powershell scrip to export that data into a excel file or a CSV file.

What I have tried:

I have used below code
Add-PSSnapin Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue

$MyWeb = Get-SPWeb -identity "http://cclportal/reservations/surveys"
$MyList = $web.Lists["CareTeam Application"]

$ListItemCollection = @()
 
 
$list.Items | foreach {
$ExportItem = New-Object PSObject
 
$ExportItem | Add-Member -MemberType NoteProperty -name "Employee Name" -value $_["Employee Name"]
 
$ExportItem | Add-Member -MemberType NoteProperty -Name "Home Address" -value $_["Home Address"]
 
#Add the object with property to an Array
 
$ListItemCollection += $ExportItem
 
}
 
#Export the result Array to CSV file
 $ListItemCollection | Export-CSV "c:\testexport.csv" -NoTypeInformation                       

#Dispose the web Object

$MyWeb.Dispose()

but i get this error below

Cannot index into a null array.
At C:\Users\_spsadmin\Desktop\Exporttoexcel.ps1:4 char:1
+ $MyList = $web.Lists["CareTeam Application"]
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (:) [], RuntimeException
+ FullyQualifiedErrorId : NullArray

Cannot index into a null array.
At C:\Users\_spsadmin\Desktop\Exporttoexcel.ps1:12 char:1
+ $ExportItem | Add-Member -MemberType NoteProperty -name "Employee Name" -value $ ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (:) [], RuntimeException
+ FullyQualifiedErrorId : NullArray

Cannot index into a null array.
At C:\Users\_spsadmin\Desktop\Exporttoexcel.ps1:14 char:1
+ $ExportItem | Add-Member -MemberType NoteProperty -Name "Home Address" -value $_ ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (:) [], RuntimeException
+ FullyQualifiedErrorId : NullArray