App script appendRow with RichTextValue variable-CodePudding

trying to use app script appendrow with multilple values one of them is a RichTextValue variable.

    var richValue = SpreadsheetApp.newRichTextValue()
   .setText('link')
   .setLinkUrl('www.somesite.com')
   .build();

sheet.appendRow([varX,varY,varZ,richValue ]);

problem is using appendRow with a richValue dont add the properties of the richValue.

the only documented way I found to add a RichTextValue to the sheet is via setRichTextValue/s

I know its possible to get the same result with setRichTextValue/s but I prefer if there is a work around to use appendRow with RichTextValue variables.

CodePudding user response：

Try the appendRows_() utility function, like this:

const richValue = SpreadsheetApp.newRichTextValue()
  .setText('link')
  .setLinkUrl('www.somesite.com')
  .build();
appendRows_(sheet, [varX, varY, varZ, richValue]);