深入浅出SharePoint——更新计算列

最新推荐文章于 2015-07-09 01:49:06 发布

weixin_30500473

最新推荐文章于 2015-07-09 01:49:06 发布

阅读量143

点赞数

原文链接：http://www.cnblogs.com/mingle/archive/2013/01/10/2854856.html

版权

在SharePoint2007下测试通过。

使用SharePoint对象模型：

SPFieldCollection collFields = list.Fields;
//Update the calculated column
if (collFields.ContainsField("Document ID"))
{
    collFields["Document ID"].Update();
}

使用Powershell：

[System.Reflection.Assembly]::LoadWithPartialName(”Microsoft.SharePoint”)
#This will get the site URL
$siteUrl= http://Site URL
#This is to get the WebApp
$webName = "WebAppName"
$spSite = new-object Microsoft.SharePoint.SPSite($siteurl)
$spWeb = $spSite.OpenWeb()
Write-Host $spList = $spWeb.Lists["ListName"]
Write-Host {list found}
$collFields = $spList.Fields[""];
$collFields.Formula= "=[Field1]+[Field1No]+[Field45No]"
$collFields.update();