Snippets - Rows & Columns


Get Column Number

var datasheet = context.workbook.worksheets.getItem('Sheet1');  
var startRange = datasheet.getRange('Sheet1').Range("A1");
startRange.load('columnIndex');
context.sync().then( function() {
   console.log(startRange.columnIndex);
});

var _range = context.workbook.names.getItem("myNamedRange").getRange(); 
var _rangeValues = _range.getRow(1).getBoundingRect(_range.getLastCell());
var _myCol = _range.getColumn(0);


© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited TopPrevNext