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

Export Formulas and Notes from a Google Spreadsheet

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

Dan Thareja has written a Google Script that will let you export all the formulas, cell values and notes from a Google Spreadsheet as a JSON file. You can also pull the Google formulas in another web app or Google Apps script using a GET Request. It should come handy when you are reviewing the formulas of a large sheet.

// Credit: github.com/danthareja

function doGet(request) {
  // ID of Google Spreadsheet
  var json = getNotesAndFormulas(request.parameter.id);

  return ContentService.createTextOutput(JSON.stringify(cache)).setMimeType(ContentService.MimeType.JSON);
}

function getNotesAndFormulas(spreadsheetId) {
  return SpreadsheetApp.openById(spreadsheetId)
    .getSheets()
    .reduce(
      function (cache, sheet) {
        var sheetData = (cache[sheet.getName()] = {});
        var range = sheet.getDataRange();

        sheetData.range = range.getA1Notation();
        sheetData.notes = range.getNotes();
        sheetData.formulas = range.getFormulas();

        return cache;
      },
      { spreadsheetId: spreadsheetId }
    );
}

相关文章

How to Email Screenshots of Google Sheets on a Schedule

How to Email Screenshots of Google Sheets on a Schedule

The finance team has created a revenue dashboard inside Google Sheets to track the company’s sales p...

Color Codes for Google Spreadsheets

This Google Script converts the currently active Google Spreadsheet into a square grid of randomly c...

How to Send SMS Messages with Google Sheets and Android Phone

How to Send SMS Messages with Google Sheets and Android Phone

The Mail Merge for Gmail add-on lets you send personalized emails via Gmail but wouldn’t it be nice...

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...

How to Change the Date Format in Google Sheets

How to Change the Date Format in Google Sheets

Dates in Google Sheets are internally stored as numbers and the value is equal to the number of days...

Find Product Prices in Google Sheets with Vlookup and Match Functions

Find Product Prices in Google Sheets with Vlookup and Match Functions

You run a coffee shop and you are looking for a spreadsheet formula to quickly look up prices of the...