Rory BlythEXCEL AS A DATABASE1

Just wait until you find out that your corporate firewall strips the pictures from incoming email.Ed.

As a developer, you've probably, at some unfortunate point in your life (possibly several points, actually), been handed an Excel file that has been crammed full of "data" by someone in marketing and been told to "do something with it."

Columns probably didn't line up, and a thousand different fonts were used. Every feature of Excel was probably abused and abused again to avoid having to use an actual database application for storage of the data.

Of course, it's up to you to make sense of the layout, and marketing could just give a bleepity-bleep about what a pain it is to suck weird data out of Excel and ...

Get THE BEST SOFTWARE WRITING I now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.