English| 简体中文
Luckyexcel is an excel import and export library adapted to Luckysheet. It only supports .xlsx format files (not .xls).
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
});
});
});
}
}
}Copyright (c) 2020-present, mengshukeji