excel-json-sheet

v1.0.7

# excel-json-sheet excel-json-sheet组件基于sheet.js, 在其基础功能上做了二次封装, 目前支持功能如下： - excel解析成json数据或二维数组 - excel文件解析过程的规则校验, 如限制行,列数, 限制模版头部, 校验规则可扩展 - excel解析支持异步配置 - json数组数据, 转excel文件下载 - For more information about how to use this package see README

Latest version published 3 years ago

License: ISC

NPM

GitHub

Package Health Score

36 / 100

security
Security review needed
popularity
Limited
maintenance
Inactive
community
Limited

Explore Similar Packages

Security

Security review needed

All security vulnerabilities belong to production dependencies of direct and indirect packages.

Security and license risk for significant versions

All Versions

Version				Vulnerabilities	License Risk
1.0.7	\|	03/2021	Popular	0 C 0 H 0 M 0 L	0 H 0 M 0 L

License

ISC

Security Policy

Is your project affected by vulnerabilities?

Scan your projects for vulnerabilities. Fix quickly with automated fixes. Get started with Snyk for free.

Get started free

Popularity

Limited

Weekly Downloads (1)

GitHub Stars: 4
Forks: 0
Contributors: 1

Direct Usage Popularity

The npm package excel-json-sheet receives a total of 1 downloads a week. As such, we scored excel-json-sheet popularity level to be Limited.

Based on project statistics from the GitHub repository for the npm package excel-json-sheet, we found that it has been starred 4 times.

Downloads are calculated as moving averages for a period of the last 12 months, excluding weekends and known missing data points.

Community

Limited

Readme.md: Yes
Contributing.md: No
Code of Conduct: No
Contributors: 1
Funding: No

This project has seen only 10 or less contributors.

We found a way for you to contribute to the project! Looks like excel-json-sheet is missing a Code of Conduct.

Embed Package Health Score Badge

Maintenance

Inactive

Commit Frequency

No Recent Commits

Open Issues: 0
Open PR: 0
Last Release: 3 years ago
Last Commit: 3 years ago

Further analysis of the maintenance status of excel-json-sheet based on released npm versions cadence, the repository activity, and other data points determined that its maintenance is Inactive.

An important project maintenance signal to consider for excel-json-sheet is that it hasn't seen any new versions released to npm in the past 12 months, and could be considered as a discontinued project, or that which receives low attention from its maintainers.

In the past month we didn't find any pull request activity or change in issues status has been detected for the GitHub repository.

Keep your project healthy

Check your package.json

Ensure all the packages you're using are healthy and well-maintained

Snyk Vulnerability Scanner

Get health score & security insights directly in your IDE

Package

Node.js Compatibility: not defined

Age: 4 years
Dependencies: 1 Direct
Versions: 7
Install Size: 16.6 kB
Dist-tags: 1
# of Files: 5
Maintainers: 1
TS Typings: No

excel-json-sheet has more than a single and default latest tag published for the npm package. This means, there may be other tags available for this package, such as next to indicate future releases, or stable to indicate stable releases.

Readme

excel-json-sheet

excel-json-sheet组件基于sheet.js, 在其基础功能上做了二次封装, 目前支持功能如下：

excel解析成json数据或二维数组
excel文件解析过程的规则校验, 如限制行,列数, 限制模版头部, 校验规则可扩展
excel解析支持异步配置
json数组数据, 转excel文件下载

使用示例

Excel类实例

构造函数参数说明 options = { callback, rules, sheetToJsonOpt, parseOpt } 解析及生成excel，可以通过直接导入Excel类方式的实现

参数	类型	说明	是否必传	默认值
callback	function	解析结果回调函数, 第一个参数为error(失败时有值), 第二参数为解析的数据(error不存在时有值)	是	无
rules	object	解析校验规则,支持的校验 maxRows:number, maxCols:number, headerEqualkeys:Array	否	{}
sheetToJsonOpt	object	建议只对header属性配置, https://github.com/SheetJS/sheetjs#sheet_to_json
parseOpt	object	建议不做配置, https://github.com/SheetJS/sheetjs#parsing-options	否	{ sheetRows: 0, type: 'binary', raw: true, onlyOneSheet: true }
ruleInstance	Excel.ExcelRules实例对象	可继承Excel.ExcelRules，自定义改写校验规则	否	只实例默认规则

