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.

Comments

Popular posts from this blog

VK9 - Milestone8 Completed

VK9 - Milestone13 Completed

VK9 - Milestone16 Completed