Introducing BermudoGreen.js: A Free, Zero-Dependency Excel Spreadsheet & Formula Engine for Vanilla JS
Hey everyone! ๐ I'm excited to introduce BermudoGreen.js , a lightweight, completely free, and open-source Excel spreadsheet and formula calculation engine built for Vanilla JavaScript. Many modern spreadsheet solutions for the web come with expensive licensing fees that can cost developers thousands of dollars. I wanted to create a simple, reliable, zero-dependency alternative that anyone canโฆ
Introducing BermudoGreen.js, a completely free and open-source Excel spreadsheet and formula calculation engine built for Vanilla JavaScript. Many modern web spreadsheet solutions come with expensive licensing fees, which can cost developers thousands of dollars. The goal of BermudoGreen.js is to provide a simple, reliable, and zero-dependency alternative that can be easily integrated into web applications without worrying about enterprise-level pricing or restrictive licensing.
Key features include a built-in formula engine with support for common functions like SUM, AVERAGE, COUNT, IF, VLOOKUP, and more. An interactive formula bar with dynamic multi-color range highlighting and IntelliSense auto-complete tooltips is also available. The engine supports Excel layout conventions such as column letters (A, B, C, etc.), row numbers (1, 2, 3, etc.), auto-fit columns, and drag-to-resize functionality.
Number formatting options include Currency, Percentage, Integers, Decimals, and Dates. Seamless copy/paste (Ctrl+C / Ctrl+V) functionality is supported for direct transfer to and from Microsoft Excel or Google Sheets. Global undo/redo support via Ctrl+Z and Ctrl+Y is also included.
With zero dependencies, BermudoGreen.js is built using pure Vanilla JavaScript, HTML5, and CSS, making it lightweight and easy to integrate into any web application. To get started, visit the live demo or clone the repository from the GitHub link provided. Simply add the necessary links and script tags to your HTML, and drop the spreadsheet into your page.
Written by urgent.news from Dev.to's reporting โ not their text. Machine-written โ may contain errors; check the original before relying on it.