Showing posts from February, 2013

Excel Interop Performance

This is my first post of 2013. I've been pretty busy with work so Enigma is on hold for now. The good news is I'm keeping my skills sharp with paid work. I learned another programming lesson the hard way. Apparently adding rows cell by cell with the Excel Interop is painfully slow. The good news is you can pass a multi-dimensional array to the value property with your range set to the entire area you want to update.