Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
Creates SpreadsheetML (.xlsx) files in sequence with streaming interface.
CoffeeScript JavaScript
branch: master

Merge pull request #3 from nerds-odd-e/Number_formats

Thank you for the excellent patch!
latest commit 78267a6b53
@nunukim authored
Failed to load latest commit information.
lib Support for Number Formats
src Support for Number Formats
test Support for Number Formats
.DS_Store README
.gitignore added
Gruntfile.coffee added
LICENSE Initial commit
README.md Support for Number Formats
a.js Date format
package.json release 0.1.2

README.md

node-xlsx-stream

Creates SpreadsheetML (.xlsx) files in sequence with streaming interface.

  • Installation

    npm install xlsx-stream
    
  • Features

    Multiple sheets, String, Number, Date, Duration, Cell Formats
    
  • Usage

    # coffee-script
    xlsx = require "xlsx-stream"
    fs = require "fs"
    
    x = xlsx()
    x.pipe fs.createWriteStream("./out.xlsx")
    
    x.write ["foo", "bar", "buz"]
    x.write [1,2,3]
    x.write ["Date", new Date]
    x.write ["Duration", { v: 1.5, t: 'n', nf: '[h]:mm:ss' }]
    x.write ["Formula", {v: "ok", f: "CONCATENATE(A1,B2)"}]
    x.write ["Percentage Built-in format #9", { v: 0.5, nf: '0.00%' }]
    x.write ["Percentage Custom format", { v: 0.5, nf: '00.000%' }]
    
    x.end()
    
  • Multiple sheets support

    # coffee-script
    
    x = xlsx()
    x.pipe fs.createWriteStream("./out.xlsx")
    
    sheet1 = x.sheet('first sheet')
    sheet1.write ["first", "sheet"]
    sheet1.end()
    
    sheet2 = x.sheet('another')
    sheet2.write ["second", "sheet"]
    sheet2.end()
    
    x.finalize()
    
  • Help Wanted

    Comments
    
Something went wrong with that request. Please try again.