Workbook.ServerViewableItems Property

Gets an object that you can use to interact with the list of published objects in the workbook that are shown on a Microsoft Office SharePoint Server server.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

ServerViewableItems ServerViewableItems { get; }

Property Value

Type: Microsoft.Office.Interop.Excel.ServerViewableItems
A Microsoft.Office.Interop.Excel.ServerViewableItems object that you can use to interact with the list of published objects in the workbook that are shown on the server.

This property returns a collection of the items in the workbook that you can publish to Excel Services. Only objects in this collection will be shown on the server. By default, the entire workbook (including all worksheets) is shown.

Only one Microsoft.Office.Interop.Excel.ServerViewableItems object can exist per workbook. This collection cannot be indexed by name, because there is no guarantee that the names of objects that are marked as viewable on the server are unique.

In the Excel user interface, you can view the collection of objects that are marked as viewable on the server in the Excel Services Options dialog box.

Community Additions

ADD
Show: