Has someone created an xlsx file using file.create...
# suitescriptj
Jaime Requena
12/19/2019, 7:44 PMHas someone created an xlsx file using file.create? If so, how did you generate the file and save?
b
battk
12/19/2019, 7:49 PMyour only hope in suitescript is getting sheet.js to work
j
Jaime Requena
12/19/2019, 7:50 PMTrying but it doesn't save file correctly
b
battk
12/19/2019, 7:51 PMyou will need to be more specific than that
j
Jaime Requena
12/19/2019, 7:52 PMar wb = xlsx.utils.book_new();
wb.Props = {
Title: fileName,
Subject: fileName,
Author: "",
CreatedDate: new Date()
};
wb.SheetNames.push("Sheet1");
var ws = xlsx.utils.aoa_to_sheet(rows);
wb.Sheets[fileName] = ws;
//var wbout = XLSX.write(wb, {bookType:'xlsx', type: 'binary'});
/*
const result = xlsx.write(wb, {
BookType:'xlsx', // output file type
Type:'buffer', // data type of output
Compression: true // turn on zip compression
});*/
//var result = xlsx.write(wb, {bookType:"xlsx", type:'base64'});
//var result = xlsx.write(wb, {bookType:"xlsx", type:'binary'});
var result = xlsx.write(wb);
var fileObj = file.create({
name: fileName + '-' + dateString + '.xlsx',
fileType: file.Type.EXCEL,
contents: result,
folder: netsuiteFolder
});
b
battk
12/19/2019, 7:57 PMwhat error ar you getting
j
Jaime Requena
12/19/2019, 7:59 PMfiles generate but they don't open in excel
Jaime Requena
12/19/2019, 7:59 PMdata looks incorrect
Jaime Requena
12/19/2019, 7:59 PMmaybe something with the xlsx.write function
b
battk
12/19/2019, 8:08 PMexcel files are treated as binary
battk
12/19/2019, 8:08 PMthe contents need to be base 64 encoded
j
Jaime Requena
12/19/2019, 8:11 PMyes, I finally got it to work
Jaime Requena
12/19/2019, 8:12 PMas xls anyway.. I wasn't adding the sheet correctly as you can see in my code
Jaime Requena
12/19/2019, 8:12 PMthanks for your help
Jaime Requena
12/19/2019, 8:15 PMxlsx doesn't work whenusing fileType EXCEL