Transfer data to an Excel workbook programmatically

  • Article

Just today I came across this excellent Knowledge Base article:

How to transfer data to an Excel workbook by using Visual C# 2005 or Visual C# .NET

It discusses a number of methods to get the task done, and seeing them all together in one page is quite handy.

With the new Office Open XML file formats, however, there is yet another lightweight alternative for generation that combines rich formatting (which is missing in comma-separated value generation) with the ability to run without Excel running in the process (great for ASP.NET-like scenarios). Very, very cool stuff.