Create table in Google Document using Apps Script

In this tutorial, I am going to tell you how you can create a Table with data inside a Google Document using Google Apps Script. This is a very simple code which creates a Basic Table in Google Document, applies some row and cell styles in Header row as well as data row.

Putting it all together:

function addTableInDocument() {

  //define header cell style which we will use while adding cells in header row

  //Backgroud color, text bold, white

  var headerStyle = {};

  headerStyle[DocumentApp.Attribute.BACKGROUND_COLOR] = '#336600';

  headerStyle[DocumentApp.Attribute.BOLD] = true;

  headerStyle[DocumentApp.Attribute.FOREGROUND_COLOR] = '#FFFFFF';

  //Style for the cells other than header row

  var cellStyle = {};

  cellStyle[DocumentApp.Attribute.BOLD] = false;

  cellStyle[DocumentApp.Attribute.FOREGROUND_COLOR] = '#000000';

  //By default, each paragraph had space after, so we will change the paragraph style to add zero space

  //we will use it later

  var paraStyle = {};

  paraStyle[DocumentApp.Attribute.SPACING_AFTER] = 0;

  paraStyle[DocumentApp.Attribute.LINE_SPACING] = 1;

  //get the document

  var doc = DocumentApp.getActiveDocument(); //or

//  var doc = DocumentApp.openById('ID_OF_DOCUMENT'); //or

//  var doc = DocumentApp.openByUrl('URL_OF_DOCUMENT');

  //get the body section of document

  var body = doc.getBody();

  //Add a table in document

  var table = body.appendTable();

  //Create 5 rows and 4 columns

  for(var i=0; i<5; i++){

    var tr = table.appendTableRow();

    //add 4 cells in each row

    for(var j=0; j<4; j++){

      var td = tr.appendTableCell('Cell '+i+j);

      //if it is header cell, apply the header style else cellStyle

      if(i == 0) td.setAttributes(headerStyle);

      else td.setAttributes(cellStyle);

      //Apply the para style to each paragraph in cell

      var paraInCell = td.getChild(0).asParagraph();

      paraInCell.setAttributes(paraStyle);

    }

  }

  //Save and close the document

  doc.saveAndClose();

}

And the result is: