natergj

// Uses excel4node version 1.x.x

var xl = require('excel4node');

var wb = new xl.Workbook({
    dateFormat: 'm/d/yy hh:mm:ss'
});

var ws = wb.addWorksheet('Dates');

natergj

const xl = require('excel4node');

// Create workbook and add worksheet
const wb = new xl.Workbook();
const ws = wb.addWorksheet('Data', {
  disableRowSpansOptimization: true,
});

// Generate some fake data for testing
const data = [];

natergj

// Require library 
const xl = require('excel4node');

// Create a new instance of a Workbook class 
const wb = new xl.Workbook();

// Add Worksheets to the workbook 
const ws = wb.addWorksheet('Background Color');

// create a style with solid background color

natergj

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

var xl = require('excel4node');

var wb = new xl.Workbook();
var ws = wb.addWorksheet('test');

// Create a reusable style
var style = wb.createStyle({
	numberFormat: '#.00%; -#.00%; -'
});

natergj

var express = require('express');
var xl = require('excel4node');

var app = express();

app.get('/', function(req, res){
	res.end('Hello World');
});

app.get('/myreport', function(req, res) {

natergj

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

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",

natergj

const xl = require('excel4node');

const costsObj = {
  'supplies': {
    'paper': 100,
    'toner': 50,
  },
  'equipment': {
    'laptops': 3500,
    'accessories': 150

natergj

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')