Excel (XLSB/XLSX/XLSM/XLS/XML) and ODS spreadsheet parser and writer (extended to enable read/write of cell formats with xlsx files). 

Excel (XLSB/XLSX/XLSM/XLS/XML) and ODS spreadsheet parser and writer (extended to enable read/write of cell formats with xlsx files)

protobi

xlsx-style

  var range = {s: {c:10000000, r:10000000}, e:{c:0, r:0}};

      if (range.s.r > row) { range.s.r = row;}

  if (range.s.c > col) { range.s.c = col; }

  if (range.e.r < row) { range.e.r = row; }

  if (range.e.c < col) { range.e.c = col; }

    function addCell(wb, ws, value, type, row, col, styles) {

        var cell = {t: type, v: value, s:styles};

    // i use d to recognize that the format is a date, and if it is, i use z attribute to format it

    var cell_ref = XLSX.utils.encode_cell({c: col, r:row});

        var buf = new ArrayBuffer(s.length);

        for (var i=0; i!=s.length; ++i) view[i] = s.charCodeAt(i) & 0xFF;

        return (epoch - new Date(Date.UTC(1899, 11, 30))) / (24 * 60 * 60 * 1000);

    /* Here i add a cell with format number with value 10*/

    addCell(wb, ws, 10, 'n', 0, 0, ATTRIBUTE_VALUE_STYLE);

/* Here i add a cell with format number that is current date*/

addCell(wb, ws, datenum(new Date()), 'd', 0, 1, ATTRIBUTE_VALUE_STYLE);

/* Here i add a cell with format number with value 10, again another number*/

addCell(wb, ws, 10, 'd', 0, 2, ATTRIBUTE_VALUE_STYLE);

ws['!ref'] = XLSX.utils.encode_range(range);

  /* bookType can be 'xlsx' or 'xlsm' or 'xlsb' */

  var wopts = { bookType:'xlsx', bookSST:false, type:'binary' };

var defaultCellStyle =  { font: { name: "Verdana", sz: 11, color: "FF00FF88"}, fill: {fgColor: {rgb: "FFFFAA00"}}};

var wopts = { bookType:'xlsx', bookSST:false, type:'binary', defaultCellStyle: defaultCellStyle, showGridLines: false};

//console.log(JSON.stringify(wb, null,4))

XLSX.writeFile(wb, OUTFILE, {defaultCellStyle: { font: { name: "Verdana", sz: 11, color: "FF00FF88"}, fill: {fgColor: {rgb: "FFFFAA00"}}}});

console.log("Results written to " + OUTFILE)

	"description": "Excel (XLSB/XLSX/XLSM/XLS/XML) and ODS spreadsheet parser and writer (extended to enable read/write of cell formats with xlsx files)",

	"keywords": [ "excel", "xls", "xlsx", "xlsb", "xlsm", "ods", "office", "spreadsheet" ],

	"repository": { "type":"git", "url":"git://github.com/protobi/js-xlsx.git#beta" },

		"pretest": "git submodule init && git submodule update",

	"bugs": { "url": "https://github.com/protobi/js-xlsx/issues" },

Parser and writer for various spreadsheet formats.  Pure-JS cleanroom

implementation from official specifications and related documents.

**NOTE:** [This project](https://github.com/SheetJS/js-xlsx/tree/beta) is a fork of the original (and awesome) [SheetJS/xlsx](https://github.com/SheetJS/js-xlsx) project.

It is extended to enable cell formats to be read from and written to .xlsx workbooks.

The intent is to provide a temporary means of using these features in practice, and ultimately to merge this into the primary project.

Report any issues to https://github.com/protobi/js-xlsx/issues.

* `master` is the main branch, which follows the original repo to enable a future pull request.

* `beta` branch is published to npm and bower to make this fork available for use.

- Excel 2003-2004 XML Format (XML "SpreadsheetML")

With [npm](https://www.npmjs.org/package/xlsx-style):

With [bower](http://bower.io/search/?q=js-xlsx):

CDNjs automatically pulls the latest version and makes all versions available at

The node version automatically requires modules for additional features.  Some

of these modules are rather large in size and are only needed in special

circumstances, so they do not ship with the core.  For browser use, they must

An appropriate version for each dependency is included in the dist/ directory.

The complete single-file version is generated at `dist/xlsx.full.min.js`

Since xlsx.js uses ES5 functions like `Array#forEach`, older browsers require

[Polyfills](http://git.io/QVh77g).  This repo and the gh-pages branch include

[a shim](https://github.com/SheetJS/js-xlsx/blob/master/shim.js)

To use the shim, add the shim before the script tag that loads xlsx.js:

For parsing, the first step is to read the file.  This involves acquiring the

data and feeding it into the library.  Here are a few common scenarios:

if(typeof require !== 'undefined') XLSX = require('xlsx');

var workbook = XLSX.readFile('test.xlsx');

| bookType    | 'xlsx'  | Type of Workbook ("xlsx" or "xlsm" or "xlsb") |

| showGridLines | true | Show gridlines on all pages |

| tabSelected | '1' | Initial tab selected |

- `bookSST` is slower and more memory intensive, but has better compatibility

- `bookType = 'xlsb'` is stubbed and far from complete

- The raw data is the only thing guaranteed to be saved.  Formulae, formatting,

  and other niceties may not be serialized (pending CSF standardization)

- `cellDates` only applies to XLSX output and is not guaranteed to work with

  third-party readers.  Excel itself does not usually write cells with type `d`

  so non-Excel tools may ignore the data or blow up in the presence of dates.

Cell styles are specified by a style object that roughly parallels the OpenXML structure.  The style object has five

top-level attributes: `fill`, `font`, `numFmt`, `alignment`, and `border`.

| Style Attribute | Sub Attributes | Values |

| :-------------- | :------------- | :------------- | :----- |

| fill            | patternType    |  `"solid"` or `"none"` |

|                 | fgColor        |  `COLOR_SPEC`

|                 | bgColor        |  `COLOR_SPEC`

| font            | name           |  `"Calibri"` // default

|                 | sz             |  `"11"` // font size in points

|                 | color          |  `COLOR_SPEC`

|                 | bold           |  `true || false`

|                 | underline      |  `true || false`

|                 | italic         |  `true || false`

|                 | strike         |  `true || false`

|                 | outline        |  `true || false`

|                 | shadow         |  `true || false`

|                 | vertAlign      |  `true || false`

| numFmt          |                |  `"0"`  // integer index to built in formats, see StyleBuilder.SSF property

|                 |                |  `"0.00%"` // string matching a built-in format, see StyleBuilder.SSF

|                 |                |  `"0.0%"`  // string specifying a custom format

|                 |                |  `"0.00%;\\(0.00%\\);\\-;@"` // string specifying a custom format, escaping special characters

|                 |                |  `"m/dd/yy"` // string a date format using Excel's format notation

| alignment       | vertical       | `"bottom"||"center"||"top"`

|                 | horizontal     | `"bottom"||"center"||"top"`

|                 | wrapText       |  `true || false`

|                 | readingOrder   |  `2` // for right-to-left

|                 | textRotation   | Number from `0` to `180` or `255` (default is `0`)

|                 |                |  `90` is rotated up 90 degrees

|                 |                |  `45` is rotated up 45 degrees

|                 |                | `135` is rotated down 45 degrees 

|                 |                | `180` is rotated down 180 degrees

|                 |                | `255` is special,  aligned vertically

| border          | top            | `{ style: BORDER_STYLE, color: COLOR_SPEC }`

|                 | bottom         | `{ style: BORDER_STYLE, color: COLOR_SPEC }`

|                 | left           | `{ style: BORDER_STYLE, color: COLOR_SPEC }`

|                 | right          | `{ style: BORDER_STYLE, color: COLOR_SPEC }`

|                 | diagonal       | `{ style: BORDER_STYLE, color: COLOR_SPEC }`

|                 | diagonalUp     | `true||false`

|                 | diagonalDown   | `true||false`

**COLOR_SPEC**: Colors for `fill`, `font`, and `border` are specified as objects, either:

* `{ auto: 1}` specifying automatic values

* `{ rgb: "FFFFAA00" }` specifying a hex ARGB value

* `{ theme: "1", tint: "-0.25"}` specifying an integer index to a theme color and a tint value (default 0)

* `{ indexed: 64}` default value for `fill.bgColor`

**BORDER_STYLE**: Border style is a string value which may take on one of the following values:

Borders for merged areas are specified for each cell within the merged area.  So to apply a box border to a merged area of 3x3 cells, border styles would need to be specified for eight different cells:

* left borders for the three cells on the left,

* right borders for the cells on the right

* bottom borders for the cells on the left

 - NodeJS 0.8, 0.10 (latest release), 0.11.14 (unstable), io.js

 - IE 6/7/8/9/10/11 using Base64 mode (IE10/11 using HTML5 mode)

Tests utilize the mocha testing framework.  Travis-CI and Sauce Labs links:

 - <https://travis-ci.org/SheetJS/js-xlsx> for XLSX module in nodejs

 - <https://travis-ci.org/SheetJS/SheetJS.github.io> for XLS* modules

 - <https://saucelabs.com/u/sheetjs> for XLS* modules using Sauce Labs

Test files are housed in [another repo](https://github.com/SheetJS/test_files).

		{
		"name": "xlsx-style",
		"version": "0.8.6",
		"version": "0.8.7",
		"author": "sheetjs",
		@@ -21,2 +21,3 @@ "description": "Excel (XLSB/XLSX/XLSM/XLS/XML) and ODS spreadsheet parser and writer (extended to enable read/write of cell formats with xlsx files)",
		"devDependencies": {
		"cheerio":"^0.19.0",
		"mocha":"",
		@@ -23,0 +24,0 @@ "xlsjs":"",

Improved metrics

Worsened metrics

		@@ -74,7 +74,8 @@ var XLSX = require('./');
		/* bookType can be 'xlsx' or 'xlsm' or 'xlsb' */
		var wopts = { bookType:'xlsx', bookSST:false, type:'binary' };
		var defaultCellStyle = { font: { name: "Verdana", sz: 11, color: "FF00FF88"}, fill: {fgColor: {rgb: "FFFFAA00"}}};
		var wopts = { bookType:'xlsx', bookSST:false, type:'binary', defaultCellStyle: defaultCellStyle, showGridLines: false};

		console.log(JSON.stringify(wb, null,4))
		//console.log(JSON.stringify(wb, null,4))
		var OUTFILE = '/tmp/wb.xlsx';
		XLSX.writeFile(wb, OUTFILE, {defaultCellStyle: { font: { name: "Verdana", sz: 11, color: "FF00FF88"}, fill: {fgColor: {rgb: "FFFFAA00"}}}});
		XLSX.writeFile(wb, OUTFILE, wopts);
		console.log("Results written to " + OUTFILE)

		@@ -491,2 +491,4 @@ # xlsx-style
		\| bookType \| 'xlsx' \| Type of Workbook ("xlsx" or "xlsm" or "xlsb") \|
		\| showGridLines \| true \| Show gridlines on all pages \|
		\| tabSelected \| '1' \| Initial tab selected \|

		@@ -493,0 +495,0 @@ - `bookSST` is slower and more memory intensive, but has better compatibility