Change line spacing in a cell in a Google Doc using Google App Script

Question

I have a Google Doc which has a table that needs updating weekly and content to be inserted from a spreadsheet. I successfully paste in the correct data into each cell but the lines are spaced at 1.15 not single spaced.

Any ideas on how to accomplish this?

Here is the code I have tried:

  const doc = DocumentApp.getActiveDocument();

  var paddingTop = 1.5; // You can adjust the height by modifying this.
  var paddingBottom = 1.5; // You can adjust the height by modifying this.

  var tables = doc.getBody().getTables();
  tables.forEach(table => {
    for (var r = 0; r < table.getNumRows(); r++) {
      var row = table.getRow(r);
      for (var c = 0; c < row.getNumCells(); c++) {
        row.getCell(c).setPaddingTop(paddingTop).setPaddingBottom(paddingBottom);
        var p=row.getCell(c);
        Logger.log(c)
        for(i=0;i<p.length; i++){
          p[i].setLineSpacing(100);
        }
      }
    }
  });

This does not change the line spacing inside the cells at all.

Answer 1

This is what worked for me:

 var paddingTop = 1.5; // You can adjust the height by modifying this.
 var paddingBottom = 1.5; // You can adjust the height by modifying this.
  
  var paraStyle = {};
    paraStyle[DocumentApp.Attribute.LINE_SPACING] = 1;

  var tables = doc.getBody().getTables();
  tables.forEach(table => {
    for (var r = 0; r < table.getNumRows(); r++) {
      var row = table.getRow(r);
      for (var c = 0; c < row.getNumCells(); c++) {
        var cell=row.getCell(c);
        cell.setPaddingTop(paddingTop)
        cell.setPaddingBottom(paddingBottom);
        var items = cell.getNumChildren();
        for (var i = 0; i < items; i++){
          var paraInCell = cell.getChild(i).asParagraph();
          paraInCell.setAttributes(paraStyle);
        }
      }
    }
  });