For the lazy programmer: Using Excel as a code generator

Monday, July 14, 2014

As a 'lazy' programmer, I tend to find creative ways to generate code. One of today's challenges required me to create Enums (each with a description) from code & description pairs of unit measures found inside an Excel spreadsheet containing millions of records (okay I may be exaggerating).

Immediately, my brain started to think about possible solutions like T4 generation or find & replace. Luckily, I remembered I have Excel on my machine. This made things so much easier.

Community

Popular Posts

Archives

Contributors