Google Script – convert sheet to XLSX

by

You can follow this tutorial on how to convert the current Google Spreadsheet to Excel XLSX format and then emails the file as an attachment to the specified user using getGoogleSpreadsheetAsExcel() method.

function getGoogleSpreadsheetAsExcel(){

  try {

    var ss = SpreadsheetApp.getActive();

    var url = "https://docs.google.com/feeds/download/spreadsheets/Export?key=" + ss.getId() + "&exportFormat=xlsx";

    var params = {
      method      : "get",
      headers     : {"Authorization": "Bearer " + ScriptApp.getOAuthToken()},
      muteHttpExceptions: true
    };

    var blob = UrlFetchApp.fetch(url, params).getBlob();

    blob.setName(ss.getName() + ".xlsx");

    MailApp.sendEmail("[email protected]", "Google Sheet to Excel", "The XLSX file is attached", {attachments: [blob]});

  } catch (f) {
    Logger.log(f.toString());
  }
}

Here are some similar threads which might help:

More Related Contents:

  1. How to convert a Google Docs-File to an Excel-File (XLSX)
  2. Script to convert .XLSX to Google Sheet and move converted file
  3. Save excel file multiple times with file names in another workbook.
  4. Is it possible to force Excel recognize UTF-8 CSV files automatically?
  5. Read/Parse text file line by line in VBA
  6. Excel VBA: Answer gets “stuck”
  7. filter out multiple criteria using excel vba
  8. Excel VBA autofilter all but three
  9. Cells.Find() Raises “Runtime Error 91: Object Variable or With Block Not Set”
  10. Generating CSV file for Excel, how to have a newline inside a value
  11. Excel VBA code to copy a specific string to clipboard
  12. No permission to call msgBox in Google Apps Scripting
  13. Excel VBA – Range.Copy transpose paste
  14. Periodically refresh IMPORTXML() spreadsheet function
  15. How do you get a Range to return its Name?
  16. UiApp has been deprecated. Please use HtmlService instead
  17. What does — do in Excel formulas?
  18. Excel Formula to SUMIF date falls in particular month
  19. In Excel, can I use a hyperlink to run vba macro?
  20. How to get filtered values from Filter after using setColumnFilterCriteria?
  21. Can I export excel data with UTF-8 without BOM?
  22. Best way to protect Excel VBA code? [closed]
  23. Why does Excel not round according to 8-byte IEEE 754
  24. VBA: Remove duplicates fails when columns array is passed using a variable
  25. Generate N random numbers whose sum is a constant K – Excel
  26. How do I read data from a spreadsheet using the OpenXML Format SDK?
  27. Add timestamp to named column in Google Spreadsheet onEdit script
  28. Delete all data rows from an Excel table (apart from the first)
  29. Converting Google spreadsheet date into a JS Date object?
  30. Excel VBA Run-time Error ‘32809’ – Trying to Understand it

Leave a Comment