plunkerでexceljs

概要

plunkerでexceljs、やってみた。

サンプルコード

function run() {
	let wb = new ExcelJS.Workbook();
	var sheet1 = wb.addWorksheet("test");
	var worksheet = wb.getWorksheet("test");
	worksheet.getCell(1, 1).value = "商品";
	worksheet.getCell(2, 1).value = "りんご";
	worksheet.getCell(3, 1).value = "みかん";
	worksheet.getCell(4, 1).value = "ぶどう";	
	worksheet.getCell('B1').value = "Item";
	worksheet.getCell('C1').value = "Plice";
	var Item = [["apple", 150], ["orange", 200], ["grape", 280]];
	for (var row = 0; row < Item.length; row++)
	{
		worksheet.getCell(row + 2, 2).value = Item[row][0];
		worksheet.getCell(row + 2, 3).value = Item[row][1];
	}
	worksheet.mergeCells('A5:C5');
	worksheet.getCell('A5').value =  {
		formula: "SUM(C2:C4)"
	};
	wb.xlsx.writeBuffer().then(function(buffer) {
		var blob = new Blob([buffer], {
			type: "application/octet-stream"
		});
		var url = URL.createObjectURL(blob);
		var a = document.createElement('A');
		a.download = 'test.xlsx';
		a.href = url;
		document.body.appendChild(a);
		a.click();
		document.body.removeChild(a);
	});
	alert("ok");
}

成果物

以上。