Hello Manuel,
Following the attached guide, I was able to create a script that uses the exceljs library to convert from a CSV file string to an Excel spreadsheet. Unfortunately, our Javascript action does not support a file/binary output type, and when using a string output I believed it’s converting the Excel spreadsheet to UTF-8 encoding. That’s a problem because the Excel spreadsheet is actually a zipped folder, and converting to UTF-8 corrupts the file. I’m not sure there’s a way around this, but I’ll continue to explore.
Here’s the script I used with the example:
constExcel =require('exceljs');
const {Readable } =require('stream');
constmyFunction =async (input)=> {
constoutput = {};
conststream =Readable.from(input.string_in);
constworkbook =newExcel.Workbook();
constworksheet =awaitworkbook.csv.read(stream);
constbuffer =awaitworkbook.xlsx.writeBuffer();
output.string_out = buffer.toString('binary');
console.log(output.string_out);
returnoutput;
}
exports.main = async (input)=> {
returnawaitmyFunction(input);
}
Regards,
