Ewa.Range.getAddressA1()
Applies to: apps for SharePoint | SharePoint Server 2010
In this article
Return Value
Remarks
Example
Applies To
Gets the range coordinates of the specified range in A1 format, including the worksheet name.
var value = Ewa.Range.getAddressA1();
Return Value
string
Remarks
The Ewa.Range.getAddressA1 method returns the range coordinates of the specified range in A1 format, including the worksheet name. The range coordinates include the sheet name in sheet view. The A1 address includes the sheet name in sheet view, workbook view, and named item view.
Example
The following code example shows how to get a range ("B2:C5") from worksheet "mySheet", selects a cell ("B4") within the range, and then displays the range coordinates of the range in A1 format in the browser status bar.
<script type="text/javascript">
var ewa = null;
// Add event handler for onload event.
if (window.attachEvent)
{
window.attachEvent("onload", ewaOmPageLoad);
}
else
{
window.addEventListener("DOMContentLoaded", ewaOmPageLoad, false);
}
// Add event handler for applicationReady event.
function ewaOmPageLoad()
{
Ewa.EwaControl.add_applicationReady(getEwa);
}
function getEwa()
{
// Get a reference to the Excel Services Web Part.
ewa = Ewa.EwaControl.getInstances().getItem(0);
// Get range "B2:C5" from sheet, "mySheet".
var range = ewa.getActiveWorkbook().getRange('mySheet',1,1,4,2);
// Display range coordinates in browser status bar.
window.status = "Range coordinates in A1 format: " + range.getAddressA1();
}
</script>