Insert database values to specific excel sheet cells in C#

Question

Hi all, I want to fetch database values and insert into excel sheet to specific cells and then convert that excel sheet to pdf. Plz help me asap.

Leon D · Answer

Hi Sagar Pandurang Kap, It's fairly simple to do this with Spire.XLS library. At first, add reference to Spire.Xls.dll, then read data into a datatable, after that insert datatable to worksheet and save the worksheet to pdf, just like below: //export dataTable to the first worksheet Workbook workbook = new Workbook(); Worksheet sheet = workbook.Worksheets[0]; sheet.InsertDataTable(dataTable, true , 1, 1); //Save worksheet to PDF sheet.SaveToPdf( "toPDF.pdf" ); More details can be found here: https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Data-Export-/Import-Export-Datatable-to-Excel-from-Database.html https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Conversion/Convert-worksheet-to-PDF-in-C-VB.NET.html

Anurag Sharma · Answer

private void button1_Click(object sender, EventArgs e) { try { System.Data.OleDb.OleDbConnection MyConnection ; System.Data.OleDb.OleDbCommand myCommand = new System.Data.OleDb.OleDbCommand(); string sql = null; MyConnection = new System.Data.OleDb.OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;Data Source='c:\csharp.net-informations.xls';Extended Properties=Excel 8.0;"); MyConnection.Open(); myCommand.Connection = MyConnection; sql = "Update [Sheet1$] set name = 'New Name' where id=1"; myCommand.CommandText = sql; myCommand.ExecuteNonQuery(); MyConnection.Close(); } catch (Exception ex) { MessageBox.Show (ex.ToString()); } }