Exporting some images and datatables to an excel sheet in C#

The easiest and fastest way to work with Excel in C# is to use some 3rd party component. You can try something like Aspose or Elerium C# components to read excel files. It is not free but it can save you a lot of time. I am using Elerium C# component and can give you some some code:

ExcelWorkbook Wbook = ExcelWorkbook.ReadXLS(@"c:\test.xls");
ExcelWorksheet Wsheet=Wbook.Worksheets.Add("Wsheet1");
// to export datatable to excel worksheet
Wsheet.ReadFromDataTable(dt);
// to insert  image into worksheet
Wsheet.Pictures.Add(@"c:\pic.jpg");
Wsheet.Pictures[0].SetPosition(0, 0);
//save result file
Wbook.WriteXLS(@"c:\test.xls");

You can use Spire.Dataexport to export image and datatable to excel sheet:
The codes are below:
  using(OleDbConnection oleDbConnection = new OleDbConnection()) 

    { 

        oleDbConnection.ConnectionString = this.textBox1.Text; 

         OleDbCommand oleDbCommand = new OleDbCommand(); 

        oleDbCommand.CommandText = this.textBox2.Text; 

        oleDbCommand.Connection = oleDbConnection; 

         using(OleDbDataAdapter da = new OleDbDataAdapter(oleDbCommand)) 

        { 

             DataTable dt = new DataTable(); 

             da.Fill(dt); 

             dataGridView1.DataSource = dt; 

        } 

     } 

Hi Thana,

Please refer these urls:

http://www.codeproject.com/Articles/164582/8-Solutions-to-Export-Data-to-Excel-for-ASP-NET
http://www.dotnetgallery.com/lab/resource44-Export-to-excel-from-DataTable-using-CNET.aspx