Brad Smith’s Coding Blog

Windows apps, business systems and games in C# and C++

Main menu

Skip to primary content
Skip to secondary content
  • About
  • Projects
    • ABA/Cemtext Validator
    • Drop-Down Controls
    • Image Collage Generator
    • mcNetworkCopy
    • TOM Classes for .NET
  • Copyright
  • Expressions of Interest
  • Donations
  • GitHub

Category Archives: MS Office Interop

Efficiently Inserting Many Rows into an Excel Spreadsheet

Posted on January 14, 2011 by Bradley Smith | 4 Replies

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 →

Share/Bookmark
Posted in MS Office Interop.

A Guide to Excel Automation

Posted on June 9, 2010 by Bradley Smith | 18 Replies

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 →

Share/Bookmark
Posted in MS Office Interop.
E-Mail YouTube Channel LinkedIn Profile Google+ Profile Facebook Profile

Donations

If you find my code/articles useful, please consider making a donation:

PayPal: bs@brad-smith.info

Recent Posts

  • A Novel Solution for Previewing PDFs in Desktop Applications
  • An Alternative to Large Byte Arrays and MemoryStream
  • Building a Better Tag Cloud
  • A Searchable Drop-Down Control
  • Single Instance Application with a Custom URI Scheme
  • DataGridView Column Types for Drop-Down Controls
  • Managed Wrapper for TOM 2 / RichEdit 8
  • Sorting Strings Using Natural Language Rules

Tag Cloud

abstract classes accounting AppDomain C# C/C++ collections COM comedy console CTEs custom controls data binding encryption enumerators Excel extension methods file formats generics graphics GUI design inheritance interfaces Interop LINQ MCML media center networking Office physics recursion refactoring reflection remoting serialisation SharePoint simulation sorting SQL streams WCF Win32 Windows Forms Windows Registry XML XML web services

Categories

  • Announcements (15)
  • Coding practices (1)
  • Computer Science (3)
  • Databases (2)
  • Downloadable source code (20)
  • GUI components (10)
  • MS Office Interop (2)
  • Republished articles (2)
  • SharePoint (1)
  • Standards (1)
  • Utility code (26)
  • Web development (1)
  • Windows Media Center (9)

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
© 2023 Brad Smith’s Coding Blog, all rights reserved.
Proudly powered by WordPress