sheetToJson方法

参数	类型	说明
file	上传的excel单个文件	上传的excel单个文件

使用示例

    import Excel from 'excel-json-sheet'
    let config = {
        callback:(error,  list)=&gt;{
            if(error){
              return alert(error)
            }
            let  res = list[0]
            let { fileName, data, sheetName,  sheetHeader} = res
            fileName // 上传的excel文件名
            data // json数组对象  excel第二行及以后数据
            sheetName //表格名
            sheetHeader // excel第一行数据
        }
    }
    let excel = new Excel(config)
    excel.sheetToJson(file)

jsonToSheet方法

参数	类型	说明
jsonData	{sheetName:string, config:object, list:array}[]	sheetName:表格名, config.reflectHeader：决定表格第一行填充数据, list: 需要生成的json数组
fileName	string	生成下载excel带后缀格式的文件名

使用示例

    import Excel from 'excel-json-sheet'
    let jsonData = [{
        sheetName:'妖怪名单', 
        config:{
            reflectHeader:{name:'名字',age:'年纪' }, 
        }, 
        list:[
            {name:'犬夜叉',  age:'100000' }, 
            {name:'杀生丸',  age:'100001' }, 
        ]
    }]
    let config = {
        callback:(error)=&gt;{
            if(error){
                return alert(error)
            }
            console.log('json转excel文件下载成功')
        }
    } 
    let excel = new Excel(config) 
    excel.jsonToSheet(jsonData,  'abc.xlsx' ) // 直接下载

excel-json-sheet dependencies

xlsx

FAQs

What is excel-json-sheet?

# excel-json-sheet excel-json-sheet组件基于sheet.js, 在其基础功能上做了二次封装, 目前支持功能如下： - excel解析成json数据或二维数组 - excel文件解析过程的规则校验, 如限... Visit Snyk Advisor to see a full health score report for excel-json-sheet, including popularity, security, maintenance & community analysis.

Is excel-json-sheet popular?

The npm package excel-json-sheet receives a total of 1 weekly downloads. As such, excel-json-sheet popularity was classified as limited. Visit the popularity section on Snyk Advisor to see the full health analysis.

Is excel-json-sheet well maintained?

We found indications that excel-json-sheet is an Inactive project. See the full package health analysis to learn more about the package maintenance status.

Is excel-json-sheet safe to use?

While scanning the latest version of excel-json-sheet, we found that a security review is needed. A total of 0 vulnerabilities or license issues were detected. See the full security scan results.

Last updated on 21 April-2024, at 09:34 (UTC).

Build a secure application checklist

Select a recommended open source package

Minimize your risk by selecting secure & well maintained open source packages

DONE

Scan your app for vulnerabilities

Scan your application to find vulnerabilities in your: source code, open source dependencies, containers and configuration files

SCAN NOW

Fix identified vulnerabilities

Easily fix your code by leveraging automatically generated PRs

AUTO FIX

Monitor for new issues

New vulnerabilities are discovered every day. Get notified if your application is affected

MONITOR APP

Package Health Score

Explore Similar Packages

Security and license risk for significant versions

Is your project affected by vulnerabilities?

Weekly Downloads (1)

Direct Usage Popularity

Embed Package Health Score Badge

Commit Frequency

Keep your project healthy

Check your package.json

Snyk Vulnerability Scanner

Readme

excel-json-sheet

使用示例

Excel类实例

构造函数参数说明 options = { callback, rules, sheetToJsonOpt, parseOpt } 解析及生成excel，可以通过直接导入Excel类方式的实现

sheetToJson方法

使用示例

jsonToSheet方法

使用示例

excel-json-sheet dependencies

FAQs

What is excel-json-sheet?

Is excel-json-sheet popular?

Is excel-json-sheet well maintained?

Is excel-json-sheet safe to use?

Build a secure application checklist

Select a recommended open source package

Scan your app for vulnerabilities

Source Code

Open Source

Container

Config

Fix identified vulnerabilities

Monitor for new issues