Efficiently Inserting Many Rows into an Excel Spreadsheet
Describes how to use an O(log n) algorithm to dramatically improve the performance of inserting large numbers of rows into existing Excel spreadsheets, using VSTO and C#. Continue reading
Category Archives: MS Office Interop
A Guide to Excel Automation
Introduces and explains the basic concepts behind Excel Automation (aka Excel Interop, VSTO, Office PIAs). Covers namespace aliases, the main classes and interfaces, proper garbage collection, Range, formatting, merged cells, Worksheet, headers/footers and provides examples for common functions. Continue reading