Excel.Application EXL = new Excel.ApplicationClass();
Excel.Workbook WRKBK = EXL.Workbooks.Open(Environment.CurrentDirectory + "/XYZ.xlsx", 0, false, 5, System.Reflection.Missing.Value, System.Reflection.Missing.Value, false, System.Reflection.Missing.Value, System.Reflection.Missing.Value, true, false, System.Reflection.Missing.Value, false, false, false);
WRKBK.RefreshAll(); WRKBK.Save(); EXL.Quit();
|