ExcelWebRenderer.ShowWorkbookParameters Property
Shows or hides the workbook parameters pane.
Namespace: Microsoft.Office.Excel.WebUI
Assembly: Microsoft.Office.Excel.WebUI (in Microsoft.Office.Excel.WebUI.dll)
Syntax
'Declaration
<WebBrowsableAttribute(True)> _
<WebPartStorageAttribute(Storage.Shared)> _
<PersonalizableAttribute(PersonalizationScope.Shared)> _
Public Property ShowWorkbookParameters As Boolean
Get
Set
'Usage
Dim instance As ExcelWebRenderer
Dim value As Boolean
value = instance.ShowWorkbookParameters
instance.ShowWorkbookParameters = value
[WebBrowsableAttribute(true)]
[WebPartStorageAttribute(Storage.Shared)]
[PersonalizableAttribute(PersonalizationScope.Shared)]
public bool ShowWorkbookParameters { get; set; }
Property Value
Type: System.Boolean
Remarks
When this property is set to true and workbook parameters exist in the workbook, a collapsible pane is shown in Excel Web Access. Users can edit these parameters. If this property is disabled, the pane will not be shown even if workbook parameters exist in the workbook.
If the AllowParameterModification property is disabled, the ShowWorkbookParameters property will be disabled, and the user cannot enable it. Additionally, if the AllowInteractivity option is disabled, the AllowParameterModification property will become disabled, causing the ShowWorkbookParameters property to become disabled.