//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);
}
}