Export Data To Excel With Multiple Sheets In Oracle VBCS | Create Excel Files In VBCS

Library : "https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.16.0/xlsx.full.min.js"
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;
});

Видео Export Data To Excel With Multiple Sheets In Oracle VBCS | Create Excel Files In VBCS канала ME_2_CS