Javascript Api For Office Getrange Method

Is there a way to get a range by row, column, numRows, numColumns? For example: Excel.run(function (ctx) { var sheet = ctx.workbook.worksheets.getActiveWorksheet(); var ran

Solution 1:

In the next release of ExcelAPI 1.7 we will have worksheet.getRangeByIndexes which is exactly what you are looking for.

In the meantime you can achieve the same by doing the following:

varrange = sheet.getCell(1,2).getResizedRange(3,4);

-Philip, Software Engineer on the Office Extensibility team