Challenge #45: Parsing Bureau of Labor Data

[Dhrish]

SOLUTION: Used the file from thread as the Page isnt there.

Spoiler

[Carolyn]

Solved, using the file that was provided earlier in the thread - thanks to who did that! xlsx file attached here to try to minimize people needing to dig for it :)

Spoiler

[Pilsner]

My solution:

Spoiler

[jrlindem]

Late to the party, so I needed to use the static file found in other's recent posted solutions (noting that this file has more data than what was linked to originally, so the results are different than the supplied example).

Not terribly difficult, but has some nuanced techniques that are good to practice up on (i.e. Sheet handling, column names, null rows, parsing, trimming, etc.)

Here's my solution (and attached):

Spoiler

Overall, a fun challenge.  -Jay