private void GetDeleteItems(Application xlApp) { string folderPath = configObj.HKSeaFolderPath; string fileName = "HKSEA-Z2.xls"; Workbook hkSEABook = ExcelOperation.OpenWorkBook(xlApp, folderPath, fileName); deleteItems.GetDeleteItemsFromWorkBook(hkSEABook); hkSEABook.Close(Missing.Value, Missing.Value, Missing.Value); }
private Workbook WriteIntoMaster(Application xlApp) { string folderPath = configObj.WarGuideBFolderPath; string fileName = "war_guideB.xls"; Workbook warGuideBook = ExcelOperation.OpenWorkBook(xlApp, folderPath, fileName); CopyWarGuideBToBak(warGuideBook); warGuideBook = ExcelOperation.OpenWorkBook(xlApp, folderPath, fileName); warrantDataWriter.WriteIntoMasterSheet(warGuideBook, warrantDataItem, Logger); return(warGuideBook); }
private void GetDataFromFolderWarrent(Application xlApp, HKSpeedGuideXML xmlObj, Logger logger) { string folderPath = configObj.WarrantFolderPath; //@"D:\HKRicTemplate\Warrant"; List <string> fileNames = FileUtil.GetTodayFileNameFromFolder(folderPath); if (fileNames != null && fileNames.Count > 0) { foreach (Workbook wBook in fileNames.Select(fileName => ExcelOperation.OpenWorkBook(xlApp, folderPath, fileName))) { warrantDataItem.GetWarrantDataFromWorkBook(wBook, configObj, xmlObj, logger); //wBook.Close(Missing.Value, Missing.Value, Missing.Value); } } }