Ads Header

Friday, June 3, 2011

Populate an Excel Worksheet from .NET using the Excel object

Friday, June 3, 2011 by ASP.NET · 0

You can format your data as a TAB delimited string, use the Excel object to start an instance of Microsoft Excel, select the worksheet and range to populate, and paste in your data. To use the Excel object you must first set a COM reference to the Microsoft Excel Object Library which is an ActiveX component. Behind the scenes .NET uses the Interop.Excel DLL to talk to Excel....