ClosedXML - Could not load file or assembly
After going crazy searching for answers and finally posting a question, I came across the simplest answer and once I referenced the additional .dll everything worked correctly.
To use ClosedXML you must reference the DocumentFormat.OpenXml.dll:
DocumentFormat.OpenXml.dll for NET 4.0+