oy-paddy / luckysheet_import_export Goto Github PK

English| 简体中文

Luckyexcel is an excel import and export library adapted to Luckysheet. It only supports .xlsx format files (not .xls).

Demo

Support excel file import to Luckysheet adaptation list

• Cell style
• Cell border
• Cell format, such as number format, date, percentage, etc.
• Formula

The goal is to support all features supported by Luckysheet

• Conditional Formatting
• Pivot table
• Chart
• Sort
• Filter
• Annotation
• Excel export

Node.js Version >= 6

npm install -g gulp-cli
npm install

Development

npm run dev

Package

npm run build

A third-party plug-in is used in the project: JSZip, thanks!

After gulp build, copy bundle.js in the dist folder to the project directory, and bundle.js is the core code of the project

Import bundle.js, specify a file upload component on the interface, write a monitoring method similar to the following, call LuckyExcel.transformExcelToLucky, and then get the converted JSON data in the callback. This JSON data is in a format that Luckysheet can recognize. Use Luckysheet to initialize.

function demoHandler(){
    let upload = document.getElementById("Luckyexcel-demo-file");
    if(upload){
        
        window.onload = () => {
            
            upload.addEventListener("change", function(evt){
                var files:FileList = (evt.target as any).files;
                LuckyExcel.transformExcelToLucky(files[0], function(exportJson:any){

                    window.luckysheet.destroy();
                    
                    window.luckysheet.create({
                        container:'luckysheet', //luckysheet is the container id
                        data:exportJson.sheets,
                        title:exportJson.info.name,
                        userInfo:exportJson.info.name.creator
                    });
                });
            });
        }
    }
}

• Any questions or suggestions are welcome to submit Issues

• Gitter

Chinese community

• @wbfsa
• @wpxp123456
• @Dushusir

MIT

Copyright (c) 2020-present, mengshukeji