Snippets - Rows & Columns


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);
});


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