Thanks to Vimal and and Sateesh, we could manage to read an excel file , and change one cell value to double(+doing some math operation).I want to write it back to excel by c#.
Would you please let me know how to :1. write this new value(of type double) to another excel file(say Book.3) and in Worksheet3 and cell[12,1]
using
//using System.Linq;
namespace
{
App =
oBooks =
oBook =
oSheet =
App.Visible =
oBooks = App.Workbooks;
oBook = oBooks.Open(filepath,
oSheet = (
* range */
}
oSheet2.Cells.Cells[1, 1] = oSheet.Cells.Cells[1, 1];
oBook.Save();
App.Quit();
System.Runtime.InteropServices.