Open source Excel/ Spreadsheet library for your next Project.

Today we will discuss about some open excel spreadsheet library you can use in next project even in current projects.

We have curated such library in article below.

MiniExcel

If you are a Microsoft’s .net framework fan and want to implement excel reporting and other utility function of excel in your project then this is a very good and well maintained project on github.

MiniExcel is simple and efficient to avoid OOM’s .NET processing Excel tool.

At present, most popular frameworks need to load all the data into the memory to facilitate operation, but it will cause memory consumption problems. MiniExcel tries to use algorithm from a stream to reduce the original 1000 MB occupation to a few MB to avoid OOM(out of memory).

Below are some feature to take a look

• Low memory consumption, avoid OOM (out of memory) and full GC
• Support real-time operation of each row of data
• Support LINQ deferred execution, it can do low-consumption, fast paging and other complex queries
• Lightweight, without Microsoft Office installed, no COM+, DLL size is less than 150KB
• Easy API style to read/write/fill excel

Github link of the MiniExcel.

Luckysheet

For javascript’s framework lover there is an open source project on github you can use in you next web application is Luckysheet.

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

Features of Luckysheet’s are as below:

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

Github link of the Luckysheet.

Univer

It is an isomorphic Full-Stack Framework for creating and editing spreadsheets, docs, and slides across web and server
It is extensible, high-performance. embeddable to your application.

• It is designed to support spreadsheets, documents and presentation.
• It is isomorphic. It can run both on browsers and Node.js (in the future, mobile devices as well), with the same API.
• It is easily embeddable, allowing seamless integration into your applications.
• It is powerful, offering a wide range of features including formulas, conditional formatting, data validation, filtering, collaborative editing, printing, import & export and more features on the horizon.
• It is highly extensible, thanks to its plug-in architecture that makes it a delight for developers to implement their unique requirements on the top of Univer.
• It is highly customizable, allowing you to personalize its appearance using themes. It also provides support for internationalization (i18n).
• It is easy to work with. The Presets & Facade API make it easy to hands on.
• It in performant.
  • It boasts an efficient rendering engine based on canvas, capable of rendering various document types flawlessly. The rendering engines supports advanced typesetting features such as punctuation squeezing, text and image layout and scroll buffering.
  • It incorporates a lightning-fast formula engine that can operate in Web Workers or even on the server side.
• It is a highly integrated system. Documents, spreadsheets and slides can interoperate with each others and even rendered on the same canvas, allowing information and data flow within Univer.

Github link of Univer.