Archive for category iWork

Using Python to Cleanup Excel

Posted by clark in Productivity, Python, iWork on 2010/01/21

Often you get a spreadsheet with some data that needs heavily filtered. You could try Applescript but let’s be honest. For text processing Python is so much easier. So here’s a Python script I use a lot with Excel. It’s pretty flexible following my scripting rules. It’s designed to be more a template that I then modify when the need arises.

First the code and then the comments.

Read the rest of this entry »

2 Comments