Office getRange方法的JavaScript API [英] JavaScript API for Office getRange method

问题描述

是否可以通过row，column，numRows，numColumns获取范围?

Is there a way to get a range by row, column, numRows, numColumns?

例如:

Excel.run(function (ctx) {
    var sheet = ctx.workbook.worksheets.getActiveWorksheet();
    var range = sheet.getRange(1, 2, 3, 4).load("values");
    ...
});

推荐答案

在下一版本的ExcelAPI 1.7中，我们将提供worksheet.getRangeByIndexes正是您想要的内容.

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:

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

-Office可扩展性团队的软件工程师Philip

-Philip, Software Engineer on the Office Extensibility team

这篇关于Office getRange方法的JavaScript API的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！