Tag: list

Try the code below,
The code below attempts to create an xls file. To create it, it is necessary that MS Office is installed on the machine on which you are running this PowerShell.

Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue

#Get the Web
$ web = Get-SPWeb -identity "** Enter your Web URL **"

#Get the list of targets
$ list = $ web.Lists["**Please enter your list name**"]

Array Result #Array - PSObjects
$ ListItemCollection = @ ()

#Get All List items
$ list.Items | for each {
$ ExportItem = PSObject New-Object
$ ExportItem | Add-Member -MemberType NoteProperty -name "Title" -value $ _["Title"]

** # Please create your column variable as column variable "Title" **

#Add the object with the property to a table
$ ListItemCollection + = $ ExportItem
}
#Export the Array result to a CSV file
$ ListItemCollection | Export-CSV "c:  ListData.csv" -NoTypeInformation

#Has the web object
$ web.Dispose ()

# This line below requires the installation of MS Office on the machine to create an object of type xls.
$ xl = new-object -comobject excel.application
$ xl.visible = $ true
$ Workbook = $ xl.workbooks.open ("c:  ListData.csv")
$ Workbook.SaveAs ("c:  ListData.xls", 1)
$ Workbook.Saved = $ True
$ xl.Quit ()

Delete-PSSnapin Microsoft.SharePoint.PowerShell 

If you do not have MS Office and run the code, then you could get the following error,

New-Object: COM Class Factory Recovery for Component with CLSID
{00000000-0000-0000-0000-000000000000} failed for one of the following reasons
error: 80040154 Class not registered (HRESULT exception:
0x80040154 (REGDB_E_CLASSNOTREG)).

the error is produced by the code below,

$ xl = new-object -comobject excel.application

As far as I know, there is no direct approach to creating an xls file from the SharePoint list using PowerShell without MS Office installed.