New Case Study:See how Anthropic automated 95% of dependency reviews with Socket.Learn More
Socket
Sign inDemoInstall
Socket

luckyexcel

Package Overview
Dependencies
Maintainers
1
Versions
2
Alerts
File Explorer

Advanced tools

Socket logo

Install Socket

Detect and block malicious and high-risk dependencies

Install

luckyexcel

An excel import and export library adapted to Luckysheet

  • 1.0.1
  • latest
  • Source
  • npm
  • Socket score

Version published
Maintainers
1
Created
Source

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
        });
    });
</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(file, function(exportJson, luckysheetfile){
    //Get the worksheet data after conversion
});

Case luckysheet-vue

Node.js import
var fs = require("fs");
var LuckyExcel = require('luckyexcel');

// Read a 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

Keywords

FAQs

Package last updated on 04 Jan 2021

Did you know?

Socket

Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.

Install

Related posts

SocketSocket SOC 2 Logo

Product

  • Package Alerts
  • Integrations
  • Docs
  • Pricing
  • FAQ
  • Roadmap
  • Changelog

Packages

npm

Stay in touch

Get open source security insights delivered straight into your inbox.


  • Terms
  • Privacy
  • Security

Made with ⚡️ by Socket Inc