1 Star 0 Fork 84

river4dragon / Luckyexcel

forked from mengshukeji / Luckyexcel 
Create your Gitee Account
Explore and code with more than 12 million developers,Free private repositories !:)
Sign up
Clone or Download
contribute
Sync branch
Cancel
Notice: Creating folder will generate an empty file .keep, because not support in Git
Loading...
README
MIT

English| 简体中文

Introduction

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

Demo

Demo

Features

Support excel file import to Luckysheet adaptation list

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

Plan

The goal is to support all features supported by Luckysheet

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

Usage

CDN

<script src="https://cdn.jsdelivr.net/npm/luckyexcel/dist/luckyexcel.umd.js"></script>
<script>
    // Make sure to get the xlsx file first, and then use the global method window.LuckyExcel to convert
    LuckyExcel.transformExcelToLucky(
        file, 
        function(exportJson, luckysheetfile){
            // After obtaining the converted table data, use luckysheet to initialize or update the existing luckysheet workbook
            // Note: Luckysheet needs to introduce a dependency package and initialize the table container before it can be used
            luckysheet.create({
                container: 'luckysheet', // luckysheet is the container id
                data:exportJson.sheets,
                title:exportJson.info.name,
                userInfo:exportJson.info.name.creator
            });
        },
        function(err){
            logger.error('Import failed. Is your fail a valid xlsx?');
        });
</script>

Case Demo index.html shows the detailed usage

ES and Node.js

Installation

npm install luckyexcel

ES import

import LuckyExcel from 'luckyexcel'

// After getting the xlsx file
LuckyExcel.transformExcelToLucky(data, 
    function(exportJson, luckysheetfile){
        // Get the worksheet data after conversion
    },
    function(error){
        // handle error if any thrown
    }
)

Case luckysheet-vue

Node.js import

var fs = require("fs");
var LuckyExcel = require('luckyexcel');

// Read an xlsx file
fs.readFile("House cleaning checklist.xlsx", function(err, data) {
    if (err) throw err;

    LuckyExcel.transformExcelToLucky(data, function(exportJson, luckysheetfile){
        // Get the worksheet data after conversion
    });
    
});

Case Luckyexcel-node

Development

Requirements

Node.js Version >= 6

Installation

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!

Communication

  • Any questions or suggestions are welcome to submit Issues

  • Gitter

Chinese community

Authors and acknowledgment

License

MIT

Copyright (c) 2020-present, mengshukeji

The MIT License (MIT) Copyright (c) 2020-present, Mengshukeji Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

About

Luckyexcel,是一个适配 Luckysheet 的excel导入导出库,只支持.xlsx格式文件(不支持.xls) expand collapse
JavaScript
MIT
Cancel

Releases

No release

Contributors

All

Activities

Load More
can not load any more
JavaScript
1
https://gitee.com/river4dragon/Luckyexcel.git
git@gitee.com:river4dragon/Luckyexcel.git
river4dragon
Luckyexcel
Luckyexcel
master

Search