Introducing JavaScript Spreadsheet in Essential JS 2 | Syncfusion Blogs
Live Chat Icon For mobile
Live Chat Icon
Popular Categories.NET  (179).NET Core  (28).NET MAUI  (215)Angular  (112)ASP.NET  (51)ASP.NET Core  (83)ASP.NET MVC  (90)Azure  (41)Black Friday Deal  (1)Blazor  (228)BoldSign  (15)DocIO  (24)Essential JS 2  (109)Essential Studio  (200)File Formats  (69)Flutter  (133)JavaScript  (226)Microsoft  (120)PDF  (82)Python  (1)React  (105)Streamlit  (1)Succinctly series  (131)Syncfusion  (948)TypeScript  (33)Uno Platform  (3)UWP  (3)Vue  (45)Webinar  (52)Windows Forms  (61)WinUI  (71)WPF  (163)Xamarin  (160)XlsIO  (38)Other CategoriesBarcode  (5)BI  (29)Bold BI  (8)Bold Reports  (2)Build conference  (9)Business intelligence  (55)Button  (4)C#  (158)Chart  (141)Chart of the week  (55)Cloud  (15)Company  (443)Dashboard  (8)Data Science  (3)Data Validation  (8)DataGrid  (70)Development  (662)Doc  (8)DockingManager  (1)eBook  (99)Enterprise  (22)Entity Framework  (7)Essential Tools  (14)Excel  (43)Extensions  (23)File Manager  (7)Gantt  (19)Gauge  (12)Git  (5)Grid  (31)HTML  (13)Installer  (2)Knockout  (2)Language  (1)LINQPad  (1)Linux  (2)M-Commerce  (1)Metro Studio  (11)Mobile  (513)Mobile MVC  (9)OLAP server  (1)Open source  (1)Orubase  (12)Partners  (21)PDF viewer  (43)Performance  (13)PHP  (2)PivotGrid  (5)Predictive Analytics  (6)Report Server  (3)Reporting  (10)Reporting / Back Office  (11)Rich Text Editor  (12)Road Map  (12)Scheduler  (54)Security  (4)SfDataGrid  (9)Silverlight  (21)Sneak Peek  (31)Solution Services  (4)Spreadsheet  (11)SQL  (14)Stock Chart  (1)Surface  (4)Tablets  (5)Theme  (12)Tips and Tricks  (113)UI  (393)Uncategorized  (68)Unix  (2)User interface  (68)Visual State Manager  (2)Visual Studio  (31)Visual Studio Code  (19)Web  (619)What's new  (334)Windows 8  (19)Windows App  (2)Windows Phone  (15)Windows Phone 7  (9)WinRT  (26)
Introducing JavaScript Spreadsheet in Essential JS 2

Introducing JavaScript Spreadsheet in Essential JS 2

We are pleased to announce the availability of the Spreadsheet control in the Essential JS 2 suite with our latest release, 2019 Volume 3!

After overwhelming requests for the Spreadsheet control in Essential JS 2 standard, we have developed the Spreadsheet control in pure JavaScript with modular architecture and multiple-theme support. It is lightweight and you can easily integrate it into web applications as well as in supported third-party frameworks like Angular, React, Vue.Js, ASP.NET MVC, and ASP.NET Core.

Essential JS 2 Spreadsheet
Essential JS 2 Spreadsheet

What we shipped

The following is the list of key features in the Spreadsheet control:

  • Bind local and remote data sources using DataManager.
  • Use virtual rendering to populate data without performance degradation.
  • Experience real-time editing by predicting the nature of data.
  • Utilize a built-in calculation library with predefined formulas and named range support.
  • Format cells and values to get better visualization of your data.
  • Copy and paste data from internal and external sources.
  • Open and save Excel files with data accuracy and retained formatting.

How we designed it

We have designed the Spreadsheet control to be flexible, interactive, and completely customizable. We’ve also made sure the UI is optimal for touch interactions.

Essential JS 2 Spreadsheet- Design

  1. A ribbon is used to quickly access your preferred data visualization options and other features with collapsible support.
  2. Formula bar for inserting and editing formulas.
  3. Content area for populating and visualizing your data.
  4. Sheet tabs help you create and switch among multiple sheets.

Use cases

The following are some use case scenarios this control will best fit:

  • For organizing and analysing data in tabular format.
  • To get better insights from your data.
  • For multiple users editing in real-time using SignalR.

How to use it

We have a huge set of resources for you, including source code on GitHub, live demos in our sample browser, and customization features in our documentation. The following are the online samples available for individual platforms:

What’s next

The Spreadsheet control is now available in preview and we have planned a lot of improvements for the future releases. The following are some of the features you can expect in the upcoming release:

  • Filtering
  • Tables
  • Charts
  • Data validation
  • Conditional formatting
  • Freeze panes


We hope you enjoyed this quick introduction to the design and available features of Essential JS 2’s new Spreadsheet control. If you would like to give it a try, please download our latest available version 2019 Volume 3 and provide your valuable feedback.

If you have any questions, please let us know in the comments section below. You can also contact us through our support forums, Direct-Trac, or feedback portal. We are always happy to assist you!


Share this post:

Popular Now

Be the first to get updates

Subscribe RSS feed

Be the first to get updates

Subscribe RSS feed