Download the table "automatically" as .xlsx to the local machine on the event

Question

See below the function that converts the active Google spreadsheet to a .xlsx file. The script saves the file in Google Drive.

function downloadAsXlsx() {

var spreadSheet = SpreadsheetApp.getActiveSpreadsheet(); 
var ssID = spreadSheet.getId();

Logger.log(ssID);

var url = "https://docs.google.com/spreadsheets/d/"+ssID+"/export?format=xlsx";   
var params = {method:"GET", headers:{"authorization":"Bearer "+ ScriptApp.getOAuthToken()}};
var response = UrlFetchApp.fetch(url, params);

// save to drive
DriveApp.createFile(response);

}

If you replace the ssID in the above URL with the actual file ID of the active Google spreadsheet and copy and paste the URL into the browser, the active spreadsheet is downloaded “automatically”. This is exactly what I need to add the above script.

My question is how to change and / or expand the function above so that the file is instead downloaded to the local download folder by default?

Answer 1

, , , XLS- Google Spreadsheet Google Drive. Google , ... , . , HTTP- Google Sheet, , , , .

Google Apps Script , . . , " ", Google , , .

. HTML, <a> (/** * Adds a custom menu * * @param {Object} e The event parameter for a simple onOpen trigger. */ function onOpen(e) { SpreadsheetApp.getUi() .createMenu('Custom') .addItem('Download as XLSX', 'downloadXLS_GUI') .addToUi(); } /** * Display a modal dialog with a single download link. * * From: http://stackoverflow.com/a/37336778/1677912 */ function downloadXLS_GUI() { // Get current spreadsheet ID, place in download URL var ssID = SpreadsheetApp.getActive().getId(); var URL = 'https://docs.google.com/spreadsheets/d/'+ssID+'/export?format=xlsx'; // Display a modal dialog box with download link. var htmlOutput = HtmlService .createHtmlOutput('<a href="'+URL+'">Click to download</a>') .setSandboxMode(HtmlService.SandboxMode.IFRAME) .setWidth(80) .setHeight(60); SpreadsheetApp.getUi().showModalDialog(htmlOutput, 'Download XLS'); }