Articles about European Sharepoint Hosting Service
SharePoint 2013 Hosting – HostForLIFE.eu :: Excel Services Application New Excel DataConnection Library In SharePoint 2013 Using PowerShell
This course will help you learn the basics or refresh your knowledge and then provide a deeper understanding of advanced features to anyone interested in learning SharePoint 2013 from beginners to advanced users.
In this blog we will learn about how to add a new data connection library to Excel Services Application using PowerShell cmdlets.
SharePoint 2013 is a collaboration environment that organizations of all sizes can use to increase the efficiency of business processes.
Excel Service Application
Excel Services is a business intelligence tool that allows you to share data-connected workbooks across an organization.
Excel Services in SharePoint Server 2013 is a shared service that you can use to publish Excel 2013 workbooks on SharePoint Server.
Why we are using these commands?
Excel Services Application loads only workbooks that are stored in a trusted file location.
Steps
Open your SharePoint Management Shell.
Copy the below code.
Run this one.
|
1 |
onLibrary -Address <String> -ExcelServiceApplication <SPExcelServiceApplicationPipeBind> [-AssignmentCollection <SPAssignmentCollection>] [-Confirm [<SwitchParameter>]] [-Description <String>] [-WhatIf [<SwitchParameter>]] |
Example
|
1 |
Get-SPExcelServiceApplication -Identity "ExcelServiceApplication" | New-SPExcelDataConnectionLibrary -address "http://gowtham/site/demo" -description "This is Demo" |
| Print article | This entry was posted by Peter on November 16, 2017 at 7:42 am, and is filed under European SharePoint 2013 Hosting. Follow any responses to this post through RSS 2.0. You can leave a response or trackback from your own site. |
