This course will help you learn the basics or refresh your knowledge and then provide a deeper understanding of advanced features of SharePoint 2013 from beginners to advanced users.
In this blog, we will learn about how to get the Excel Service application file location 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 Service is a business intelligence tool that allows you to share data-connected workbooks across an organization.
- Excel Service 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.
Syntax
Get-SPExcelFileLocation [[-Identity] <SPExcelFileLocationPipeBind>] -ExcelServiceApplication <SPExcelServiceApplicationPipeBind> [-AssignmentCollection <SPAssignmentCollection>]
Example
Get-SPExcelServiceApplication -Identity "ExcelServiceApplication" | Get-SPExcelFileLocation
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.