SharePoint

Using Powershell to run Excel macro on all files of sharepoint document library

Lumir Kunath — Sun, 05 Jun 2011 22:06:19 GMT

This scripts gets list of file urls of all documents from sharepoint 2007 document library , for all Excel files from this list than open file from sharepoint , run macro named "Refresh" and at the end save it back to sharepoint.

Usefull for something like "Company Excel Daily Reports"

Import-SPSite.ps1

Niklas Goude — Fri, 11 Sep 2009 21:03:24 GMT

DESCRIPTION:
NAME: Import-SPSite
Restores a Site from a Backup File

PARAMETERS: 
-url		Url to SharePoint Site
-File		File Name
-Location	File Location

SYNTAX:

Import-SPSite -url http://moss -file Backup.bak -Location C:\Backup\

Restores the site from the Backup File C:\Backup\Backup.bak

Import-SPSite -help

Displays the help topic for the script

Export-SPSite.ps1

Niklas Goude — Fri, 11 Sep 2009 21:02:31 GMT

DESCRIPTION:
NAME: Export-SPSite
Exports a Site to a Backup File

PARAMETERS: 
-url		Url to SharePoint Site
-File		File Name
-Location	File Location

SYNTAX:

Export-SPSite -url http://moss -file Backup.bak -Location C:\Backup\

Exports a Backup of the Site to C:\Backup\Backup.bak

Export-SPSite -help

Displays the help topic for the script

Remove-SPSite.ps1

Niklas Goude — Fri, 11 Sep 2009 21:01:45 GMT

DESCRIPTION:
NAME: Remove-SPSite
Removes a site from the Site Collection

PARAMETERS: 
-url		Url to SharePoint Site

SYNTAX:

Remove-SPSite -url http://moss/IT

Removes the Site "IT" from the Site Collection

Remove-SPSite -help

Displays the help topic for the script

Remove-SPList.ps1

Niklas Goude — Fri, 11 Sep 2009 21:00:52 GMT

DESCRIPTION:
NAME: Remove-SPList
Removes A List

PARAMETERS: 
-url		Url to SharePoint Site
-List		Name of Document Library

SYNTAX:

Remove-SPList -url http://moss -List "Users"

Removes The Users list from the site http://moss

Remove-SPList -help

Displays the help topic for the script

Remove-SPItem.ps1

Niklas Goude — Fri, 11 Sep 2009 21:00:02 GMT

DESCRIPTION:
NAME: Remove-SPItem
Removes An Item From a List

PARAMETERS: 
-url		Url to SharePoint Site
-List		Name of Document Library
-Name		Item Name
-Field		Field to check, Default set to Title

SYNTAX:

Remove-SPItem -url http://moss -List Users -name nigo

Removes the item nigo from the Users List

Remove-SPItem -url http://moss -List Users -name "IT Consultant" -Field Description

Removes the Item Where the Field Description is equal to "IT Consultant"

Opens The SiteCollection.

Remove-SPItem -help

Displays the help topic for the script

Remove-SPField.ps1

Niklas Goude — Fri, 11 Sep 2009 20:59:15 GMT

DESCRIPTION:
NAME: Remove-SPField
Removes A Field From A List

PARAMETERS: 
-url		Url to SharePoint Site
-List		Name of Document Library
-Field		Field to check, Default set to Title

SYNTAX:

Remove-SPField -url http://moss -List "Shared Documents" -Field "Document Type"

Removes The Document Type Field From the List "Shared Documents

Remove-SPField -help

Displays the help topic for the script

Add-SPListViewWebPart.ps1

Niklas Goude — Fri, 11 Sep 2009 20:58:26 GMT

DESCRIPTION:
NAME: Add-SPListViewWebPart
Adds a New List View WebPart

PARAMETERS: 
-url			Url to SharePoint Site
-List			Name of List
-Name			Title of WebPart
-Zone			Zone to place WebPart, Default set to Left
-Index			Index Position of WebPart, Default set to 0 ( Top )
-ChromeType		Chrome Type of WebPart, Default Set to Default

SYNTAX:

Add-SPListViewWebPart -url http://moss/statistics -List Statistics -Name "Client Statistics" -ChromeType "None"

Adds a New List View WebPart 

Add-SPListViewWebPart -help

Displays the help topic for the script

Add-SPImageWebPart.ps1

Niklas Goude — Fri, 11 Sep 2009 20:57:32 GMT

DESCRIPTION:
NAME: Add-SPImageWebPart
Adds a New Image WebPart

