毕业设计管理系统.zip

# [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 by request, and dedicated support. [**Pro Version**](http://sheetjs.com/pro) [**Commercial Support**](http://sheetjs.com/support) [**Rendered Documentation**](https://sheetjs.gitbooks.io/docs/) [**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) * [Complete Examples](#complete-examples) * [Streaming Read](#streaming-read) - [Working with the Workbook](#working-with-the-workbook) * [Complete Examples](#complete-examples-1) - [Writing Workbooks](#writing-workbooks) * [Complete Examples](#complete-examples-2) * [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) * [Workbook Object](#workbook-object) + [Workbook File Properties](#workbook-file-properties) * [Workbook-Level Attributes](#workbook-level-attributes) + [Defined Names](#defined-names) + [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) - [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) - [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> ``` 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 ``` CDNjs automatically pulls the latest version and makes all versions available at <http://cdnjs.com/libraries/xlsx> ### JS Ecosystem Demos The `demos` directory includes sample projects for: - [`angular`](demos/angular/) - [`browserify`](demos/browserify/) - [`Adobe ExtendScript`](demos/extendscript/) - [`meteor`](demos/meteor/) - [`phantomjs`](demos/phantomjs/) - [`requirejs`](demos/requirejs/) - [`rollup`](demos/rollup/) - [`systemjs`](demos/systemjs/) - [`webpack`](demos/webpack/) ### Optional Modules <details> <summary><b>Optional features</b> (click to show)</summary> 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 be included directly: ```html <!-- international support from js-codepage --> <script src="dist/cpexcel.js"></script> ``` 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` Webpack and browserify builds include optional modules by default. Webpack can be configured to remove support with `resolve.alias`: ```js /* uncomment the lines below to remove support */ resolve: { alias: { "./dist/cpexcel.js": "" } // <-- omit international support } ``` </details> ### ECMAScript 5 Compatibility 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: ```html <script type="te