Write to a single MS excel cell using c#

Austin Muts

I have excel with data,there 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#?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Karthik Elumalai10y ago
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 Singh10y ago
Hi

check the link

http://www.codeproject.com/Questions/552314/howplustopluswriteplustextplusboxplusvaluesplustop

Try the below code
publicvoidWriteToExcel()
{
stringmyPath=@"C:\Excel.xls";//thismustbefullpath.
FileInfofi=newFileInfo(myPath);
if(!fi.Exists)
{
Console.Out.WriteLine("filedoesn'texists!");
}
else
{
varexcelApp=newMicrosoft.Office.Interop.Excel.Application();
varworkbook=excelApp.Workbooks.Open(myPath);
Worksheetworksheet=workbook.ActiveSheetasWorksheet;
Microsoft.Office.Interop.Excel.Rangerange=worksheet.Cells[1,1]asRange;
range.Value2="5";
//excelApp.Visible=true;
workbook.Save();
workbook.Close();
}
}