I need to know how to convert a sheet of the same drive in to an excel archive and send it. I don't want in PDF, the code is just an example.
function SendEmailWithCC(){
SpreadsheetApp.getActiveSpreadsheet().getSheetByName("BD").hideSheet();
SpreadsheetApp.getActiveSpreadsheet().getSheetByName("LISTA").hideSheet();
SpreadsheetApp.getActiveSpreadsheet().getSheetByName("PLANTILLA").hideSheet();
var plantilla = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("PLANTILLA");
var plantilla1 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("PLANTILLA").getRange("A1").getValue();
var plantilla2 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("PLANTILLA").getRange("A3").getValue();
var recipient = plantilla.getRange("E2").getValue();
var fecha2 = plantilla.getRange("E5").getValue();
var fecha = plantilla.getRange("E3").getValue();
var nombre = plantilla.getRange("E1").getValue();
var subject = plantilla1.replace("{Fecha2}", fecha2);
var body = plantilla2.replace("{NombreCompleto}", nombre)
.replace("{Fecha}", fecha);
var options = {
cc: "example.email@xxx.yy",
attachments: [SpreadsheetApp.getActiveSpreadsheet().getAs(MimeType.PDF).setName("Archivo de ajustes")]
}
MailApp.sendEmail(recipient, subject, body, options);
}