当前位置:首页 > 未分类 > 正文内容

Convert Google Docs and Google Sheets with Apps Script

ceacer3周前 (05-02)未分类7644

You can easily convert any Google Spreadsheet or Google Document in your Google Drive to other formats like PDF, XLS, etc with Google Apps Script and either email the converted file or save it back to Google Drive.

You can get the Email Google Spreadsheet add-on if you prefer the easier route that doesn’t require you to write any Google Apps Script code.

Save Google Document as HTML file

// Credit Stéphane Giron

function exportAsHTML(documentId) {
  var forDriveScope = DriveApp.getStorageUsed(); //needed to get Drive Scope requested
  var url = 'https://docs.google.com/feeds/download/documents/export/Export?id=' + documentId + '&exportFormat=html';
  var param = {
    method: 'get',
    headers: { Authorization: 'Bearer ' + ScriptApp.getOAuthToken() },
    muteHttpExceptions: true,
  };
  var html = UrlFetchApp.fetch(url, param).getContentText();
  var file = DriveApp.createFile(documentId + '.html', html);
  return file.getUrl();
}

Export Google Spreadsheet as Microsoft Excel format

// Credit: Eric Koleda

function exportAsExcel(spreadsheetId) {
  var file = Drive.Files.get(spreadsheetId);
  var url = file.exportLinks['application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'];
  var token = ScriptApp.getOAuthToken();
  var response = UrlFetchApp.fetch(url, {
    headers: {
      Authorization: 'Bearer ' + token,
    },
  });
  return response.getBlob();
}

相关文章

How to Make Personalized Place Cards with Guest Names

How to Make Personalized Place Cards with Guest Names

Whether it is a wedding party or a business conference, those tent-shaped place cards are ideal for...

How to Import PayPal Transactions into Google Sheets

How to Import PayPal Transactions into Google Sheets

This tutorial will show you how to import PayPal transactions into Google Sheets with the help of G...

How to Use Hyperlinks in Google Sheets

How to Use Hyperlinks in Google Sheets

This guide explains how you can easily create and manage hyperlinks in Google Sheets. An entire cell...

How to Create Dynamic Open Graph Images with Google Sheets

How to Create Dynamic Open Graph Images with Google Sheets

An open graph image (OG image) is the image that is displayed when any of your website links are sha...

How to Request Stripe Payments with Google Sheets

How to Request Stripe Payments with Google Sheets

Stripe now offers a Payment Links API to help you programmatically generate payment links in bulk fo...

Convert and Email Google Spreadsheets as PDF Files

You can set up a cron job in Google Drive using Google Apps Script that will send any Google Spreads...