Bonjour,
pas facile de travailler avec un script non indenté !
il faut que tu fasses 2 fois le parcours de transformer lesdites feuilles en fichiers excel comme suit
var ss = SpreadsheetApp.getActiveSpreadsheet()
var ssID = ss.getId();
var token = ScriptApp.getOAuthToken();
var sheetgId = ss.getSheetByName('mySheet1').getSheetId();
var sheetName = ss.getSheetName();
var url = "https://docs.google.com/spreadsheets/d/"+ssID+"/export?" + "format=xlsx" + "&gid="+sheetgId+ "&portrait=false" + "&exportFormat=xlsx";
var result = UrlFetchApp.fetch(url, {
headers: {
'Authorization': 'Bearer ' + token
}
});
var contents1 = result.getContent();
var sheetgId = ss.getSheetByName('mySheet2').getSheetId();
var sheetName = ss.getSheetName();
var url = "https://docs.google.com/spreadsheets/d/"+ssID+"/export?" + "format=xlsx" + "&gid="+sheetgId+ "&portrait=false" + "&exportFormat=xlsx";
var result = UrlFetchApp.fetch(url, {
headers: {
'Authorization': 'Bearer ' + token
}
});
var contents2 = result.getContent();
ce qui amène à partir des feuilles mySheet1
et mySheet2
à obtenir contents1
et contents2
et qu'en final tu joignes les 2 dans l'envoi
MailApp.sendEmail(emailAddress,
subject ,
body,
{attachments:[
{fileName:sheetName+".xlsx", content:contents1, mimeType:"application//xlsx"},
{fileName:sheetName+".xlsx", content:contents2, mimeType:"application//xlsx"}
]}
);