Creating and writing XML file through C#

using Microsoft.Office.Core;

using Excel = Microsoft.Office.Interop.Excel;





        Excel.Application myExcelApp;

        Excel.Workbooks myExcelWorkbooks;

        Excel.Workbook myExcelWorkbook;





        object misValue = System.Reflection.Missing.Value;





myExcelApp = new Excel.ApplicationClass();

        myExcelApp.Visible = true;

myExcelWorkbooks = myExcelApp.Workbooks;

String fileName = "C:\\book1.xls"; \\ set this to your file you want

  myExcelWorkbook = myExcelWorkbooks.Open(fileName, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue);                 



Excel.Worksheet myExcelWorksheet = (Excel.Worksheet)myExcelWorkbook.ActiveSheet;

 

String cellFormulaAsString = myExcelWorksheet.get_Range("A2", misValue).Formula.ToString(); \\ this puts the formula in Cell A2 or text depending whats in it in the string.



myExcelWorksheetToChange.get_Range("C22", misValue).Formula = "New Value" \\ this changes the cell value in C2 to "New Value"