Other articles

1. Scraping Websites with DFS

   Depth-First Search for cataloging links on a site.

   At my current job we use a content management system (CMS) to post content to the web. We also use the Google suite of tools for sharing documents via the CMS. There were hundreds of links in the CMS that led to …

   read more

2. Spreadsheet Art with Python

   Pixel images transferred to spreadsheet.

   After working with openpyxlI found you could manipulate the cell styles using python. So I worked on a little script to draw a png image pixel by pixel to individual cells in a spreadsheet. It turned out to be an amusing project.

   This is …

   read more

3. 5000 Lines of Madness

   At work, a community group sent my department a directory to local businesses. It was in a spreadheet and it was a mess. It looked something like this:

   There was 5000 lines of this mess. There was some consistency, but not enough to make this and easy fix. The first …

   read more