How to send mail from nodemailer that attach the .xlsx that written by excel4node hosting by firebase cloud function

Question

I want to send mail from nodemailer that attaches .xlsx that written from excel4node libs. I don't know how to do it but I can do both things solely.

I have tried writing the file and store as temp then bring the file up again but firebase pop-up the error Error: EROFS: read-only file system, open

I really have no idea how to do it please help. thank in advance.

score 1 · Answer 1 · answered Jul 28 '19 at 02:29

1

I got it!!!. using writing buffer from excel4node and then send them to the content of attachment

answered Jul 28 '19 at 02:29

Natthapol Maneechote

91
1
9

Can you share your solution? – Daniel Danielecki Dec 03 '20 at 10:43
just as I said I send the excel I wrote with excel4node by its writing buffer function and then put them in attachment key in config json of nodemailer – Natthapol Maneechote Jan 05 '21 at 16:35

score 1 · Accepted Answer · answered Nov 07 '21 at 05:43

1

const xl = require('excel4node');

async sendMail(data) {
var wb = new xl.Workbook();
var ws = wb.addWorksheet('SHEET_NAME');
ws.cell(1, 1).string('ALL YOUR EXCEL SHEET FILE CONTENT');
let buffer_xlsx = await wb.writeToBuffer();


// in the option header of nodeMailer
header: {
    from: 'abc@example.com',
    to: 'xyz@example.com',
    subject: 'Excel File',
    attachments = [
    {
        filename: 'report_' + filename + '.xlsx',
        content: buffer_xlsx,
    }]
}

answered Nov 07 '21 at 05:43

Tanakom Talawat

56
1
1

Thank you for the code. This is the exact code for the solution, which I commented below. I have lost that piece of code. So I didn't uploaded it. Thank you again for your contribution!. – Natthapol Maneechote Jan 05 '22 at 13:53

How to send mail from nodemailer that attach the .xlsx that written by excel4node hosting by firebase cloud function

2 Answers2