Write to a single MS excel cell using c#

Question

I have excel with datathere are some text within excel cells that i want to replace with other text using c#.How can i update the text within the excel cells using c#?

Karthik Elumalai · Answer

Hi Austin Muddai Kindly refer the below link to work with excel http://www.c-sharpcorner.com/article/read-excel-files-using-open-xml-sdk-in-asp-net-c-sharp/ Openxml will be best for all your requirements. kindly let me know your thoughts thanks karthik

Vinay Singh · Answer

Hi check the link http://www.codeproject.com/Questions/552314/howplustopluswriteplustextplusboxplusvaluesplustop Try the below code public void WriteToExcel() { string myPath=@ C:\Excel.xls ; //thismustbefullpath. FileInfofi= new FileInfo(myPath); if (!fi.Exists) { Console.Out.WriteLine( filedoesn'texists! ); } else { varexcelApp= new Microsoft.Office.Interop.Excel.Application(); varworkbook=excelApp.Workbooks.Open(myPath); Worksheetworksheet=workbook.ActiveSheet as Worksheet; Microsoft.Office.Interop.Excel.Rangerange=worksheet.Cells[11] as Range; range.Value2= 5 ; //excelApp.Visible=true; workbook.Save(); workbook.Close(); } }