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
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
Post a Comment for "Javascript Api For Office Getrange Method"