Powershell＆Sharepoint通过视图导出列表项到csv

Question

我试图通过特定的视图从SharePoint列表中导出项目。

我有项目成功返回，但现在我坚持试图将它正确导出为CSV文件

这里是我迄今：

$web = Get-SPWeb $url 
    $splist = $web.Lists[$listname] 
    $view = $splist.Views["Current Month"] 
    $items = $splist.GetItems($view) 
    $items | Select-Object "Check Number", "Purchaser" | Export-Csv -Path f:\test.csv 
    $web.Dispose() 

预先感谢您！

Answer 1

SharePoint 2007的

[Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint") | out-null 
$site = new-object Microsoft.SharePoint.SPSite("http://yoursite") 
$web = $site.RootWeb 
$list = $web.Lists[$listname] 
$view = $list.Views["Current Month"] 
$items = $list.GetItems($view) 
$items | %{ select-object -input $_ -prop @{Name='Title';expression={$_.Title;}}, @{Name='Check Number';expression={$_["Check Number"];}}; } | Export-Csv -Path c:\test.csv 

你必须从SPListItem特性建立你选择的对象了把它传递给出口CSV

前