您可以通过Google文档中的应用程序脚本设置rowspan / colspan吗？ [英] Can you set rowspan / colspan through apps script in Google document?

问题描述

有没有人有过如何/如果我们可以在Google脚本生成的Google Apps脚本中的TableCell（？）元素上设置行/ colspan的例子？

这需要使用.setAttributes（）方法完成吗？

解决方案

不，目前没有办法做到这一点。我没有在问题跟踪器上看到功能请求。

有一个 .merge（）方法放在 TableCell 对象上，这听起来很有希望。但是，当它被使用时，它通过将当前TableCell的内容附加到前一个表单，然后删除当前表单，将当前TableCell对象与前一个同级表单元组合在一起，然后删除当前表单。

之前

After

代码

我修改了来自以前的答案的代码来试验 .merge（），这里是：

  function mergeExperiment（）{
 var folder =StackOverflow; 
 var docname =Experiment.gdoc; 
 var docId = getFileByName_（folder，docname）.getId（）; 
 
 var doc = DocumentApp.openById（docId）; 
 var docBody = doc.getActiveSection（）; 
 
 var totalElements = doc.getNumChildren（）; 
 var el = [] 
 for（var j = 0; j  var element = doc.getChild（j）; 
 var type = element.getType（）; 
 
 switch（type）{
 case DocumentApp.ElementType.PARAGRAPH：
 break; 
 
 case DocumentApp.ElementType.TABLE：
 var tablerows = element.getNumRows（）; $（var row = 0; row< tablerows; ++ row）{
 var tablerow = element.getRow（row）
 for（var cell = 0; cell< tablerow。如果（行== 1&& cell == 1）{
 tablerow。 getChild（小区）.merge（）; 
} 
} 
} 
 break; 
} 
} 
} 
  

Does anyone have an example of how/if we can set the row/colspan on a TableCell (?) Element in an Apps Script generated Google Document?

Does this need to be done using the .setAttributes() method?

解决方案

No, there is currently no way to do this. I don't see a feature request on the Issue Tracker, either.

There is a .merge() method on the TableCell object, which sounds promising. However, when it's used it combines the "current" TableCell object with the "previous" sibling TableCell by appending the content of the "current" TableCell to the "previous" one, then deleting the "current" one.

Before

After

Code

I modified the code from a previous answer to experiment with .merge(), here it is:

function mergeExperiment() {
  var folder = "StackOverflow";
  var docname = "Experiment.gdoc";
  var docId = getFileByName_(folder, docname).getId();

  var doc = DocumentApp.openById(docId);
  var docBody = doc.getActiveSection();

  var totalElements = doc.getNumChildren();
  var el=[]
  for( var j = 0; j < totalElements; ++j ) {
    var element = doc.getChild(j);
    var type = element.getType();

    switch (type) {
      case DocumentApp.ElementType.PARAGRAPH:
        break;

      case DocumentApp.ElementType.TABLE:
        var tablerows=element.getNumRows();
        for ( var row = 0; row < tablerows; ++row ) {
          var tablerow = element.getRow(row)
          for ( var cell=0; cell < tablerow.getNumCells(); ++cell) {
            // Experiment - merge two cells in the second row
            if (row==1 && cell==1) {
              tablerow.getChild(cell).merge();
            }
          }
        }
        break;
    }
  }
}

这篇关于您可以通过Google文档中的应用程序脚本设置rowspan / colspan吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！