private void ReNameFields(Worksheet ws) { PrograssBar innerPbar = new PrograssBar(); innerPbar.BarLength = 10; string strFieldEnglishTxt; string strFieldTxt; int iMax = 30; for (int j = 1; j < 100; j++) { ws.Cells[2, j].Value = ws.Cells[1, j].Value; strFieldTxt = ws.Cells[1, j].Value as string; if (strFieldTxt != null) { strFieldTxt = strFieldTxt.Trim(); //fieldNames.Add(strFieldTxt); if (fieldsDic.ContainsKey(strFieldTxt) == true) { fieldsDic.TryGetValue(strFieldTxt, out strFieldEnglishTxt); ws.Cells[1, j].Value = strFieldEnglishTxt; } else { unTranslatedFields.Add(strFieldTxt); //AddDic dc = new AddDic(); //dc.strHanzi = strFieldTxt; //if (dc.ShowDialog()==DialogResult.OK) //{ // strFieldEnglishTxt = dc.strEnglisTxt; // ws.Cells[1, j].Value = strFieldEnglishTxt; // /// 添加到字典中 // fieldsDic.Add(strFieldTxt, strFieldEnglishTxt); //} //else //{ // MessageBox.Show(ws.Name + "字段:" + strFieldTxt + "没有翻译,请检查"); //} } ////var strPinyinName = PinYinConverterHelp.GetTotalPingYin(strTabColName); ////strPinYinColName = strPinyinName.TotalPingYin.First<string>().ToUpper(); //ws.Cells[2, j].Value = strEnglishColName; } else { iMax = j; break; } LB_TabColuProgress.Text = innerPbar.ProgressMsg("修改" + ws.Name + "表的字段", j, iMax); } }
private void BT_OpenFile_Click(object sender, EventArgs e) { //Console.WriteLine("全拼音:" + String.Join(",", pingyins.TotalPingYin)); // Console.WriteLine("首音:" + String.Join(",", pingyins.FirstPingYin)); List <string> sheetNames = new List <string>(); List <string> newSheetNamesList = new List <string>(); string strTabColName = string.Empty; string strNewSheetName = string.Empty; string strPinYinColName = string.Empty; if (openFile.ShowDialog() == DialogResult.OK) { RegisterLib.PrograssBar prgBar = new PrograssBar(); prgBar.BarLength = 20; //pb.Max ExcelHelper helper = new ExcelHelper(); Worksheet ws; foreach (var fileName in openFile.FileNames) { helper.OpenFile(fileName); prgBar.MaxValue = helper.Sheets.Count; for (int i = 0; i < helper.Sheets.Count; i++) { ws = helper.Sheets[i + 1] as Worksheet; //if (ws.Name.Contains("表名对照")==true) //{ // ws.Delete(); //} sheetNames.Add(ws.Name); LB_SheetNames.Items.Add(ws.Name); LB_TotalProgress.Text = prgBar.ProgressMsg(string.Format("正在重命名sheet,第{0}个/总共{1}个", i + 1, helper.Sheets.Count), i, helper.Sheets.Count); ///获取新的sheet名称 var pingyins = PinYinConverterHelp.GetTotalPingYin(ws.Name); strNewSheetName = pingyins.FirstPingYin.First <string>().ToUpper(); strNewSheetName = GetReNameRulsPrefix(ws.Name) + strNewSheetName; if (newSheetNamesList.Contains(strNewSheetName)) { strNewSheetName += i.ToString(); } ws.Name = strNewSheetName; newSheetNamesList.Add(ws.Name); LB_NewSheetNames.Items.Add(ws.Name); if (ws.Name.StartsWith("TB")) { ///修改每个sheet的表名称为汉语拼音 ReNameFields(ws); } } //File.WriteAllLines("D:\\Dic.txt", fieldNames.ToArray()); ////将表明保存在excel中。 Worksheet newSheet = helper.Sheets.Add() as Worksheet; try { if (newSheet != null) { newSheet.Name = "表名对照"; } } catch (Exception) { MessageBox.Show("表名对照保存为:" + newSheet.Name); } for (int x = 1; x < sheetNames.Count; x++) { newSheet.Cells[x, 1].Value = sheetNames[x - 1]; newSheet.Cells[x, 2].Value = newSheetNamesList[x - 1]; } string newFile = fileName.Replace(".", "_OK."); helper.SaveAsNewFile(newFile);// (fileName); helper.WorkBook.Close(); helper.Excel.Quit(); MessageBox.Show("文件" + fileName + "改名完成"); //string[] sheetNames = ExcelHelper.GetSheetNames(fileName); //LB_SheetNames.DataSource = sheetNames; //LB_ReNamedSheetNames.DataSource = sheetReNames; } } File.WriteAllLines(@"未翻译字段.txt", unTranslatedFields.ToArray(), Encoding.UTF8); File.WriteAllLines(@"字典.txt", TB_DIC.Lines, Encoding.UTF8); }
private static void InitializeComponets() { PrograssBar.SimpleLoadingProcedure("Loading Components", 100, ConsoleColor.Red, ConsoleColor.Green, Console.BackgroundColor, Console.BackgroundColor, 1, 200); }
private static void InitializeModules() { PrograssBar.SimpleLoadingProcedure("Loading Modules", 100, ConsoleColor.White, ConsoleColor.White, Console.BackgroundColor, Console.BackgroundColor, 10, 500); CORE.CoreControler.CreateNewStation(); EasyLogging.SimpleLog("SAM", "Loading Mopdules", "output", ConsoleColor.Yellow); SAM.DATA.Station.PrintAllModuleInfo(); }