Google Apps Script TableCell not accepting Attributes

Question

I have some code I am using for a google apps script macro. This uses the DocumentApp TableRow and Table Cell datatype.

//row is TableRow datatype
function appendRow(row){
    var style = {};
    style[DocumentApp.Attribute.FONT_SIZE] = '8';
    style[DocumentApp.Attribute.HORIZONTAL_ALIGNMENT] = DocumentApp.HorizontalAlignment.RIGHT;
    row.appendTableCell(SOME_TEXT).setAttributes(style);
}

So when I run this function the resulting cell in the row is still the default left justified. Am I missing something? They have this example on their website.

https://developers.google.com/apps-script/reference/document/table-cell#setAttributes(Object)

var body = DocumentApp.getActiveDocument().getBody();

// Define a custom paragraph style.
var style = {};
style[DocumentApp.Attribute.HORIZONTAL_ALIGNMENT] =
 DocumentApp.HorizontalAlignment.RIGHT;
style[DocumentApp.Attribute.FONT_FAMILY] = 'Calibri';
style[DocumentApp.Attribute.FONT_SIZE] = 18;
style[DocumentApp.Attribute.BOLD] = true;

// Append a plain paragraph.
var par = body.appendParagraph('A paragraph with custom style.');

// Apply the custom style.
par.setAttributes(style);

abielita abielita · Accepted Answer · 2017-06-08T17:18:53

You may refer with this sample tutorial. Here's a sample code adding a table with cell text in right justified.

function addTableInDocument() {

  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';
  cellStyle[DocumentApp.Attribute.HORIZONTAL_ALIGNMENT] = DocumentApp.HorizontalAlignment.RIGHT;

  var doc = DocumentApp.getActiveDocument();

  //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<2; i++){
    var tr = table.appendTableRow();

    //add 4 cells in each row
    for(var j=0; j<2; 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(cellStyle);
    }
  }

  doc.saveAndClose();
}

Hope this helps.

Google Apps Script TableCell not accepting Attributes

1 Answers