Ewa.NamedItem.getName()
Applies to: apps for SharePoint | Excel Services | SharePoint Server 2013
In this article
Return Value
Remarks
Example
Applies To
Gets the defined name of the named item.
var value = Ewa.NamedItem.getName();
Return Value
Type: string
Remarks
The getName method returns the name of the specified named item as a string. The name of the named item is defined in the workbook.
Example
The following code example shows how to loop through all the named items in the workbook and displays the name of each name item in an alert message. The code example assumes that you are working with Excel Web Access Web Parts on SharePoint Server 2013.
<script type="text/javascript">
var ewa = null;
// Add event handler for onload event.
if (window.attachEvent)
{
window.attachEvent("onload", ewaOnPageLoad);
}
else
{
window.addEventListener("DOMContentLoaded", ewaOnPageLoad, false);
}
// Add event handler for applicationReady event.
function ewaOnPageLoad()
{
Ewa.EwaControl.add_applicationReady(onApplicationReady);
}
function onApplicationReady()
{
// Get a reference to the Excel Services Web Part.
ewa = Ewa.EwaControl.getInstances().getItem(0);
}
function getNamedItemsNamesButton()
{
// Get the specified workbook.
var wkBook = ewa.getActiveWorkbook();
// Get the NamedItems collection.
var items = wkBook.getNamedItems();
for (i=0;i<items.getCount();i++)
{
alert(items.getItem(i).getName());
}
}
</script>
<input type="button" id="GetNamedItemsNames" value="Get Named Items Names" onclick="getNamedItemsNamesButton()" />