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

Question

Hi I would like to export some images and some datatables to an excel sheet. Similarly I have to export to many other excel sheets in the same excel workbook using C#. Is there any easier way of doing this? Thanks in advance Thana

Alex Heig · Answer

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:	est.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:	est.xls);

George eric · Answer

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; } }

Senthilkumar · Answer

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