Google-sheets – PDF shows only top row of spreadsheet

google sheetsgoogle-apps-scriptpdf

I am attempting to export a spreadsheet which is "created" daily through an automated e-mail in Google Apps Script. When attempting to convert to PDF I only get the top row shown in the PDF document (none of the data).

var file = DriveApp.getFileById(spreadsheet.getId()).getAs(MimeType.PDF);

  MailApp.sendEmail('email', 'Equipment Update', 'Spreadsheet Attached', {
name: 'Testing',
attachments: [file]
  });

I have checked and the spreadsheet does have the appropriate list of information on the sheet which is to be exported.

Any ideas as to what might be causing this?

Best Answer

It appears you were trying to convert a spreadsheet to PDF immediately after it was filled with data. This is sometimes an issue because the data may be stuck in a pipeline: the changes are not immediately applied for performance reasons. Use the command

SpreadsheetApp.flush();

before conversion to PDF, to make sure any pending changes are applied. Reference.

Code

// for the active sheet (in essence the first)
function onTop() {
  var ss = SpreadsheetApp.getActiveSheet();
  ss.insertRows(2);
  var date = Utilities.formatDate(new Date(), "GMT+2", "dd/MM/yyyy")
  ss.getRange("A2").setValue(date);  
}

// for a specific sheet
function onTop() {
  var sh = SpreadsheetApp.getActive().getSheetByName("TEST");
  sh.insertRows(2);
  var date = Utilities.formatDate(new Date(), "GMT+2", "dd/MM/yyyy")
  sh.getRange("A2").setValue(date);  
}

Triggers

In the script editor, choose the following menu option:
enter image description here

and set the trigger as follows (or however you choose): enter image description here

Example

I've created an example file for you: on top

Remark

You have to return tomorrow to check it though =)

Best Answer

Related Solutions

Google-sheets – Make new responses appear as a row at the top of a Google Spreadsheet

Google-sheets – Automatically create a new row each day, on top of older rows

Code

Triggers

Example

Remark

Related Topic