xlsx-tool

Introduction

Excel parsing tool

Version History

| Version Number | Update Content | Updater | | -------------- | -------------------------- | ----------- | | 1.0.0 | Excel parsing tool | CorrineCao |

Installation Guide

1. npm install xlsx-tool
2. yarn add xlsx-tool

Usage Instructions

1. Parse an Excel file

   <Upload
      customRequest={async (info: any) => {
      const { file: originFileObj } = info;
      if (info.file.name.endsWith('.xlsx')) {
         if (originFileObj) {
            XLSXTool.parseExcelFile(originFileObj, (resultList: any[]) => {
            console.log('>>>>>resultList:', resultList);
            });
         }
      }
      }}
   >
      <Button type="primary">Upload Excel File</Button>
   </Upload>

2. Generate an Excel file

    const array = [
      ['Name', 'Age', 'Gender'],
      ['Zhang San', 23, 'Female'],
      ['Li Si', 16, 'Male'],
    ];
    XLSXTool.generateExcel(array, 'Test Template');

Contribution

CorrineCao