Transfer data to an Excel workbook programmatically


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.

Comments (1)

  1. MSDN Archive says:

    You can also do this with third party tools such as SoftArtisans OfficeWriter.

Skip to main content