Export Data To Excel With Multiple Sheets In Oracle VBCS | Create Excel Files In VBCS
Library : "https://cdnjs.cloudflare.com/ajax/lib..."
JS Function:
define([], function() {
'use strict';
var PageModule = function PageModule() {};
PageModule.prototype.downloadExcelFromSource = function (data) {
var createXLSLFormatObj = [];
var xlsHeader = ["First Name", "Last Name", "Age", "Department"];
createXLSLFormatObj.push(xlsHeader);
$.each(data, function (index, value) {
var innerRowData = [];
innerRowData.push(value.firstName);
innerRowData.push(value.lastName);
innerRowData.push(value.age);
innerRowData.push(value.department);
createXLSLFormatObj.push(innerRowData);
});
let filename = "MyDownload.xlsx";
//Specify the Sheet Name
var ws_name = "Employee";
//The book_new utility function creates an empty workbook with no worksheets.
let wb = XLSX.utils.book_new();
let ws = XLSX.utils.aoa_to_sheet(createXLSLFormatObj); //The aoa_to_sheet utility function walks an "array of arrays" in row-major order, generating a worksheet object.
/* Add worksheet to workbook */
XLSX.utils.book_append_sheet(wb, ws, ws_name); //XLSX.utils.book_append_sheet(workbook, worksheet, sheet_name);
//var new_name = XLSX.utils.book_append_sheet(workbook, worksheet, name, true); If the fourth argument is true, the function will start with the specified worksheet name.
XLSX.writeFile(wb, filename);
};
return PageModule;
});