Get column width

Here is a tip how to get column width.

 

Source code

function getColWidth() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sh = ss.getActiveSheet();

  var val = sh.getColumnWidth(1);
  
  Browser.msgBox(val);
}

 

Format

SheetObject.getColumnWidth(columnPosition)

 

Parameters

columnPosition … Column number. It starts from 1.

 

Responses

None

Leave a Comment