# [SheetJS](https://sheetjs.com)
The SheetJS Community Edition offers battle-tested open-source solutions for
extracting useful data from almost any complex spreadsheet and generating new
spreadsheets that will work with legacy and modern software alike.
[SheetJS Pro](https://sheetjs.com/pro) offers solutions beyond data processing:
Edit complex templates with ease; let out your inner Picasso with styling; make
custom sheets with images/graphs/PivotTables; evaluate formula expressions and
port calculations to web apps; automate common spreadsheet tasks, and much more!
![License](https://img.shields.io/github/license/SheetJS/sheetjs)
[![Build Status](https://img.shields.io/github/workflow/status/sheetjs/sheetjs/Tests:%20node.js)](https://github.com/SheetJS/sheetjs/actions)
[![Snyk Vulnerabilities](https://img.shields.io/snyk/vulnerabilities/github/SheetJS/sheetjs)](https://snyk.io/test/github/SheetJS/sheetjs)
[![npm Downloads](https://img.shields.io/npm/dm/xlsx.svg)](https://npmjs.org/package/xlsx)
[![Analytics](https://ga-beacon.appspot.com/UA-36810333-1/SheetJS/sheetjs?pixel)](https://github.com/SheetJS/sheetjs)
[**Browser Test and Support Matrix**](https://oss.sheetjs.com/sheetjs/tests/)
[![Build Status](https://saucelabs.com/browser-matrix/sheetjs.svg)](https://saucelabs.com/u/sheetjs)
**Supported File Formats**
![circo graph of format support](formats.png)
![graph legend](legend.png)
## Table of Contents
<details>
<summary><b>Expand to show Table of Contents</b></summary>
<!-- toc -->
- [Getting Started](#getting-started)
* [Installation](#installation)
* [Usage](#usage)
* [The Zen of SheetJS](#the-zen-of-sheetjs)
* [JS Ecosystem Demos](#js-ecosystem-demos)
- [Acquiring and Extracting Data](#acquiring-and-extracting-data)
* [Parsing Workbooks](#parsing-workbooks)
* [Processing JSON and JS Data](#processing-json-and-js-data)
* [Processing HTML Tables](#processing-html-tables)
- [Processing Data](#processing-data)
* [Modifying Workbook Structure](#modifying-workbook-structure)
* [Modifying Cell Values](#modifying-cell-values)
* [Modifying Other Worksheet / Workbook / Cell Properties](#modifying-other-worksheet--workbook--cell-properties)
- [Packaging and Releasing Data](#packaging-and-releasing-data)
* [Writing Workbooks](#writing-workbooks)
* [Writing Examples](#writing-examples)
* [Streaming Write](#streaming-write)
* [Generating JSON and JS Data](#generating-json-and-js-data)
* [Generating HTML Tables](#generating-html-tables)
* [Generating Single-Worksheet Snapshots](#generating-single-worksheet-snapshots)
- [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)
+ [Row and Column Properties](#row-and-column-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)
- [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>
## Getting Started
### Installation
**Standalone Browser Scripts**
The complete browser standalone build is saved to `dist/xlsx.full.min.js` and
can be directly added to a page with 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` | <https://cdnjs.com/libraries/xlsx> |
For example, `unpkg` makes the latest version available at:
```html
<script src="https://unpkg.com/xlsx/dist/xlsx.full.min.js"></script>
```
</details>
<details>
<summary><b>Browser builds</b> (click to show)</summary>
The complete single-file version is generated at `dist/xlsx.full.min.js`
`dist/xlsx.core.min.js` omits codepage library (no support for XLS encodings)
A slimmer build is generated at `dist/xlsx.mini.min.js`. Compared to full build:
- codepage library skipped (no support for XLS encodings)
- no support for XLSB / XLS / Lotus 1-2-3 / SpreadsheetML 2003 / Numbers
- node stream utils removed
</details>
With [bower](https://bower.io/search/?q=js-xlsx):
```bash
$ bower install js-xlsx
```
**ECMAScript Modules**
The ECMAScript Module build is saved to `xlsx.mjs` and can be directly added to
a page with a `script` tag using `type=module`:
```html
<script type="module">
import { read, writeFileXLSX } from "./xlsx.mjs";
/* load the codepage support library for extended support with older formats */
import { set_cptable } from "./xlsx.mjs";
import * as cptable from './dist/cpexcel.full.mjs';
set_cptable(cptable);
</script>
```
The [npm package](https://www.npmjs.org/package/xlsx) also exposes the module
with the `module` parameter, supported in Angular and other projects:
```ts
import { read, writeFileXLSX } from "xlsx";
/* load the codepage support library for extended support with older formats */
import { set_cptable } from "xlsx";
import * as cptable from 'xlsx/dist/cpexcel.full.mjs';
set_cptable(cptable);
```
**Deno**
`xlsx.mjs` can be imported in Deno. It is available from `unpkg`:
```ts
// @deno-types="https://unpkg.com/xlsx/types/index.d.ts"
import * as XLSX from 'https://unpkg.com/xlsx/xlsx.mjs';
/* load the codepage support library for extended support with older formats */
import * as cptable from 'https://unpkg.com/xlsx/dist/cpexcel.full.mjs';
XLSX.set_cptable(cptable);
```
**NodeJS**
With [npm](https://www.npmjs.org/package/xlsx):
```bash
$ npm install xlsx
```
By default, the module supports `require`:
```js
var XLSX = require("xlsx");
```
The module also ships with `xlsx.mjs` for use with `import`:
```js
import * as XLSX from 'xlsx/xlsx.mjs';
/* load 'fs' for readFile and writeFile support */
import * as fs from 'fs';
XLSX.set_fs(fs);
/* load 'stream' for stream support */
import { Readable } from 'stream';
XLSX.stream.set_readable(Readable);
/* load the codepage support library for extended support with older formats */
import * as cpexcel from 'xlsx/dist
没有合适的资源?快使用搜索试试~ 我知道了~
1.3.3前端包用于版本升级,没有私服
共2003个文件
md:1313个
js:532个
css:73个
需积分: 5 0 下载量 168 浏览量
2024-01-10
11:13:23
上传
评论
收藏 265.35MB ZIP 举报
温馨提示
1.3.3前端包用于版本升级,没有私服
资源推荐
资源详情
资源评论
收起资源包目录
1.3.3前端包用于版本升级,没有私服 (2003个子文件)
diagram-js.css 16KB
prism-one-dark.css 12KB
prism-one-light.css 12KB
prism-one-dark.min.css 8KB
prism-one-light.min.css 8KB
prism-coldark-cold.css 7KB
prism-coldark-dark.css 7KB
prism-coldark-cold.min.css 5KB
prism-coldark-dark.min.css 5KB
prism-vsc-dark-plus.css 4KB
prism-pojoaque.css 4KB
prism-duotone-sea.css 3KB
prism-duotone-forest.css 3KB
prism-duotone-earth.css 3KB
prism-duotone-dark.css 3KB
prism-duotone-space.css 3KB
prism-duotone-light.css 3KB
prism-vsc-dark-plus.min.css 3KB
prism-base16-ateliersulphurpool.light.css 3KB
prism-shades-of-purple.css 3KB
prism-vs.css 3KB
prism-pojoaque.min.css 3KB
prism-xonokai.css 3KB
prism-darcula.css 3KB
prism-cb.css 3KB
prism-night-owl.css 3KB
prism-shades-of-purple.min.css 3KB
prism-material-oceanic.css 2KB
prism-material-light.css 2KB
prism-gruvbox-light.css 2KB
prism-z-touch.css 2KB
prism-material-dark.css 2KB
prism-synthwave84.css 2KB
prism-a11y-dark.css 2KB
prism-duotone-forest.min.css 2KB
prism-duotone-earth.min.css 2KB
prism-duotone-sea.min.css 2KB
prism-duotone-space.min.css 2KB
prism-duotone-dark.min.css 2KB
prism-gruvbox-dark.css 2KB
prism-duotone-light.min.css 2KB
prism-base16-ateliersulphurpool.light.min.css 2KB
prism-vs.min.css 2KB
prism-coy-without-shadows.css 2KB
prism-ghcolors.css 2KB
prism-darcula.min.css 2KB
prism-material-oceanic.min.css 2KB
prism-material-light.min.css 2KB
prism-xonokai.min.css 2KB
prism-material-dark.min.css 2KB
prism-holi-theme.css 2KB
prism-solarized-dark-atom.css 2KB
prism-atom-dark.css 2KB
prism-z-touch.min.css 2KB
prism-synthwave84.min.css 2KB
prism-hopscotch.css 2KB
prism-night-owl.min.css 2KB
prism-coy-without-shadows.min.css 2KB
prism-a11y-dark.min.css 2KB
prism-lucario.css 2KB
prism-nord.css 2KB
prism-dracula.css 2KB
prism-ghcolors.min.css 2KB
prism-cb.min.css 2KB
prism-gruvbox-dark.min.css 2KB
prism-gruvbox-light.min.css 2KB
prism-holi-theme.min.css 2KB
prism-solarized-dark-atom.min.css 1KB
prism-atom-dark.min.css 1KB
prism-hopscotch.min.css 1KB
prism-lucario.min.css 1KB
prism-dracula.min.css 1KB
prism-nord.min.css 1KB
.DS_Store 6KB
.DS_Store 6KB
.DS_Store 6KB
vue.global.js 628KB
vue.esm-browser.js 598KB
mqtt.js 551KB
vue.runtime.global.js 425KB
vue.runtime.esm-browser.js 400KB
source-map.debug.js 254KB
mqtt.min.js 230KB
vue.esm-browser.prod.js 129KB
vue.global.prod.js 126KB
source-map.js 100KB
vue.runtime.esm-browser.prod.js 83KB
vue.runtime.global.prod.js 82KB
container.js 78KB
typescript.js 60KB
node.js 56KB
client.js 53KB
parser.js 52KB
typescript.js 46KB
readWordTree.js 43KB
statement.js 42KB
index.js 42KB
flow.js 38KB
source-map-consumer.js 37KB
lazy-result.js 35KB
共 2003 条
- 1
- 2
- 3
- 4
- 5
- 6
- 21
资源评论
weixin_39328849
- 粉丝: 3
- 资源: 22
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功