下载资源前端资源详情
excel_json_transform.zip
大小:2.4MB
价格:21积分
下载量:0
评分:
5.0
上传者:zjy79866
更新日期:2024-08-03

excel、json互转

资源文件列表(大概)

文件名
大小
excel_json_transform/data/
-
excel_json_transform/data/data1.xlsx
8.74KB
excel_json_transform/data/data2.js
124B
excel_json_transform/excelToJson.js
858B
excel_json_transform/jsonToExcel.js
160B
excel_json_transform/node_modules/
-
excel_json_transform/node_modules/.bin/
-
excel_json_transform/node_modules/.bin/node-xlsx
746B
excel_json_transform/node_modules/.bin/node-xlsx.CMD
640B
excel_json_transform/node_modules/.bin/node-xlsx.ps1
1.5KB
excel_json_transform/node_modules/.bin/xlsx
710B
excel_json_transform/node_modules/.bin/xlsx.CMD
604B
excel_json_transform/node_modules/.bin/xlsx.ps1
1.44KB
excel_json_transform/node_modules/.package_versions.json
427B
excel_json_transform/node_modules/fs/
-
excel_json_transform/node_modules/fs/package.json
603B
excel_json_transform/node_modules/fs/README.md
328B
excel_json_transform/node_modules/node-xlsx/
-
excel_json_transform/node_modules/node-xlsx/dist/
-
excel_json_transform/node_modules/node-xlsx/dist/bin/
-
excel_json_transform/node_modules/node-xlsx/dist/bin/cli.cjs
3.44KB
excel_json_transform/node_modules/node-xlsx/dist/bin/cli.cjs.map
6.23KB
excel_json_transform/node_modules/node-xlsx/dist/bin/cli.d.cts
21B
excel_json_transform/node_modules/node-xlsx/dist/bin/cli.d.ts
21B
excel_json_transform/node_modules/node-xlsx/dist/bin/cli.js
941B
excel_json_transform/node_modules/node-xlsx/dist/bin/cli.js.map
1.72KB
excel_json_transform/node_modules/node-xlsx/dist/chunk-ID6OMQGT.js
2.5KB
excel_json_transform/node_modules/node-xlsx/dist/chunk-ID6OMQGT.js.map
5.56KB
excel_json_transform/node_modules/node-xlsx/dist/index.cjs
4.25KB
excel_json_transform/node_modules/node-xlsx/dist/index.cjs.map
5.61KB
excel_json_transform/node_modules/node-xlsx/dist/index.d.cts
1.6KB
excel_json_transform/node_modules/node-xlsx/dist/index.d.ts
1.6KB
excel_json_transform/node_modules/node-xlsx/dist/index.js
193B
excel_json_transform/node_modules/node-xlsx/dist/index.js.map
71B
excel_json_transform/node_modules/node-xlsx/LICENSE.md
805B
excel_json_transform/node_modules/node-xlsx/node_modules/
-
excel_json_transform/node_modules/node-xlsx/node_modules/.bin/
-
excel_json_transform/node_modules/node-xlsx/node_modules/.bin/xlsx
720B
excel_json_transform/node_modules/node-xlsx/node_modules/.bin/xlsx.CMD
614B
excel_json_transform/node_modules/node-xlsx/node_modules/.bin/xlsx.ps1
1.46KB
excel_json_transform/node_modules/node-xlsx/package.json
1.73KB
excel_json_transform/node_modules/node-xlsx/README.md
5.95KB
excel_json_transform/node_modules/user-home/
-
excel_json_transform/node_modules/user-home/index.js
56B
excel_json_transform/node_modules/user-home/license
1.09KB
excel_json_transform/node_modules/user-home/node_modules/
-
excel_json_transform/node_modules/user-home/package.json
887B
excel_json_transform/node_modules/user-home/readme.md
724B
excel_json_transform/node_modules/xlsx/
-
excel_json_transform/node_modules/xlsx/bin/
-
excel_json_transform/node_modules/xlsx/bin/xlsx.njs
10.75KB
excel_json_transform/node_modules/xlsx/bower.json
296B
excel_json_transform/node_modules/xlsx/CHANGELOG.md
6.26KB
excel_json_transform/node_modules/xlsx/dist/
-
excel_json_transform/node_modules/xlsx/dist/cpexcel.full.mjs
461.81KB
excel_json_transform/node_modules/xlsx/dist/cpexcel.js
460.7KB
excel_json_transform/node_modules/xlsx/dist/LICENSE
11.09KB
excel_json_transform/node_modules/xlsx/dist/shim.min.js
5.52KB
excel_json_transform/node_modules/xlsx/dist/xlsx.core.min.js
426.79KB
excel_json_transform/node_modules/xlsx/dist/xlsx.core.min.map
663.51KB
excel_json_transform/node_modules/xlsx/dist/xlsx.extendscript.js
823.24KB
excel_json_transform/node_modules/xlsx/dist/xlsx.full.min.js
861.06KB
excel_json_transform/node_modules/xlsx/dist/xlsx.full.min.map
776.05KB
excel_json_transform/node_modules/xlsx/dist/xlsx.mini.min.js
244.95KB
excel_json_transform/node_modules/xlsx/dist/xlsx.mini.min.map
346.93KB
excel_json_transform/node_modules/xlsx/dist/xlsx.zahl.js
51.59KB
excel_json_transform/node_modules/xlsx/dist/xlsx.zahl.mjs
51.39KB
excel_json_transform/node_modules/xlsx/formats.png
203.73KB
excel_json_transform/node_modules/xlsx/legend.png
32.82KB
excel_json_transform/node_modules/xlsx/LICENSE
11.09KB
excel_json_transform/node_modules/xlsx/node_modules/
-
excel_json_transform/node_modules/xlsx/node_modules/.bin/
-
excel_json_transform/node_modules/xlsx/node_modules/.bin/crc32
730B
excel_json_transform/node_modules/xlsx/node_modules/.bin/crc32.CMD
624B
excel_json_transform/node_modules/xlsx/node_modules/.bin/crc32.ps1
1.47KB
excel_json_transform/node_modules/xlsx/package.json
2.15KB
excel_json_transform/node_modules/xlsx/README.md
157.71KB
excel_json_transform/node_modules/xlsx/types/
-
excel_json_transform/node_modules/xlsx/types/index.d.ts
22.44KB
excel_json_transform/node_modules/xlsx/types/tsconfig.json
380B
excel_json_transform/node_modules/xlsx/xlsx.js
815.8KB
excel_json_transform/node_modules/xlsx/xlsx.mjs
875.11KB
excel_json_transform/node_modules/xlsx/xlsxworker.js
432B
excel_json_transform/out/
-
excel_json_transform/out/data.xls
64.5KB
excel_json_transform/out/output.json
83B
excel_json_transform/out/output.xls
64.5KB
excel_json_transform/package.json
350B
excel_json_transform/README.md
824B
excel_json_transform/utils/
-
excel_json_transform/utils/exportByExcel.js
1009B

资源内容介绍

excel、json互转
# [SheetJS](https://sheetjs.com)The SheetJS Community Edition offers battle-tested open-source solutions forextracting useful data from almost any complex spreadsheet and generating newspreadsheets 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; makecustom sheets with images/graphs/PivotTables; evaluate formula expressions andport 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` andcan 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 toa page with a `script` tag using `type=module`:```html<script type="module">import { read, writeFileXLSX } from "./xlsx.mjs";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 modulewith the `module` parameter, supported in Angular and other projects:```tsimport { read, writeFileXLSX } from "xlsx";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';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`:```jsvar XLSX = require("xlsx");```The module also ships with `xlsx.mjs` for use with `import`:```jsimport * as XLSX from 'xlsx/xlsx.mjs';import * as fs from 'fs';XLSX.set_fs(fs);import { Readable } from 'stream';XLSX.stream.set_readable(Readable);import * as cpexcel from 'xlsx/dist

用户评论 (0)

发表评论

captcha