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.
check out our website www.boost-excel.com
📝 Reading and writing from multiple sheets to query table
💪 Ability to write and use custom functions directly in Excel with TypeScript
Prerequisite: Install Microsoft Excel Desktop version 16 and up.
- Fork and clone this repository.
npm install
npm start
Excel | Excel JS API | React | React Hooks | Typescript | SQL | CodeMirror | Jest
- Go to the ribbon INSERT, Add-Ins. Click on Boost and head back to HOME to open.
- Click on the Query tab in the add-in to utilize the querying feature. Query across multiple worksheets in your Excel application.
- Click on the IDE tab to create and save customized TypeScript functions.
Charles Ren @codeWithRen
Chloe Courtois @chloecourt
Janson Xavier @JansonXavier
Sophia Sam @sophiasam96
If you found this interesting or helpful at all, feel free to drop a ⭐ ⭐ 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
Kevin Co - Logo Designer @itskevinco
This project is available under the MIT License.