# [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
没有合适的资源?快使用搜索试试~ 我知道了~
Java财会信息管理系统的分析.zip
共2000个文件
md:1233个
js:683个
json:67个
1.该资源内容由用户上传,如若侵权请联系客服进行举报
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
版权申诉
0 下载量 38 浏览量
2024-11-04
13:36:09
上传
评论
收藏 87.66MB ZIP 举报
温馨提示
财会信息管理系统是为了满足企业或组织对财务科目信息、账目管理、预算科目等财务数据的系统化、结构化管理需求而开发的。系统旨在解决财务管理过程中多项复杂、重复性任务,使财务数据管理更加高效、准确,并提供数据查询和维护的便捷操作。 系统功能模块: 首页概览:提供系统主要功能的快速入口,使用户能够高效导航,快速进入所需的模块。 信息管理: 普通员工:帮助一般用户了解系统的功能,查看财务信息数据。 记账员:负责日常账目记录、数据录入等工作,可以新增、修改、删除财务记录。 会计:对账目数据进行审核,确保信息的准确性。 预算科:管理预算相关的科目,提供预算的分配和管理功能。 财务经理:拥有更多权限,可以总览财务数据,审核各项财务记录和报表项目。 账目类别管理:提供对账目类别的管理,用户可以根据具体的财务科目进行分类查询和管理,便于数据的层次化展示与检索。 操作功能: 新增:可以添加新的财务科目及相关信息。 详情:可以查看每一项财务记录的详细信息,便于信息核对。 修改:允许用户对已有数据进行编辑,保持数据的及时更新。 删除:可以删除不需要的记录,保持系统整洁。
资源推荐
资源详情
资源评论
收起资源包目录
Java财会信息管理系统的分析.zip (2000个子文件)
mocha.min.css 3KB
output-10GKvgL2.css 564B
style.css 564B
output-10GKvgL2.css 564B
1716601850421.doc 9KB
1716601850421.doc 9KB
test.html 10KB
Multi.html 2KB
Loca.html 2KB
AMapUI.html 2KB
example.html 1KB
example-es6.html 838B
test-microtask.html 308B
test-polyfill.html 301B
test.html 295B
vue.global.js 628KB
vue.esm-browser.js 598KB
vue.runtime.global.js 425KB
index.js 423KB
index.es.js 404KB
vue.runtime.esm-browser.js 400KB
source-map.debug.js 254KB
index.min.js 239KB
index.es.min.js 237KB
vue.esm-browser.prod.js 129KB
vue.global.prod.js 126KB
source-map.js 100KB
index.js 84KB
vue.runtime.esm-browser.prod.js 83KB
vue.runtime.global.prod.js 82KB
container.js 78KB
index.js 67KB
index-cjs.js 67KB
node.js 56KB
mocha.min.js 55KB
parser.js 52KB
source-map-consumer.js 37KB
SeriesData.js 36KB
lazy-result.js 35KB
stringifier.js 35KB
chai.min.js 34KB
DataStore.js 33KB
tokenize.js 31KB
map-generator.js 31KB
MapDraw.js 27KB
index.js 27KB
source-map.min.js 26KB
BrushController.js 25KB
css-syntax-error.js 24KB
index.js 23KB
processor.js 22KB
AxisBuilder.js 21KB
universalTransition.js 21KB
DirectoryWatcher.js 20KB
LegendView.js 20KB
Time.js 19KB
postcss.js 19KB
customGraphicTransition.js 18KB
previous-map.js 18KB
input.js 17KB
conversions.js 17KB
ScrollableLegendView.js 17KB
index.js 16KB
unidecode.js 16KB
transform.js 16KB
sourceManager.js 15KB
unicode.js 15KB
result.js 15KB
source-map-generator.js 14KB
BrushTargetManager.js 14KB
source-node.js 13KB
sourceHelper.js 13KB
parse.js 13KB
dataProvider.js 13KB
createDimensions.js 13KB
at-rule.js 13KB
AngleAxisView.js 12KB
compatStyle.js 12KB
root.js 11KB
index.js 11KB
Graph.js 11KB
Source.js 11KB
rule.js 11KB
Tree.js 10KB
util.js 10KB
watchpack.js 10KB
declaration.js 10KB
LegendModel.js 10KB
warning.js 9KB
Interval.js 9KB
DataDiffer.js 9KB
RoamController.js 9KB
Util.js 9KB
index.js 9KB
dataValueHelper.js 9KB
backwardCompat.js 9KB
SeriesDataSchema.js 9KB
CartesianAxisView.js 9KB
basicTransition.js 8KB
watchEventSource.js 8KB
共 2000 条
- 1
- 2
- 3
- 4
- 5
- 6
- 20
资源评论
计算机学长阿伟
- 粉丝: 3197
- 资源: 849
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功