js前端读取EXCEL文件

# [SheetJS js-xlsx](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/js-xlsx/issues) [**Other General Support Issues**](https://discourse.sheetjs.com) [**File format support for known spreadsheet data formats:**](#file-formats) <details> <summary><b>Graph of supported formats</b> (click to show)</summary>   </details> [**Browser Test**](http://oss.sheetjs.com/js-xlsx/tests/) [](https://saucelabs.com/u/sheetjs) [](https://travis-ci.org/SheetJS/js-xlsx) [](https://semaphoreci.com/sheetjs/js-xlsx) [](https://coveralls.io/r/SheetJS/js-xlsx?branch=master) [](https://david-dm.org/sheetjs/js-xlsx) [](https://npmjs.org/package/xlsx) [](https://ghit.me/repo/sheetjs/js-xlsx) [](https://github.com/SheetJS/js-xlsx) ## Table of Contents <details> <summary><b>Expand to show Table of Contents</b></summary> <!-- toc --> - [Installation](#installation) * [JS Ecosystem Demos](#js-ecosystem-demos) * [Optional Modules](#optional-modules) * [ECMAScript 5 Compatibility](#ecmascript-5-compatibility) - [Philosophy](#philosophy) - [Parsing Workbooks](#parsing-workbooks) * [Parsing Examples](#parsing-examples) * [Streaming Read](#streaming-read) - [Working with the Workbook](#working-with-the-workbook) * [Parsing and Writing Examples](#parsing-and-writing-examples) - [Writing Workbooks](#writing-workbooks) * [Writing Examples](#writing-examples) * [Streaming Write](#streaming-write) - [Interface](#interface) * [Parsing functions](#parsing-functions) * [Writing functions](#writing-functions) * [Utilities](#utilities) - [Common Spreadsheet Format](#common-spreadsheet-format) * [General Structures](#general-structures) * [Cell Object](#cell-object) + [Data Types](#data-types) + [Dates](#dates) * [Sheet Objects](#sheet-objects) + [Worksheet Object](#worksheet-object) + [Chartsheet Object](#chartsheet-object) + [Macrosheet Object](#macrosheet-object) + [Dialogsheet Object](#dialogsheet-object) * [Workbook Object](#workbook-object) + [Workbook File Properties](#workbook-file-properties) * [Workbook-Level Attributes](#workbook-level-attributes) + [Defined Names](#defined-names) + [Workbook Views](#workbook-views) + [Miscellaneous Workbook Properties](#miscellaneous-workbook-properties) * [Document Features](#document-features) + [Formulae](#formulae) + [Column Properties](#column-properties) + [Row Properties](#row-properties) + [Number Formats](#number-formats) + [Hyperlinks](#hyperlinks) + [Cell Comments](#cell-comments) + [Sheet Visibility](#sheet-visibility) + [VBA and Macros](#vba-and-macros) - [Parsing Options](#parsing-options) * [Input Type](#input-type) * [Guessing File Type](#guessing-file-type) - [Writing Options](#writing-options) * [Supported Output Formats](#supported-output-formats) * [Output Type](#output-type) - [Utility Functions](#utility-functions) * [Array of Arrays Input](#array-of-arrays-input) * [Array of Objects Input](#array-of-objects-input) * [HTML Table Input](#html-table-input) * [Formulae Output](#formulae-output) * [Delimiter-Separated Output](#delimiter-separated-output) + [UTF-16 Unicode Text](#utf-16-unicode-text) * [HTML Output](#html-output) * [JSON](#json) - [File Formats](#file-formats) * [Excel 2007+ XML (XLSX/XLSM)](#excel-2007-xml-xlsxxlsm) * [Excel 2.0-95 (BIFF2/BIFF3/BIFF4/BIFF5)](#excel-20-95-biff2biff3biff4biff5) * [Excel 97-2004 Binary (BIFF8)](#excel-97-2004-binary-biff8) * [Excel 2003-2004 (SpreadsheetML)](#excel-2003-2004-spreadsheetml) * [Excel 2007+ Binary (XLSB, BIFF12)](#excel-2007-binary-xlsb-biff12) * [Delimiter-Separated Values (CSV/TXT)](#delimiter-separated-values-csvtxt) * [Other Workbook Formats](#other-workbook-formats) + [Lotus 1-2-3 (WKS/WK1/WK2/WK3/WK4/123)](#lotus-1-2-3-wkswk1wk2wk3wk4123) + [Quattro Pro (WQ1/WQ2/WB1/WB2/WB3/QPW)](#quattro-pro-wq1wq2wb1wb2wb3qpw) + [OpenDocument Spreadsheet (ODS/FODS)](#opendocument-spreadsheet-odsfods) + [Uniform Office Spreadsheet (UOS1/2)](#uniform-office-spreadsheet-uos12) * [Other Single-Worksheet Formats](#other-single-worksheet-formats) + [dBASE and Visual FoxPro (DBF)](#dbase-and-visual-foxpro-dbf) + [Symbolic Link (SYLK)](#symbolic-link-sylk) + [Lotus Formatted Text (PRN)](#lotus-formatted-text-prn) + [Data Interchange Format (DIF)](#data-interchange-format-dif) + [HTML](#html) + [Rich Text Format (RTF)](#rich-text-format-rtf) + [Ethercalc Record Format (ETH)](#ethercalc-record-format-eth) - [Testing](#testing) * [Node](#node) * [Browser](#browser) * [Tested Environments](#tested-environments) * [Test Files](#test-files) - [Contributing](#contributing) * [OSX/Linux](#osxlinux) * [Windows](#windows) * [Tests](#tests) - [License](#license) - [References](#references) <!-- tocstop --> </details> ## Installation In the browser, just add a script tag: ```html <script lang="javascript" src="dist/xlsx.full.min.js"></script> ``` <details> <summary><b>CDN Availability</b> (click to show)</summary> | CDN | URL | |-----------:|:-------------------------------------------| | `unpkg` | <https://unpkg.com/xlsx/> | | `jsDelivr` | <https://jsdelivr.com/package/npm/xlsx> | | `CDNjs` | <http://cdnjs.com/libraries/xlsx> | | `packd` | <https://bundle.run/xlsx@latest?name=XLSX> | `unpkg` makes the latest version available at: ```html <script src="https://unpkg.com/xlsx/dist/xlsx.full.min.js"></script> ``` </details> With [npm](https://www.npmjs.org/package/xlsx): ```bash $ npm install xlsx ``` With [bower](http://bower.io/search/?q=js-xlsx): ```bash $ bower install js-xlsx ``` ### JS Ecosystem Demos The [`demos` directory](demos/) includes sample projects for: **Frameworks and APIs** - [`angularjs`](demos/angular/) - [`angular 2 / 4 / 5 / 6 and ionic`](demos/angular2/) - [`knockout`](demos/knockout/) - [`meteor`](demos/meteor/) - [`react and react-native`](demos/react/) - [`vue 2.x and weex`](demos/vue/) - [`XMLHttpRequest and fetch`](demos/xhr/) - [`nodejs server`](demos/server/) - [`databases and key/value stores`](demos/database/) - [`typed arrays and math`](demos/array/) **Bundlers and Tooling** - [`browserify`](demos/browserify/) - [`fusebox`](demos/fusebox/) - [`parcel`](demos/parcel/) - [`requirejs`](demos/requirejs/) - [`rollup`](demos/rollup/) - [`systemjs`](demos/systemjs/) - [`typescript`](demos/typescript/) - [`webpack 2.x`](demos/webpack/) **Platforms and Integrations** - [`electron application`](demos/elect