Luckysheet, an open source spreadsheet like Excel

Luckysheet

English| 简体中文

Introduction

Luckysheet is an online spreadsheet like excel that is powerful, simple to configure, and completely open source.

Features

1. Support table settings including freezing columns, merging cells, filtering, sorting, querying, conditional formatting, and annotations
2. Support data analysis functions including pivottables, charts, columns, matrix operations, built-in 385 calculation functions
3. Support one-click screenshots, data copying as json,shared editing, and free data copying and pasting between excel and luckysheet
4. Support mobile viewing
5. Support sparkLine
6. Drop down copy
7. Keyboard shortcuts

Plan

• Improve chart plugin
• Insert picture
• Data validation (checkbox, drop-down list)
• Print
• Cell segmentation style
• Tree menu
• Table function: filter, slice
• Excel import/export
• More...

Documentation

Online demo

Online documentation

Requirements

Node.js Version >= 6

Installation

npm install
npm install gulp -g

Development

Development

npm run dev

Package

npm run build

Read

The core code of Luckysheet is luckysheet-core.js and luckysheet-function.js, developers only need to look at these two files to see the source code, and then we will discuss the modularization scheme and improve this library.

Usage

First step

Copy all files in the dist folder after npm run build to the project directory

Second step

Introduce dependencies

<link rel='stylesheet' href='./plugins/css/pluginsCss.css' />
<link rel='stylesheet' href='./plugins/plugins.css' />
<link rel='stylesheet' href='./css/luckysheet.css' />
<script src="./plugins/js/plugin.js"></script>
<script src="./luckysheet.umd.js"></script>

Third step

Specify a table container

<div id="luckysheet"></div>

Fourth step

Create a table

<script>
    $(function () {
        //Configuration item
        var options = {
            container: 'luckysheet' //luckysheet is the container id
        }
        luckysheet.create(options)
    })
</script>

Contact

mengshu@office2.cn

communication

• Gitter

Authors and acknowledgment

• @wpxp123456
• @Dushusir

License

MIT

Copyright (c) 2020-present, mengshukeji