Export Single Sheet to PDF in Apps Script

by

Hidden sheets are not included when a spreadsheet is exported via getBlob. So you can temporarily hide any unwanted sheets prior to exporting. 

function export() {    
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName('Unwanted Sheet');
  sheet.hideSheet();
  DriveApp.createFile(ss.getBlob());
  sheet.showSheet();
}

The above only hides one sheet, which is enough in the context of your question. Here is a version that hides everything but one. 

function exportSheet(sheetName) {    
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheets = ss.getSheets();
  for (var i = 0; i < sheets.length; i++) {
    if (sheets[i].getSheetName() !== sheetName) {
      sheets[i].hideSheet()
    }
  }
  DriveApp.createFile(ss.getBlob());
  for (var i = 0; i < sheets.length; i++) {
    sheets[i].showSheet()
  }
}

More Related Contents:

  1. How to download single sheet as PDF to my local device directly (not export to Google Drive)?
  2. Convert all sheets to PDF with Google Apps Script
  3. Can no longer produce PDF from Google Sheets spreadsheet for some of the users
  4. How to automatically import data from uploaded CSV or XLS file into Google Sheets
  5. Sheet.getRange(1,1,1,12) what does the numbers in bracket specify?
  6. Convert Google Doc to PDF using Google Script Editior
  7. Get pdf-attachments from Gmail as text
  8. Google apps script getAs(‘application/pdf’) layout
  9. Send active sheet as PDF to email listed in cell
  10. Generate PDF of only one sheet of my spreadsheet
  11. What does the range method getValues() return and setValues() accept?
  12. Long processing time likely due to getValue and cell inserts
  13. Detecting browser print event
  14. Faster way to find the first empty row in a Google Sheet column
  15. Angular 2 download PDF from API and Display it in View
  16. Is there a custom function or script that returns gid of a specific sheet in Google Sheets?
  17. How to convert a Google Docs-File to an Excel-File (XLSX)
  18. How can I extract embedded fonts from a PDF as valid font files?
  19. Google Sheet API V4(Java) append Date in cells
  20. Best way to convert pdf files to tiff files [closed]
  21. Copying a spreadsheet copies all linked files as well
  22. Editing Hyperlink and Anchors in PDF using ITextSharp
  23. Protect ranges with google apps script
  24. Scraping data to google sheets from a website that uses JavaScript
  25. Creating and Sending sheets in the same function
  26. How to determine artificial bold style ,artificial italic style and artificial outline style of a text using PDFBOX
  27. How do I know if spreadsheet cells are merged using google apps script
  28. Google apps script error: “You do not have permission to call protect” [duplicate]
  29. Google spreadsheet “Cannot call method “getRange” of null”
  30. How to extract Highlighted Parts from PDF files

Leave a Comment