Skip to content

Instantly share code, notes, and snippets.

@natergj
natergj / freeze.js
Created October 19, 2018 12:30
Freeze 1st row on 2nd sheet only
const xl = require('excel4node')
const wb = new xl.Workbook()
const ws1 = wb.addWorksheet('sheet 1')
ws1.cell(1, 1).string('Sheet 1 - A1')
ws1.cell(5, 1).string('Sheet 1 - A5')
ws2 = wb.addWorksheet('sheet 2')
ws2.cell(1, 1).string('Sheet 2 - A1')
async function excelDataFiller(rowNumber) {
const startIndex = 2;
const j = rowNumber + 1;
const numDiff = getCountDiff(storage.allCountResults[rowNumber].csdbCount, storage.allCountResults[rowNumber].esCount);
const perDiff = (storage.allCountResults[rowNumber].csdbCount - storage.allCountResults[rowNumber].esCount) / storage.allCountResults[rowNumber].csdbCount;
/* Column parameters */
ws.column(1).setWidth(30);
ws.column(2).setWidth(27);
@natergj
natergj / wrapText.js
Created May 22, 2019 21:27
Text wrapping code snippet
const xl = require("excel4node");
const wb = new xl.Workbook();
const ws = wb.addWorksheet("Sheet1");
ws.cell(2, 5, 2, 11, true)
.string(
"There is a flower within my heart, Daisy, Daisy! Planted one day by a glancing dart, Planted by Daisy Bell! Whether she loves me or loves me not, Sometimes it's hard to tell; Yet I am longing to share the lot Of beautiful Daisy Bell!"
)
.style({
alignment: {
wrapText: true
@natergj
natergj / bg_color_font.js
Created July 25, 2019 13:57
excel4node background color and font
const xl = require("excel4node");
const wb = new xl.Workbook();
const ws = wb.addWorksheet("Background Color");
const greenBgColumnsRows = wb.createStyle({
font: { color: "black", size: 12 },
fill: {
type: "pattern",
patternType: "solid",
bgColor: "#33FF35",