Found a pure js open source spreadsheet-Luckysheet

According to the official website, this spreadsheet plugin is a pure front-end online table similar to Excel, with powerful functions, simple configuration and completely open source.

Official website link:

Here is an excerpt from the official website to list a brief function introduction:

Features

Formatting

  • Conditional formatting (highlight interesting cells or ranges of cells, emphasize unusual values, and visualize data by using data bars, color scales, and icon sets that correspond to specific variations in the data)
  • Align or rotate text
  • Support text truncation, overflow, automatic line wrapping
  • Data types
  • currency, percentages, decimals, dates
  • Custom (E.g ##,###0.00 , $1,234.56$##,###0.00_);[Red]($##,###0.00), _($* ##,###0.00_);_(...($* "-"_);_(@_), 08-05 PM 01:30MM-dd AM/PM hh:mm )

Cells

  • Fill handle (For a series like 1, 2, 3, 4, 5…, type 1 and 2 in the first two cells. For the series 2, 4, 6, 8…, type 2 and 4. Support arithmetic sequence, geometric sequence,date, week,chinese numbers)
  • Auto Fill Options (Fill copy, sequence, only format, no format, day, month, year)
  • Multiple selection (Hold Ctrl Selecting multiple cells, copy and paste)
  • Find and replace (Such as a particular number or text string, Support regular expression, whole word, case sensitive)
  • Location (Cells can be selected according to the data type)
  • Merge cells

Row & columns

  • Frozen rows and columns (First row, first column, Frozen to selection, freeze adjustment lever can be dragged)
  • Split text (Split text into different columns with the Convert Text to Columns Wizard)

Operation

  • Copy/Paste/Cut (Copy from excel to luckysheet with format, vice versa)
  • Hot key (The operating experience is consistent with excel, if there are differences or missing, please feedback to us)
  • Format Painter (Similar to google sheet)
  • Selection by drag and dropping (Change the parameters of formula and chart through selection)

Formulas & functions

  • Math (SUMIFS, AVERAGEIFS, SUMIF, SUM, etc.)
  • Text (CONCATENATE, REGEXMATCH, MID)
  • Date (DATEVALUE, DATEDIF, NOW, WEEKDAY, etc.)
  • Financial (PV, FV, IRR, NPV, etc.)
  • Logical (IF, AND, OR, IFERROR, etc.)
  • Lookup (VLOOKUP, HLOOkUP, INDIRECT, OFFSET, etc.)
  • Dynamic Array (Excel2019 new formulas, SORT,FILTER,UNIQUE,RANDARRAY,SEQUENCE)
  • Array (={1,2,3,4,5,6}, Crtl+Shift+Enter)
  • Remote formulas (DM_TEXT_TFIDF, DM_TEXT_TEXTRANK,DATA_CN_STOCK_CLOSE etc. Need remote interface, can realize complex calculation)
  • Custom (Some formula suitable for use in China have been added. AGE_BY_IDCARD, SEX_BY_IDCARD, BIRTHDAY_BY_IDCARD, PROVINCE_BY_IDCARD, CITY_BY_IDCARD, etc. You can define any formula you want)

Tables

  • Sort (Sort multiple fields simultaneously)

Pivot table

  • Aggregation (Surport Sum,Count,CountA,CountUnique,Average,Max,Min,Median,Product,Stdev,Stdevp,Var,VarP etc.)
  • Filter data (Add fileds to filters area and analyze the desired data )
  • Drill down (Double click pivot table cell to drill down for detail data )
  • Create a PivotChart (Pivot table can create a chart )

Chart

  • Chart Plugins (Link to another project ChartMix(MIT): ECharts is currently supported,Highcharts, Ali G2, amCharts, googleChart, chart.js are being developed gradually)
  • Sparklines (Support by formula : Line, Pie, Box, Pie etc.)

Share

  • Collaborate (Simultaneous editing by multiple users)

LuckySheet

  • Screenshot (Take a screenshot with selection)
  • Copy to (In the right-click menu, copy selection to json, array etc.)

Coming soon

  • Data validation (Checkbox, drop-down list, datePicker)
  • Print (Like excel print option, save to PDF)
  • Cell segmentation style (Alt+Enter line break, sub,super, in-cell style)
  • Tree menu (Just like the outline (group) function of excel)
  • Table new Features (filter, slicer)
  • EXCEL,CSV,TXT import/export (Specially adapted to luckysheet)
  • Documentation (Improve documentation and API)
  • More…

Open the online demo, the speed is also very fast, the operation is basically the same as excel.

It looks really powerful, and the author is doing it with heart and is actively maintaining it.

It is ready to be used in the project, and everyone who is interested can communicate together.

So how do we use it in our project?

Let’s follow the tutorial and run locally.

Steps for usage:

1. clone project

git clone https://github.com/mengshukeji/Luckysheet.git

2. Installation dependencies

cd Luckysheet

npm install

npm install gulp -g

3. Developer mode experience

npm run dev

A few simple steps are already running. If you want to introduce your own project, you need to package it through `npm run build`, and copy the files in the dist folder to your own project for introduction.

At present, the core functions can meet the needs of the project, but there should be many details that need to be added. The document is still being further improved, so look forward to it.

```

A few simple steps are already running. If you want to introduce your own project, you need to package it through `npm run build`, and copy the files in the dist folder to your own project for introduction.

At present, the core functions can meet the needs of the project, but there should be many details that need to be added. The document is still being further improved, so look forward to it.