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
  1. Excel Services is a business intelligence tool that allows you to share data-connected workbooks across an organization.
  2. 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.

    onLibrary -Address <String> -ExcelServiceApplication <SPExcelServiceApplicationPipeBind> [-AssignmentCollection <SPAssignmentCollection>] [-Confirm [<SwitchParameter>]] [-Description <String>] [-WhatIf [<SwitchParameter>]]
Example

Get-SPExcelServiceApplication -Identity "ExcelServiceApplication" | New-SPExcelDataConnectionLibrary -address "http://gowtham/site/demo" -description "This is Demo"

Conclusion

Was my blog helpful? If yes, please let me know and if not, please explain what was confusing or missing. I’ll use your feedback to double-check the facts, add info and update this blog.
Ebook Download
View all
Learn
View all