Google App Script | Headers and Footers | Replace text

Charles-Emmanuel Fousse Savoye Published at Java

Charles-Emmanuel Fousse Savoye

I'm trying to built a script that replace some Data in a Google Document. I'm just observing a problem. The script works well for all the body and the footers from the 2nd to the last page. My first page footer is set as different than the others but i couldn't find a way to modify its content.

Do you have any solutions ? By the way, I'm looking for a way to open the new document in my browser at the end of the script. Any solutions too ? There's a part of my script.

  var documentId = DriveApp.getFileById('1mh8yjFpy7NcjB8meXWvn1SKQofjSMcFdPqWBe4GoC14').makeCopy().getId();
  var body = DocumentApp.openById(documentId).getBody();
  var footer = DocumentApp.openById(documentId).getFooter();
  DriveApp.getFileById(documentId).setName('RM_' + RM + '_' + IDEtude + "_" + Prenom + "_" + Nom);
  
  footer.replaceText("{RM_REF}", RM);
  footer.replaceText("{PROJECT_REF}", IDEtude);

  body.replaceText("{RM_REF}", RM);
  body.replaceText("{PROJECT_REF}", IDEtude);
  body.replaceText("{NumeroBA}", numBA);
  body.replaceText('{PrenomNom}', Prenom + " " +Nom);
  body.replaceText('{adresse}', Adresse);
  body.replaceText('{code postal et ville}', CP);
  body.replaceText('{numero de telephone}', NumTel);
  body.replaceText('{CLIENT_COMPANY}', NomClient);
  body.replaceText('{DatedeFin}', DatedeFin);
  body.replaceText('{DatedeDebut}', DatedeDebut);
  body.replaceText('{FaitLe}',Date);
  body.replaceText('{Ville}',VilleCdP);

Thanks for your help !

Yuri Khristich

Try to add these three lines in your Code.gs after the line 37:

first_footer = footer.getParent().getChild(3);
first_footer.replaceText("{RM_REF}", RM);
first_footer.replaceText("{PROJECT_REF}", IDEtude);

...getParent().getChild(3) — is the hack to get access to a footer on a 'different first page' (probably it's your case)

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2020-10-29

Comments

0 comments

From Dev

Related Related

Article

Google App Script | Headers and Footers | Replace text

Google App Script | Headers and Footers | Replace text

How to get multiple headers/footers in a document with Google Apps Script

MigraDoc headers and footers

True persistent footers/headers in jquerymobile

removing headers and footers in android webview

Perl Dancer Template headers, footers

"ScreenUpdating = False" Not Working for Headers/Footers

headers and footers in python-docx

How do I replace text in a spreadsheet with Google Apps Script?

Replace text within a cell in Google Spreadsheets using a script

How replace text with regular expression in google apps script

Validating response text in a Google Form with Regex in Google App Script

How to replace text in Google Spreadsheet using App Scripts?

IntelliJ Script to Replace Text

Replace text with hostname script?

Replace text with hostname script?

How to add HTML headers and footers to a page?

Setting margins, headers and footers for PDF without overlap

Adding two headers and footers, one for screen and print

OpenOffice API: How to turn off headers and footers

Setting margins, headers and footers for PDF without overlap

How to programmatically deny editing the headers and footers?

Is there a way to add headers and footers to cells in a Word table?

Angular 2 Feature Modules for Headers and Footers

VBA Excel - Unlink headers & footers in Word

SSRS Multiple Headers-Footers /Single List

Get headers and footers of slides using PowerPoint Interop

google app script regex 3 How to remove text bounded by parenthesis?

splitting up text with a regular expression in google app script (documentApp) with findText

find and replace text in a perl script