Skip to content

Instantly share code, notes, and snippets.

@natergj
natergj / DataValidationIssue161
Created January 15, 2018 15:41
Attempt to recreate the behavior described in https://github.com/natergj/excel4node/issues/161
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');
// 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
natergj / excel4node http native sample
Created November 24, 2015 00:45
Very basic sample using node's native http module
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
natergj / excel4node express.js example
Created November 8, 2015 22:15
Very basic express.js app to create a route that generates and downloads a basic Excel workbook
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) {