jkexcel

# jkexcel

Manipulate .xlsx files - easy.

Notes and information

Installation

npm install jkexcel --save

What KExcel supports

• Reading .xlsx files from a file or a stream

• Pure javascript, works on all operating systems.

• Read sheet data and get values from:

  • Cells
  • Rows
  • Whole sheet

• Supports creating empty files and sheets

  • Set strings / numbers or formulas to cells
  • Copy contents from other sheets
  • Copy cell styles from other cells

What JKExcel does not (yet?)

• Calculations - you may set formulas, but they are only computed the next time you open the file in an spreadsheet editor (e.g. Excel or LibreOffice Calc)
• Styles - Setting custom styles
• Support for other spreadsheet cell types (e.g. date, hours, etc.)

TL;DR Simple Usage Examples

Create a new .xlsx file from scratch

var fs = require('fs');
var jkexcel = require('jkexcel');
jkexcel.new().then(function (wb) {
  var sheet = wb.getSheet(0);
  sheet.setCellValue(1, 1, 'Hello world!');
  return wb.pipe(fs.createWriteStream('output.xlsx'));
});

Modify an existing .xlsx file and send it through a http response (express)

var path = require('path');
var express = require('express');
var app = express();
var jkexcel = require('jkexcel');
 
app.get('/', function (req, res) {
    jkexcel.open(path.join(__dirname, 'example.xlsx')).then(function(workbook) {
        var sheet = workbook.getSheet(0);
        sheet.setCellValue(1,1,'Hello World!');
        sheet.setRow(2, ['Hello', 'even', 'more', 'Worlds']);
        sheet.setRow(3, [1, '+', 2, 'equals','=A3+C3']);
 
        res.setHeader('Content-disposition', 'attachment; filename=example.xlsx');
        res.setHeader('Content-type', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
        workbook.pipe(res);
    });
});
 
var server = app.listen(3000, function () {
    var host = server.address().address;
    var port = server.address().port;
 
    console.log('JKExcel app listening at http://%s:%s', host, port);
});