Insert database values to specific excel sheet cells in C#

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:

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 

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());

}

}