Luckysheet


Js, web, excel, open source

Github

Online deme

BBS address

Nowadays, Web-Excel, more popular such as Tencent document, Kingsoft document, graphite document, Google Doc, and other open source Excel, these products are very good, but either not open source, or charge, then is there an open source free online Excel, for us to use? Of course, it’s LuckySheet, completely open source and free

The voice of the writer of LuckySheet

“We are determined to create LuckySheet, the most feature-rich, easy-to-configure and easy-to-use open source spreadsheet, to support enterprise reporting platforms and data analytics platforms, and to build a data analytics community. Specifically, we provide an Excel – like online editing table with cell styles, formulas, filters, freezes, and other features. We basically support the common functions of Excel, data analysis, display and editing requirements.”

LuckySheet project presentation





LuckySheet is a front-end spreadsheet library written in pure JavaScript that can be embedded into any front-end project or application to enhance the functionality of the existing system without the need for Excel or other complex software for data processing. This enables our data processing, analysis, display and storage can be done by a single system without switching platforms, without switching systems, easy integration and complete automation.

Class excel – features

  • Format is set
  • The cell
  • Row and column operations
  • Operating experience
  • Formulas and Functions
  • Form the operating
  • PivotTable
  • The chart
  • Sharing and Writing

LuckySheet Proprietary — Features

  • Matrix calculation
  • Screenshot (take a screenshot of the selected content to show)
  • Copy to other formats
  • Import and export Excel,CSV,TXT
  • Insert images and SVG shapes
  • Data validation (form functionality)
  • Multiple types in the cell


use



The environment

Node.js Version >= 6

The installation
npm install
npm install gulp -g
The development of

The development of

npm run dev

packaging

npm run build

usage

The first step

The first approach is to introduce dependencies through a CDN

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

The second method – local introduction

<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>

The 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>

The third step

Create a table

<script> $(function () {var options = {container: 'luckysheet' //luckysheet for container id} luckysheet. Create (options)}) </script>


experience

  • Github
  • Deme

The link cannot jump. Please copy the link jump

  • https://github.com/mengshukej…
  • https://mengshukeji.github.io…


Finally, the demo experience is attached