This is a program written for Geokinetics to manage the battery test results. A batch of batteries would be put under a 6A load, and the Computer Battery Analyzer software would generate XML files of the raw data. My exporter takes the relevant data from each XML file, formats it, and inserts it into a single Excel spreadsheet to manage the entire inventory.
The Append method below is the heart of the Inventory class which works with the
Microsoft Office Interoperability library.
I re-wrote a large chunk of this program to use the fantastic [EPPlus] library to handle writing to the Excel file.
It's much more reliable now, and requires less work on the users' end of things.