PARAMETERS: 
-url		Url to SharePoint Site
-Image			Full Path To New Image
-Name			Title of WebPart
-BackgroundColor	WebPart BackgroundColor, Default set to Transparent
-Zone			Zone to place WebPart, Default set to Left
-Index			Index Position of WebPart, Default set to 0 ( Top )
-VerticalAlignment	Vertical Alignment of WebPart, Default set to Middle
-HorizontalAlignment 	Horizontal Alignment of WebPart, Default set to Center
-ChromeType		Chrome Type of WebPart, Default Set to Default

SYNTAX:

Add-SPImageWebPart -url http://moss/statistics -Name "My Image" -Image "C:\Demo\Files\3DPie.png" -ChromeType "None"

Adds a New Image WebPart to the Site.

Add-SPImageWebPart -help

Displays the help topic for the script

Add-SPSitePermission.ps1

Niklas Goude — Fri, 11 Sep 2009 20:56:34 GMT

DESCRIPTION:
NAME: Add-SPSitePermission
Adds Unique Site Permissions to a Group

PARAMETERS: 
-url		Url to SharePoint Site
-Group		Name of New Group
-Permission	Permission

SYNTAX:

Add-SPSitePermission -url "http://moss/IT" -Group "IT Management" -Permission "FullMask"

Gives the Group "IT Management" Full Rights on the Site http://moss/IT

Opens The SiteCollection.

Add-SPSitePermission -help

Displays the help topic for the script

Add-SPUser.ps1

Niklas Goude — Fri, 11 Sep 2009 20:55:27 GMT

DESCRIPTION:
NAME: Add-SPUser
Adds A New User To A Group in SharePoint

PARAMETERS: 
-url		Url to SharePoint Site
-Group		Name of New Group
-Domain		Role Of New Group
-sAMAccountName	Users sAMAccountName
-mail		Users email Address
-FullName	Users FullNam

SYNTAX:

Add-SPUser -url http://moss -Group "New Group" -Domain "powershell.nu" -sAMAccountName "goude" -mail "niklas.goude@zipper.se" -FullName "Niklas Goude"

Adds the User to the Group "New Group"

Add-SPUser -help

Displays the help topic for the script

Add-SPGroup.ps1

Niklas Goude — Fri, 11 Sep 2009 20:54:36 GMT

DESCRIPTION:
NAME: Add-SPGroup
Adds a New SharePoint Group

PARAMETERS: 
-url		Url to SharePoint Site
-Group		Name of New Group
-Role		Role Of New Group
-Owner		Group Owner

SYNTAX:

Add-SPGroup -url http://moss -Group "New Group" -Role Read -Owner "powershell\administrator"

Adds the Group "New Group" to the Site.

Add-SPSGroup -help

Displays the help topic for the script

Add-SPSite.ps1

Niklas Goude — Fri, 11 Sep 2009 20:53:48 GMT

DESCRIPTION:
NAME: Add-SPSite
Adds a New SharePoint Site

PARAMETERS: 
-url		Url to SharePoint Site
-Weburl		New site Name
-Title		Title of New Site
-Description	New Sites Description
-Template	Template to use

SYNTAX:

Add-SPSite -url http://moss -weburl "IT" -Title "Information Technology" -Description "IT Department" -Template "STS#0"

Adds the Site "IT" to http://moss

Add-SPSite -help

Displays the help topic for the script

Set-SPView.ps1

Niklas Goude — Fri, 11 Sep 2009 20:52:56 GMT

DESCRIPTION:
NAME: Set-SPView
Gets A SP View

PARAMETERS: 
-url		Url to SharePoint Site
-List		List Name
-View		Name of the View
-Query		Query to set the View

SYNTAX:

Set-SPView -url http://moss -List "Shared Documents" -View "All Documents" -Query '<GroupBy Collapse="TRUE" GroupLimit="100"><FieldRef Name="Document_x0020_Type" /></GroupBy><OrderBy><FieldRef Name="FileLeafRef" /></OrderBy>'

Sets The "All Documents" View to Group by the "Document Type" Custom Field.

Set-SPView -help

Displays the help topic for the script

Add-SPURLField.ps1

Niklas Goude — Fri, 11 Sep 2009 20:52:03 GMT

DESCRIPTION:
NAME: Add-SPURLField
Adds a Text Field to a SP List

PARAMETERS: 
-url		Url to SharePoint Site
-List		List Name
-Name		Name of the Field
-Description	Field Description
-Required	Boolean Value, If True, Field will be Required

SYNTAX:

Add-SPURLField -url http://moss -List Users -Name HomePage -Description "HomePage"

Adds A URL Field to the Users List

Add-SPURLField -help

Displays the help topic for the script