Hello All,
Please help me out with this.
The objective is like this.
1.Open Excel file(Already Existing)
2.Write Data To it.
3.Save it and close it.
Step 1 is achieved using
Excel.Workbook CreateXLFile = StartExcel.Workbooks.Open(
FileName,
0,
true,
5,
"",
"",
true,
Excel.XlPlatform.xlWindows,
"\t",
false,
false,
0,
true,
1,
0);
Excel.Worksheet SelectXLSheet = (Microsoft.Office.Interop.Excel.Worksheet)CreateXLFile.ActiveSheet;
Step 2 is achieved using
SelectXLSheet.Cells[Cell, Row] = Data;
Step 3 is tried using workbook.save() method.
But this does not work.
Please help me out with how i can only save method to save file rather than use saveas method.