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

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

http.createServer(function(req, res){
	switch(req.url){
		case '/download':
			var wb = new xl.WorkBook();
			var ws = wb.WorkSheet('Sheet 1');
			ws.Cell(1,1).String('String');
			wb.write('Excel.xlsx', res);

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

const wb = new xl.Workbook();
const ws = wb.addWorksheet('sheet1');
const ws2 = wb.addWorksheet('sheet2');

ws2.cell(1,1).string('value 1');
ws2.cell(2,1).string('value 2');
ws2.cell(3,1).string('value 3');

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

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 xl = require('excel4node');

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

var indianCurrency = wb.createStyle({
  numberFormat: '[>=10000000]"RS "##\\,##\\,##\\,##0;[>=100000]"RS "\\ ##\\,##\\,##0;"RS "##,##0',
});
ws.column(1).setWidth(15);
ws.cell(1,1).number(12.34).style(indianCurrency); // displays as "RS 12"

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 costsObj = {
  'supplies': {
    'paper': 100,
    'toner': 50,
  },
  'equipment': {
    'laptops': 3500,
    'accessories': 150

natergj

const xl = require('excel4node');

const wb = new xl.Workbook({
  workbookView: {
    activeTab: 1,
  },
});

const hiddenWorksheet = wb.addWorksheet('Hidden', {
  hidden: true,