//Generate broker3h file public void GenerateBroker3hFile(List <BrokerInfo> brokerList) { string broker3hFilePath = MiscUtil.BackupFileWithNewName(configObj.BROKER3H_FILE_PATH); if (File.Exists(configObj.CHINESE_VERSION_FILE_PATH)) { string ChineseVersionFileBakFilePath = MiscUtil.BackupFileWithNewName(configObj.CHINESE_VERSION_FILE_PATH); } using (ExcelApp app = new ExcelApp(false, false)) { var workbook = ExcelUtil.CreateOrOpenExcelFile(app, broker3hFilePath); if (workbook.ReadOnly == true) { workbook.ReadOnlyRecommended = false; } int brokerRowsSum = 0; Logger.Log("**************************************************************************"); //Copy the content in Master sheet in Insert sheet Logger.Log("Begin to Generate the Insert Sheet"); GenerateInsertSheet(workbook, brokerRowsSum, brokerList); Logger.Log("**************************************************************************"); //Generate Chinese version File workbook.SaveCopyAs(configObj.CHINESE_VERSION_FILE_PATH); TaskResultList.Add(new TaskResultEntry("Broker3h_Chinese.xls", "Chinese Version Broker3h file", configObj.CHINESE_VERSION_FILE_PATH)); UpdateCColAsEnglish(brokerList, ExcelUtil.GetWorksheet(configObj.MASTER_WORKSHEET_NAME, workbook)); UpdateDColAsEnglish(brokerList, ExcelUtil.GetWorksheet(configObj.MASTER_WORKSHEET_NAME, workbook)); UpdateCColAsEnglish(brokerList, ExcelUtil.GetWorksheet(configObj.INSERT_WORKSHEET_NAME, workbook)); UpdateDColAsEnglish(brokerList, ExcelUtil.GetWorksheet(configObj.INSERT_WORKSHEET_NAME, workbook)); UpdatePageId(ExcelUtil.GetWorksheet(configObj.INSERT_WORKSHEET_NAME, workbook)); workbook.SaveCopyAs(configObj.BROKER3H_FILE_PATH); TaskResultList.Add(new TaskResultEntry("Broker3h.xls", "English Version Broker3h file", configObj.BROKER3H_FILE_PATH)); workbook.Close(false, workbook.FullName, false); } }