web analytics

Tagged: excel

Easy way to Export dataset in Excel 0

Easy way to Export dataset in Excel

Fastest way to export dataset in excel format is: DataSet dsExport = new DataSet(); System.IO.StringWriter tw = new System.IO.StringWriter(); HTMLTextWriter hw = new HTMLTextWriter(tw); DataGrid dg = new DataGrid(); dg.DataSource = "Dataset to be...

Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154 25

Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154

Sometimes when working with office Interop assemblies the above mentioned error occurs. I had also got the same when using Microsoft Excel interop assembly and adding its reference in my ASP.NET application.    ...