Frank M. Taylor

In a nutshell:

It's a tiny Python utility that converts an Excel document to JSON

A few years ago I was tasked with building a small single application. That was all fine, but the data wasn't! I had an Excel spreadsheet with hundreds of rows that needed to get migrated into a database. So I built a small utility to conver Excel spreadsheets into data, and it's now my most-starred repository.

In a nutshell

After building quite a few Azure Functions for clients, I decided my life would be easier if I had a "starter" project. So that's what this is.

This provides a small set of utilities and some configuration management, along with some patterns for using Application Insights.

This also uses Microsoft's Azure Storage library, but nicely promisified. It's set for adding and retrieving blob data and message queues. Table Storage is coming soon!

Installation

Download the repo, and delete the function folders you don't need

In a nutshell:

What do you do if you want to delete a CSS ruleset, but you don't know if it's used? Well, if you're me, you build a tool that finds the selector. This is a CLI (Command Line Interface) app that can be fed a site's XML file, and from that it'll scan all the pages, looking for your CSS selector.

But, it can do more than just find a single CSS selector. You can feed it a whole stylesheet, set how much detail you want, and even get screenshots of what it finds. This is a very handy little tool for front-end developers.

Installation

Download repository. Then run npm i. The CLI and/or readme will guide you from there.

Learning More:

I wrote a blog post that goes into some detail about its origins and uses.