Luckysheet 3.x is currently being rewritten in Typescript

English| 简体中文

Introduction

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

Links

Source Code	Documentation	Demo	Plugins Demo	Forum
Github	Online Documentation	Online Demo / Cooperative editing demo	Import Excel Demo	Chinese Forum
Gitee Mirror	Gitee Online Documentation	Gitee Online Demo	Gitee Import Excel Demo	Google Group

Plugins

• Luckyexcel: Excel import and export library
• chartMix: Chart plugin

Ecosystem

Project	Description
Luckysheet Vue	Luckysheet and Luckyexcel in a vue cli3 project
Luckysheet React	Luckysheet in a React project
Luckyexcel Node	Use Luckyexcel in koa2
Luckysheet Server	Java backend Luckysheet Server
Luckysheet Server Starter	LuckysheetServer docker deployment startup template

Features

• Formatting: style, conditional formatting, text alignment and rotation, text truncation, overflow, automatic line wrapping, multiple data types, cell segmentation style
• Cells: drag and drop, fill handle, multiple selection, find and replace, location, merge cells, data verification
• Row & column: hide, insert, delete rows or columns, freeze, and split text
• Operation: undo, redo, copy, paste, cut, hot key, format painter, drag and drop selection
• Formulas & Functions: Built-in, remote and custom formulas
• Tables: filter, sort
• Enhanced functions: Pivot tables, charts, comments, cooperative editing, insert picture, matrix calculations, screenshots, copying to other formats, EXCEL import and export, etc.

For a more detailed feature list, please refer to: Features

📖 Resources

• Priority reading for new users: User Guide
• For the tutorials, learning materials and supporting solutions provided by the community, please refer to: Tutorials and Resources

📜 Changelog

Detailed changes for each release are documented in the CHANGELOG.md.

❗️ Issues

Please make sure to read the Issue Reporting Checklist before opening an issue. Issues not conforming to the guidelines may be closed immediately.

✅ TODO

Managed with GitHub Projects

💪Contribution

Please make sure to read the Contributing Guide before making a pull request.

Usage

First step

Introduce dependencies through CDN

<link rel='stylesheet' href='https://cdn.jsdelivr.net/npm/luckysheet@latest/dist/plugins/css/pluginsCss.css' />
<link rel='stylesheet' href='https://cdn.jsdelivr.net/npm/luckysheet@latest/dist/plugins/plugins.css' />
<link rel='stylesheet' href='https://cdn.jsdelivr.net/npm/luckysheet@latest/dist/css/luckysheet.css' />
<link rel='stylesheet' href='https://cdn.jsdelivr.net/npm/luckysheet@latest/dist/assets/iconfont/iconfont.css' />
<script src="https://cdn.jsdelivr.net/npm/luckysheet@latest/dist/plugins/js/plugin.js"></script>
<script src="https://cdn.jsdelivr.net/npm/luckysheet@latest/dist/luckysheet.umd.js"></script>

Second step

Specify a table container

<div id="luckysheet" style="margin:0px;padding:0px;position:absolute;width:100%;height:100%;left: 0px;top: 0px;"></div>

Third step

Create a table

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

Development

Requirements

Node.js Version >= 6

Installation

npm install
npm install gulp -g

Development

npm run dev

Package

npm run build

Partner project

• luban-h5
• h5-Dooring
• Furion

Communication

• Github Discussions
• Gitter

Chinese community

Sponsor

Luckysheet is an MIT-licensed open source project with its ongoing development made possible entirely by the support of these awesome backers. If you'd like to join them, please consider:

• Become a backer or sponsor on Patreon.
• Become a backer or sponsor on Open Collective.
• One-time donation via PayPal, WeChat or Alipay

PayPal	WeChat	Alipay
Paypal Me

What's the difference between Patreon and OpenCollective?

Funds donated via Patreon go directly to support mengshukeji's work on Luckysheet. Funds donated via OpenCollective are managed with transparent expenses and will be used for compensating work and expenses for core team members or sponsoring community events. Your name/logo will receive proper recognition and exposure by donating on either platform.

Sponsors List

(Sort by time)

• *勇 ¥ 30
• 虚我 ¥ 200
• 甜党 ¥ 50
• Alphabet(Google)-gcf ¥ 1
• **平 ¥ 100
• **东 ¥ 10
• debugger ¥ 20
• 烦了烦 ¥ 10
• 文顶顶 ¥ 200
• yangxshn ¥ 10
• 爱乐 ¥ 100
• 小李飞刀刀 ¥ 66
• 张铭 ¥ 200
• 曹治军 ¥ 1
• *特 ¥ 10
• **权 ¥ 9.9
• **sdmq ¥ 20
• *旭 ¥ 10
• Quentin ¥ 20
• 周宇凡 ¥ 100
• *超 ¥ 10
• 维宁 ¥ 100
• hyy ¥ 20
• 雨亭寒江月 ¥ 50
• **功 ¥ 10
• **光 ¥ 20
• terrywan ¥ 100
• 王晓洪 ¥ 10
• Sun ¥ 10
• 忧绣 ¥ 100
• Jasonx ¥ 10
• 国勇 ¥ 66.6
• 郎志 ¥ 100
• 匿名 ¥ 1
• ni ¥ 100
• 苏 ¥ 50
• Mads_chan ¥ 1
• LK ¥ 100
• 智连方舟 李汪石 ¥ 168
• **发 ¥ 260
• *超 ¥ 10
• *勇 ¥ 10
• *腾 ¥ 15
• 名字好难起 ¥ 20
• 大山 ¥ 1
• waiting ¥ 1000
• **宇 ¥ 10.00
• 刘小帅的哥哥 ¥ 20.00
• 宁静致远 ¥ 10.00
• Eleven ¥ 1.00

Authors and acknowledgment

Active Core Team Members

• @wbfsa
• @eiji-th
• @fly-95
• @tonytonychopper123
• @Dushusir
• @iamxuchen800117
• @wpxp123456
• @c19c19i
• @zhangchen915
• @jerry-f
• @flowerField

Community Partners

• @yiwasheng
• @danielcai1987
• @qq6690876
• @javahuang
• @TimerGang
• @gsw945
• @swen-xiong
• @lzmch
• @kdevilpf
• @WJWM0316

License

MIT

Copyright (c) 2020-present, mengshukeji