sheetjs_sheetjs/docbits/00_intro.md

# [SheetJS](http://sheetjs.com)

Parser and writer for various spreadsheet formats.  Pure-JS cleanroom
implementation from official specifications, related documents, and test files.
Emphasis on parsing and writing robustness, cross-format feature compatibility
with a unified JS representation, and ES3/ES5 browser compatibility back to IE6.

This is the community version.  We also offer a pro version with performance
enhancements, additional features like styling, and dedicated support.


[**Pro Version**](http://sheetjs.com/pro)

[**Commercial Support**](http://sheetjs.com/support)

[**Rendered Documentation**](http://docs.sheetjs.com/)

[**In-Browser Demos**](http://sheetjs.com/demos)

[**Source Code**](http://git.io/xlsx)

[**Issues and Bug Reports**](https://github.com/sheetjs/sheetjs/issues)

[**File format support for known spreadsheet data formats:**](#file-formats)

<details>
  <summary><b>Graph of supported formats</b> (click to show)</summary>

![circo graph of format support](formats.png)

![graph legend](legend.png)

</details>

[**Browser Test**](http://oss.sheetjs.com/sheetjs/tests/)

[![Build Status](https://saucelabs.com/browser-matrix/sheetjs.svg)](https://saucelabs.com/u/sheetjs)

[![Build Status](https://semaphoreci.com/api/v1/sheetjs/sheetjs/branches/master/shields_badge.svg)](https://semaphoreci.com/sheetjs/sheetjs)
[![Coverage Status](http://img.shields.io/coveralls/SheetJS/sheetjs/master.svg)](https://coveralls.io/r/SheetJS/sheetjs?branch=master)
[![Dependencies Status](https://david-dm.org/sheetjs/sheetjs/status.svg)](https://david-dm.org/sheetjs/sheetjs)
[![npm Downloads](https://img.shields.io/npm/dt/xlsx.svg)](https://npmjs.org/package/xlsx)
[![Analytics](https://ga-beacon.appspot.com/UA-36810333-1/SheetJS/sheetjs?pixel)](https://github.com/SheetJS/sheetjs)
SYLK shared formulae 2021-08-11 02:53:38 +00:00			`# [SheetJS](http://sheetjs.com)`
Documentation improvements - multiformat column widths (fixes #591 h/t @sheeeeep) - skip nested BIFF files 2017-03-20 09:02:25 +00:00
			`Parser and writer for various spreadsheet formats. Pure-JS cleanroom`
			`implementation from official specifications, related documents, and test files.`
			`Emphasis on parsing and writing robustness, cross-format feature compatibility`
			`with a unified JS representation, and ES3/ES5 browser compatibility back to IE6.`

rich text HTML + preview 2017-04-20 03:24:48 +00:00			`This is the community version. We also offer a pro version with performance`
Knockout Demo [ci skip] fixes #1061 2018-05-21 01:41:01 +00:00			`enhancements, additional features like styling, and dedicated support.`
version bump 0.10.0: cleanup - updated SSF to 0.9.2 - XLSB style records and number format writing - CSV avoid parseFloat (fixes #646 h/t @jabbermarky) - CSV recognize mac line ending (fixes #648 h/t @charlesread) - BIFF2 format table refactored to align with SSF - BIFF5 image data exposure - SSF custom format auto table update (fixes #267 h/t @Fangmingdu) - eslint more checks - browser test timeout extended to 10 seconds 2017-05-09 18:07:57 +00:00
Documentation improvements - multiformat column widths (fixes #591 h/t @sheeeeep) - skip nested BIFF files 2017-03-20 09:02:25 +00:00
rich text HTML + preview 2017-04-20 03:24:48 +00:00			`[Pro Version](http://sheetjs.com/pro)`
Documentation improvements - multiformat column widths (fixes #591 h/t @sheeeeep) - skip nested BIFF files 2017-03-20 09:02:25 +00:00
rich text HTML + preview 2017-04-20 03:24:48 +00:00			`[Commercial Support](http://sheetjs.com/support)`
Documentation improvements - multiformat column widths (fixes #591 h/t @sheeeeep) - skip nested BIFF files 2017-03-20 09:02:25 +00:00
hodgepodge of fixes - missing formula elements rewritten to valid defined names (see #680) - comment author length limit enforced - XLS ifmt references renamed to numFmtId for consistency with XLSB - removed circular symlink - mangle/compress with uglify - more flow comments 2017-07-27 20:07:51 +00:00			`[Rendered Documentation](http://docs.sheetjs.com/)`
more format parity - XLS/XLSX/XLSB/XML/ODS cellFormula option + test - XLS/XLSX/XLSB/XML/ODS cellText option + test - XML document property order - XML write margins + protection - removed gitbook search 2017-04-26 02:27:12 +00:00
rich text HTML + preview 2017-04-20 03:24:48 +00:00			`[In-Browser Demos](http://sheetjs.com/demos)`

			`[Source Code](http://git.io/xlsx)`

update badges [ci skip] 2019-11-15 02:01:30 +00:00			`[Issues and Bug Reports](https://github.com/sheetjs/sheetjs/issues)`
Documentation improvements - multiformat column widths (fixes #591 h/t @sheeeeep) - skip nested BIFF files 2017-03-20 09:02:25 +00:00
version bump 0.10.0: cleanup - updated SSF to 0.9.2 - XLSB style records and number format writing - CSV avoid parseFloat (fixes #646 h/t @jabbermarky) - CSV recognize mac line ending (fixes #648 h/t @charlesread) - BIFF2 format table refactored to align with SSF - BIFF5 image data exposure - SSF custom format auto table update (fixes #267 h/t @Fangmingdu) - eslint more checks - browser test timeout extended to 10 seconds 2017-05-09 18:07:57 +00:00			`[File format support for known spreadsheet data formats:](#file-formats)`
Documentation improvements - multiformat column widths (fixes #591 h/t @sheeeeep) - skip nested BIFF files 2017-03-20 09:02:25 +00:00
browser tests and doc cleanup [ci skip] 2017-04-30 20:37:53 +00:00			`<details>`
demo refresh [ci skip] 2017-09-24 23:40:09 +00:00			`<summary><b>Graph of supported formats</b> (click to show)</summary>`
version bump 0.10.0: cleanup - updated SSF to 0.9.2 - XLSB style records and number format writing - CSV avoid parseFloat (fixes #646 h/t @jabbermarky) - CSV recognize mac line ending (fixes #648 h/t @charlesread) - BIFF2 format table refactored to align with SSF - BIFF5 image data exposure - SSF custom format auto table update (fixes #267 h/t @Fangmingdu) - eslint more checks - browser test timeout extended to 10 seconds 2017-05-09 18:07:57 +00:00
			`![circo graph of format support](formats.png)`
browser tests and doc cleanup [ci skip] 2017-04-30 20:37:53 +00:00
TXT/PRN - UTF-16 Unicode Text (TXT) write - Lotus Formatted Text (PRN) read/write - DBF version 2 field length adjustments - throw errors if SheetNames is invalid (fixes #376 h/t @pietersv) 2017-04-03 00:16:03 +00:00			`![graph legend](legend.png)`
Documentation improvements - multiformat column widths (fixes #591 h/t @sheeeeep) - skip nested BIFF files 2017-03-20 09:02:25 +00:00
browser tests and doc cleanup [ci skip] 2017-04-30 20:37:53 +00:00			`</details>`
Documentation improvements - multiformat column widths (fixes #591 h/t @sheeeeep) - skip nested BIFF files 2017-03-20 09:02:25 +00:00
update badges [ci skip] 2019-11-15 02:01:30 +00:00			`[Browser Test](http://oss.sheetjs.com/sheetjs/tests/)`
version bump 0.10.0: cleanup - updated SSF to 0.9.2 - XLSB style records and number format writing - CSV avoid parseFloat (fixes #646 h/t @jabbermarky) - CSV recognize mac line ending (fixes #648 h/t @charlesread) - BIFF2 format table refactored to align with SSF - BIFF5 image data exposure - SSF custom format auto table update (fixes #267 h/t @Fangmingdu) - eslint more checks - browser test timeout extended to 10 seconds 2017-05-09 18:07:57 +00:00
			`[![Build Status](https://saucelabs.com/browser-matrix/sheetjs.svg)](https://saucelabs.com/u/sheetjs)`

update badges [ci skip] 2019-11-15 02:01:30 +00:00			`[![Build Status](https://semaphoreci.com/api/v1/sheetjs/sheetjs/branches/master/shields_badge.svg)](https://semaphoreci.com/sheetjs/sheetjs)`
			`[![Coverage Status](http://img.shields.io/coveralls/SheetJS/sheetjs/master.svg)](https://coveralls.io/r/SheetJS/sheetjs?branch=master)`
			`[![Dependencies Status](https://david-dm.org/sheetjs/sheetjs/status.svg)](https://david-dm.org/sheetjs/sheetjs)`
demo refresh [ci skip] 2017-09-24 23:40:09 +00:00			`[![npm Downloads](https://img.shields.io/npm/dt/xlsx.svg)](https://npmjs.org/package/xlsx)`
update badges [ci skip] 2019-11-15 02:01:30 +00:00			`[![Analytics](https://ga-beacon.appspot.com/UA-36810333-1/SheetJS/sheetjs?pixel)](https://github.com/SheetJS/sheetjs)`
version bump 0.10.0: cleanup - updated SSF to 0.9.2 - XLSB style records and number format writing - CSV avoid parseFloat (fixes #646 h/t @jabbermarky) - CSV recognize mac line ending (fixes #648 h/t @charlesread) - BIFF2 format table refactored to align with SSF - BIFF5 image data exposure - SSF custom format auto table update (fixes #267 h/t @Fangmingdu) - eslint more checks - browser test timeout extended to 10 seconds 2017-05-09 18:07:57 +00:00