Boost is a Microsoft Excel Add-in to help developers import large excel workbooks into their database using SQL queries

OSLabs Beta

Last update: Sep 30, 2022

Related tags

Learning resource Boost

Overview

Microsoft Excel Add-in for Developers

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 write and use custom functions directly in Excel with TypeScript

Getting Started

Installation

Prerequisite: Install Microsoft Excel Desktop version 16 and up.

Fork and clone this repository.
npm install
npm start

Technologies

How it works

How to open

Go to the ribbon INSERT, Add-Ins. Click on Boost and head back to HOME to open.

Querying

Click on the Query tab in the add-in to utilize the querying feature. Query across multiple worksheets in your Excel application.

Custom Function Creations

Click on the IDE tab to create and save customized TypeScript functions.

The Boost Team

Charles Ren @codeWithRen
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 ⭐ ⭐ 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

Contributors

Kevin Co - Logo Designer @itskevinco

License

This project is available under the MIT License.

Import/Export data from and to your database in just few clicks.

Strapi Plugin Import Export Entries Import/Export data from and to your database in just few clicks. Features Import Import data directly from the Con

Dec 28, 2022

Learn GraphQL by building a blogging engine. Create resolvers, write schemas, write queries, design the database, test and also deploy.

GraphQL Blog graphqlblog.com Learn GraphQL by building a blogging engine. Create resolvers, write schemas, write queries, design the database, test an

Aug 17, 2022

e-ONG, an authorial project, whose objective is to help ONGs to find people who need help or would like to help them

This project was bootstrapped with Create React App. Available Scripts In the project directory, you can run: npm start Runs the app in the developmen

Nov 11, 2022

A jquery plugin that allows an html page to be converted and/or downloaded into a Microsoft Word Document with an emphasis on performance

googoose A jquery plugin that allows an html page to be converted and/or downloaded into a Microsoft Word Document with an emphasis on performance Abo

Jan 3, 2023

⛲ Sort import declarations into a pleasing and readable cascade.

⛲ eslint-plugin-cascading-imports This plugin allows to automatically enforce a visual "cascading" order for import declarations. Imports in each bloc

Jan 20, 2022

A plugin that can query multiple APIs for movies, series, anime, games, music and wiki articles, and import them into your vault.

Obsidian Media DB Plugin A plugin that can query multiple APIs for movies, series, anime, games, music and wiki articles, and import them into your va

Dec 21, 2022

Turn queries into easy-to-use tools your teammates can share.

Turn queries into easy-to-use tools your teammates can share. Parameterize! Visualize! Collaboratize?! qwaver links: Latest Build •Use Cases • Help! •

Nov 3, 2022

The to-do list project is an app that allows users to successfully organize their day by inputting prioritized tasks. The project also allows users to carry out the CRUD operations for (add, edit and delete). Two special features of the app are that it saves tasks in the local storage of the user's browser, so when the user reloads or revisits the app, the user can view a list of tasks formerly inputted, and it allows users to prioritize their tasks by dragging up and down the list section.

TO-DO-LIST This is a To Do List Project that dynamically displays tasks to be done with interactions for removing and adding task when completed or no

Nov 1, 2021

An exercise in building a very minimal (and very stupid) in-memory SQL-like database for educational purposes.

Stupid Database This is an exercise in building a very minimal (and very stupid) in-memory SQL-like database for educational purposes. None of this co

Dec 20, 2022

Boost is a Microsoft Excel Add-in to help developers import large excel workbooks into their database using SQL queries

Related tags

Overview

Microsoft Excel Add-in for Developers

About Us

Features

Getting Started

Installation

Technologies

How it works

How to open

Querying

Custom Function Creations

The Boost Team

If You Want To Contribute!

Contributors

License

You might also like...

Import/Export data from and to your database in just few clicks.

Learn GraphQL by building a blogging engine. Create resolvers, write schemas, write queries, design the database, test and also deploy.

e-ONG, an authorial project, whose objective is to help ONGs to find people who need help or would like to help them

A jquery plugin that allows an html page to be converted and/or downloaded into a Microsoft Word Document with an emphasis on performance

⛲ Sort import declarations into a pleasing and readable cascade.

A plugin that can query multiple APIs for movies, series, anime, games, music and wiki articles, and import them into your vault.

Turn queries into easy-to-use tools your teammates can share.

An exercise in building a very minimal (and very stupid) in-memory SQL-like database for educational purposes.

Owner

OSLabs Beta

THE PROJECT IDEA is to create a platform where developers can improve on their typing speed and accuracy by playing a coding typing game in their preferred programming language, which will make developers both beginners and pros get more familiar with the syntax of their programming languages.

Import flow for Excel (.xlsx) and CSV file with automated column matching and validation.

Mind Mapping to excel, or excel to .xmind file

We are creating a Library that would ensure developers do not reinvent the wheel anymore as far as Authentication is concerned. Developers can easily register and download authentication codes that suits their need at any point.

A sample app (with TypeScript) to help developers bootstrap their Shopify app development.

See a banned user's profile, their friends, their favorite games, their followers etc.

🚀 A script to boost hours in Steam games.

This package is for developers to be able to easily integrate bad word checking into their projects.\r This package can return bad words in array or regular expression (regex) form.

🗃️ An in-memory JS database optimized for large scale storage on the frontend.

This package will help parse OData strings (only the Microsoft Dataverse subset). It can be used as a validator, or you can build some javascript library which consumes the output of this library.