Google app scripts: email a spreadsheet as excel

by

It looks like @Christiaan Westerbeek’s answer is spot on but its been a year now since his post and I think there needs to be a bit of a modification in the script he has given above.

var url = file.exportLinks[MimeType.MICROSOFT_EXCEL];

There is something wrong with this line of code, maybe that exportLinks has now depreciated. When I executed his code it gave an error to the following effect:

TypeError: Cannot read property “application/vnd.openxmlformats-officedocument.spreadsheetml.sheet” from undefined.

The workaround is as follows:

The URL in the above line of code is basically the “download as xlsx” URL that can be used to directly download the spreadsheet as an xlsx file that you get from File> Download as > Microsoft Excel (.xlsx)

This is the format:

https://docs.google.com/spreadsheets/d/<<<ID>>>/export?format=xlsx&id=<<<ID>>>
where <<>> should be replaced by the ID of your file.

Check here to easily understand how to extract the ID from the URL of your google sheet.

More Related Contents:

  1. How to automatically import data from uploaded CSV or XLS file into Google Sheets
  2. Moving Files In Google Drive Using Google Script
  3. Google apps script to email google spreadsheet excel version [duplicate]
  4. Copying a spreadsheet copies all linked files as well
  5. How to convert a Google Sheets-File to an Excel-File (XLSX)
  6. Script to convert .XLSX to Google Sheet and move converted file
  7. Converting .xls to google spreadsheet in google apps script
  8. google script openById : You do not have permission to perform that action
  9. Refresh data retrieved by a custom function in Google Sheet
  10. Create Google Calendar Events from Spreadsheet but prevent duplicates
  11. ultimate short custom number formatting – K, M, B, T, etc., Q, D, Googol
  12. Cannot find method getRange(number,number)?
  13. How do I add formulas to Google Sheets using Google Apps Script?
  14. Deleting rows in google sheets using Google Apps Script
  15. Adding Buttons To Google Sheets and Set value to Cells on clicking
  16. How do I communicate a page(modal dialog) with its sibling (sidebar)?
  17. How to replace text in Google Spreadsheet using App Scripts?
  18. Permanently delete file from google drive
  19. Custom function throws a “You do not have the permission required to setValue” error
  20. Margins parameters for Google spreadsheet export as PDF
  21. Google Apps Script: Dynamically creating spreadsheet menu items
  22. In Google Apps Script, how would I get all subfolders and all subsubfolders and all subsubsub folders etc.?
  23. Hidden field in a Google Form
  24. Apply multiple font colors to the text in a single Google Sheets cell
  25. Google Sheet use Importxml error could not fetch url [duplicate]
  26. On Edit doesnt work if cell auto updates – Need a workaround Google Sheets
  27. TypeError: Cannot read property ‘getRange’ of null (line 6, file “Code”) in google sheet script [duplicate]
  28. .setFormula() and received error missing ) argument list
  29. How can I merge multiple tabs in a Google Spreadsheet using Google App Script?
  30. Convert a gdoc into image

Leave a Comment