Simple Excel Add-in Querying Tool

About Us

Boost is a Microsoft Excel Add-in to help developers import large excel workbooks into their database using SQL queries. Microsoft Excel has more than 30 million users and is the most popular spreadsheet application on the market. It is one of Microsoft’s core products since Excel’s release in 1985 and it has a new user every five minutes.

Features

📝 Reading and writing from multiple sheets to query table

💪 Ability to use custom functions directly in Excel


Getting Started

Installation

Prerequisite: Install Microsoft Excel Desktop version 16 and up.

  1. Fork and clone this repository.
  2. npm install
  3. npm start

Technologies

Excel | Excel JS API | React | React Hooks | Typescript | SQL | CodeMirror | Jest



The Boost Team


Chloe Courtois @chloecourt Janson Xavier @JansonXavier Sophia Sam @sophiasam96



If You Want To Contribute!

If you found this interesting or helpful at all, feel free to drop a ⭐ GitHub stars ⭐ on this project to show your support!

All bugs, tasks or enhancements are tracked as GitHub issues.

The following is a list of features + improvements for future open-source developers that the Boost team has either started or would like to see implemented. If you have additional new ideas, feel free to implement those as well! Much appreciated.

Query:

  • Implementing JOIN clause for Querying
  • Handling invalid/duplicate names in Query input
  • Row management in the Query table

Custom Functions

  • Reading and writing from the text editor to functions.ts file
  • Creating custom functions in Typescript

Other:

  • React Hooks testing
  • Containerization with Docker

License

This project is available under the MIT License.

GitHub

View Github