base on Luckysheet is an online spreadsheet like excel that is powerful, simple to configure, and completely open source. <div align="center">  [](https://gitter.im/mengshukeji/Luckysheet?utm_source=badge&utm_medium=badge&utm_campaign=pr-badge&utm_content=badge) <a href="https://twitter.com/intent/follow?screen_name=luckysheet"> <img src="https://img.shields.io/twitter/follow/luckysheet?style=social&logo=twitter" alt="follow on Twitter"></a> </div> English| [简体中文](./README-zh.md) # Luckysheet is no longer maintained, please use [Univer](https://github.com/dream-num/univer) instead! Follow the [#1454](https://github.com/dream-num/Luckysheet/issues/1454) issue for more details. ## 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](https://github.com/mengshukeji/Luckysheet)| [Online Documentation](https://dream-num.github.io/LuckysheetDocs/) | [Online Demo](https://dream-num.github.io/LuckysheetDemo) / [Cooperative editing demo](http://luckysheet.lashuju.com/demo/) | [Import Excel Demo](https://dream-num.github.io/LuckyexcelDemo/) | [Chinese Forum](https://support.qq.com/product/288322) | | [Gitee Mirror](https://gitee.com/mengshukeji/Luckysheet)| [Gitee Online Documentation](https://mengshukeji.gitee.io/LuckysheetDocs/) | [Gitee Online Demo](https://mengshukeji.gitee.io/luckysheetdemo/) | [Gitee Import Excel Demo](https://mengshukeji.gitee.io/luckyexceldemo/) | [Google Group](https://groups.google.com/g/luckysheet) |  ## Plugins - [Luckyexcel](https://github.com/mengshukeji/Luckyexcel): Excel import and export library - [chartMix](https://github.com/mengshukeji/chartMix): Chart plugin ## Ecosystem | Project | Description | |---------|-------------| | [Luckysheet Vue] | Luckysheet and Luckyexcel in a vue cli3 project | | [Luckysheet Vue3] | Luckysheet and Luckyexcel in a vue3 project with vite| | [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 | [Luckysheet Vue]: https://github.com/mengshukeji/luckysheet-vue [Luckysheet Vue3]: https://github.com/hjwforever/luckysheet-vue3-vite [Luckysheet React]: https://github.com/mengshukeji/luckysheet-react [Luckyexcel Node]: https://github.com/mengshukeji/Luckyexcel-node [Luckysheet Server]: https://github.com/mengshukeji/LuckysheetServer [Luckysheet Server Starter]: https://github.com/mengshukeji/LuckysheetServerStarter ## 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](https://dream-num.github.io/LuckysheetDocs/guide/#features) ## 📖 Resources - Priority reading for new users: [User Guide](https://github.com/mengshukeji/Luckysheet/wiki/User-Guide) - For the tutorials, learning materials and supporting solutions provided by the community, please refer to: [Tutorials and Resources](https://dream-num.github.io/LuckysheetDocs/guide/resource.html) ## 📜 Changelog Detailed changes for each release are documented in the [CHANGELOG.md](CHANGELOG.md). ## ❗️ Issues Please make sure to read the [Issue Reporting Checklist](https://dream-num.github.io/LuckysheetDocs/guide/contribute.html#how-to-submit-issues) before opening an issue. Issues not conforming to the guidelines may be closed immediately. ## ✅ TODO Managed with [GitHub Projects](https://github.com/mengshukeji/Luckysheet/projects/1) ## 💪Contribution Please make sure to read the[ Contributing Guide](https://dream-num.github.io/LuckysheetDocs/guide/contribute.html) 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](https://nodejs.org/en/) Version >= 6 ### Installation ``` npm install npm install gulp -g ``` ### Development ``` npm run dev ``` ### Package ``` npm run build ``` ## Partner project - [h5-Dooring](https://github.com/MrXujiang/h5-Dooring) ## Communication - [WebSite](http://lucky.lashuju.com/index.html) - [Github Discussions](https://github.com/mengshukeji/Luckysheet/discussions) - [Gitter](https://gitter.im/mengshukeji/Luckysheet) [Chinese community](./README-zh.md) ## Sponsor Luckysheet is an MIT-licensed open source project with its ongoing development made possible entirely by the support of these awesome [backers](https://dream-num.github.io/LuckysheetDocs/about/sponsor.html#sponsors-list). If you'd like to join them, please consider: - [Become a backer or sponsor on Patreon](https://www.patreon.com/mengshukeji). - [Become a backer or sponsor on Open Collective](https://opencollective.com/luckysheet). - One-time donation via PayPal, WeChat or Alipay | PayPal | WeChat | Alipay | |---|---|---| | [Paypal Me](https://www.paypal.me/wbfsa) | <img src="https://cdn.jsdelivr.net/gh/mengshukeji/LuckyResources@master/assets/img/wechat/wechat.jpg" width="140" />| <img src="https://cdn.jsdelivr.net/gh/mengshukeji/LuckyResources@master/assets/img/wechat/alipay.jpg" width="130" /> | ### 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) - *涛 ¥ 200 - popo ¥ 1 - 孔垂善 ¥ 5 - Shawn文 ¥ 99 - 幸运的小路易 ¥ 1 - 冯启俊 ¥ 88 - mxb ¥ 10 - 祭阳 ¥ 20 - *勇 ¥ 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 - **帆 ¥ 188 - henry ¥ 100 - .波罗 ¥ 50 - 花落有家 ¥ 50 - 踏遍南水北山 ¥ 1 - LC ¥ 5 - **明 ¥ 8.80 - *军 ¥ 20 - 张彪 ¥ 50 - 企业文档云@肖敏 ¥ 10 - 匿名 ¥ 50 - 逍遥行 ¥ 10 - z.wasaki ¥ 50 - Make Children ¥ 20 - Foam ¥ 20 - 奥特曼( o|o)ノ三 ¥ 50 - **凯 ¥ 10 - **兵 ¥ 20 - **川 ¥ 1 - 二万 ¥ 50 - 蔚然成林 ¥ 10 - 邹杰 ¥ 10 - 张永强 ¥ 50 - 鱼得水 ¥ 50 - Ccther ¥ 1 - Eric Cheng ¥ 10 - 佚名 ¥ 1 - 花叶 ¥ 50 - GT ¥ 20 - 菜菜心 ¥ 10 - fisher ¥ 1 - JC ¥ 5 - 佚名 ¥ 20 - 独孤一剑 ¥ 50 - mxt ¥ 20 - 一叶迷山 ¥ 100 - Jeff ¥ 100 - 八千多条狗🐶 ¥ 100 - 晓峰 ¥ 10 - 戒 ¥ 1 - 浪里个浪 ¥ 1 - 回调函数 ¥ 50 - 赖瓜子 ¥ 5 - Milo•J ¥ 20 - 可道云 ¥ 200 - *程 ¥ 10 - 来一杯卡布酸奶 ¥ 5 - 刘久胜 ¥ 100 - 快意江湖 ¥ 50 - *新 ¥ 9.9 - **龙 ¥ 100 - **江 ¥ 100 - **威 ¥ 9.8 - **涛 ¥ 500 - **嘉 ¥ 10 - *涛 ¥ 1 - *兵 ¥ 5 - *阳 ¥ 200 - *辉 ¥ 1 - *帆 ¥ 30 - **旺 ¥ 10 - **麟 ¥ 20 - *霖 ¥ 9.9 - *帅 ¥ 10 - *鑫 ¥ 6.66 - ~朴:shu ¥ 29.79 - 未来 ¥ 1 - 国勇 ¥ 0.1 - 用心灵听雨 ¥ 10 - 钊 ¥ 5 - 星稀 ¥ 5 ## Authors and acknowledgment ### Active Core Team Members - [@wbfsa](https://github.com/wbfsa) - [@eiji-th](https://github.com/eiji-th) - [@fly-95](https://github.com/fly-95) - [@tonytonychopper123](https://github.com/tonytonychopper123) - [@Dushusir](https://github.com/Dushusir) - [@iamxuchen800117](https://github.com/iamxuchen800117) - [@wpxp123456](https://github.com/wpxp123456) - [@c19c19i](https://weibo.com/u/3884623955) - [@zhangchen915](https://github.com/zhangchen915) - [@jerry-f](https://github.com/jerry-f) - [@flowerField](https://github.com/flowerField) ### Community Partners - [@yiwasheng](https://github.com/yiwasheng) - [@danielcai1987](https://github.com/danielcai1987) - [@qq6690876](https://github.com/qq6690876) - [@javahuang](https://github.com/javahuang) - [@TimerGang](https://github.com/TimerGang) - [@gsw945](https://github.com/gsw945) - [@swen-xiong](https://github.com/swen-xiong) - [@lzmch](https://github.com/lzmch) - [@kdevilpf](https://github.com/kdevilpf) - [@WJWM0316](https://github.com/WJWM0316) ## License [MIT](http://opensource.org/licenses/MIT) Copyright (c) 2020-present, mengshukeji ", Assign "at most 3 tags" to the expected json: {"id":"3837","tags":[]} "only from the tags list I provide: [{"id":77,"name":"3d"},{"id":89,"name":"agent"},{"id":17,"name":"ai"},{"id":54,"name":"algorithm"},{"id":24,"name":"api"},{"id":44,"name":"authentication"},{"id":3,"name":"aws"},{"id":27,"name":"backend"},{"id":60,"name":"benchmark"},{"id":72,"name":"best-practices"},{"id":39,"name":"bitcoin"},{"id":37,"name":"blockchain"},{"id":1,"name":"blog"},{"id":45,"name":"bundler"},{"id":58,"name":"cache"},{"id":21,"name":"chat"},{"id":49,"name":"cicd"},{"id":4,"name":"cli"},{"id":64,"name":"cloud-native"},{"id":48,"name":"cms"},{"id":61,"name":"compiler"},{"id":68,"name":"containerization"},{"id":92,"name":"crm"},{"id":34,"name":"data"},{"id":47,"name":"database"},{"id":8,"name":"declarative-gui "},{"id":9,"name":"deploy-tool"},{"id":53,"name":"desktop-app"},{"id":6,"name":"dev-exp-lib"},{"id":59,"name":"dev-tool"},{"id":13,"name":"ecommerce"},{"id":26,"name":"editor"},{"id":66,"name":"emulator"},{"id":62,"name":"filesystem"},{"id":80,"name":"finance"},{"id":15,"name":"firmware"},{"id":73,"name":"for-fun"},{"id":2,"name":"framework"},{"id":11,"name":"frontend"},{"id":22,"name":"game"},{"id":81,"name":"game-engine "},{"id":23,"name":"graphql"},{"id":84,"name":"gui"},{"id":91,"name":"http"},{"id":5,"name":"http-client"},{"id":51,"name":"iac"},{"id":30,"name":"ide"},{"id":78,"name":"iot"},{"id":40,"name":"json"},{"id":83,"name":"julian"},{"id":38,"name":"k8s"},{"id":31,"name":"language"},{"id":10,"name":"learning-resource"},{"id":33,"name":"lib"},{"id":41,"name":"linter"},{"id":28,"name":"lms"},{"id":16,"name":"logging"},{"id":76,"name":"low-code"},{"id":90,"name":"message-queue"},{"id":42,"name":"mobile-app"},{"id":18,"name":"monitoring"},{"id":36,"name":"networking"},{"id":7,"name":"node-version"},{"id":55,"name":"nosql"},{"id":57,"name":"observability"},{"id":46,"name":"orm"},{"id":52,"name":"os"},{"id":14,"name":"parser"},{"id":74,"name":"react"},{"id":82,"name":"real-time"},{"id":56,"name":"robot"},{"id":65,"name":"runtime"},{"id":32,"name":"sdk"},{"id":71,"name":"search"},{"id":63,"name":"secrets"},{"id":25,"name":"security"},{"id":85,"name":"server"},{"id":86,"name":"serverless"},{"id":70,"name":"storage"},{"id":75,"name":"system-design"},{"id":79,"name":"terminal"},{"id":29,"name":"testing"},{"id":12,"name":"ui"},{"id":50,"name":"ux"},{"id":88,"name":"video"},{"id":20,"name":"web-app"},{"id":35,"name":"web-server"},{"id":43,"name":"webassembly"},{"id":69,"name":"workflow"},{"id":87,"name":"yaml"}]" returns me the "expected json"