用ctrl点击获取到的多个区域也可以通过遍历获取其中单元格的信息。
这里有一个demo,您可以参考下:
- var selections = sheet.getSelections();
- for (var i = 0; i < selections.length; i++) {
- var row = selections[i].row;
- var col = selections[i].col;
- var rowCount = selections[i].rowCount;
- var colCount = selections[i].colCount;
- //console.log(row, col, rowCount, colCount)
- for (var x = 0; x < rowCount; x++) {
- for (var y = 0; y < colCount; y++) {
- var rowIndex = row + x;
- var colIndex = col + y;
- console.log(sheet.getCell(rowIndex, colIndex).text());
- }
- }
- }
复制代码
|
|