Microsoft Office Tutorials and References
In Depth Information
Xlviewer Customizations
Configurable Properties
The EWA Web Part has approximately 43 configurable properties. About half of these are applicable for
using the EWA in a nonembedded manner, as is the case with xlEwa.aspx.
The following table shows the properties that you can use for this solution. Instructions for obtaining the
complete list of properties are provided after the table. Each of the configurable EWA Web Part
properties exposed through xlEwa.aspx is also available through the EWA Web Part properties task pane that is
displayed when an EWA is embedded in a SharePoint page.
Property Name
Type
User Interface Equivalent
Default
Value
Rows
RowsToDisplay
int
75
Columns
ColumnsToDisplay
int
20
VisibleItem
string
Named Item
ShowVisibleItemButton
bool
Named Item drop-down menu
true
WorkbookUri
string
Workbook
Open In Excel; Open Snapshot In Excel
AllowInExcelOperations
bool
true
Refresh Selected Connection; Refresh
All Connections
AllowPeriodicDataRefresh
bool
true
AllowRecalculation
bool
Calculate Workbook
true
Workbook Navigation
AllowNavigation
bool
true
AllowHyperlinks
bool
Hyperlinks
true
AllowInteractivity
bool
All workbook interactivity
true
Parameter modification
AllowParameterModification
bool
true
ShowWorkbookParameters
bool
Display Parameters task pane
true
AllowSorting
bool
Sorting
true
AllowFiltering
bool
Filtering
true
All PivotTable interactivity
AllowPivotSpecificOperations
bool
true
AllowManualDataRefresh
bool
Periodically Refresh If Enabled In
Workbook
true
Search JabSto ::




Custom Search