public void OutputMemoExcel(string v_excelPath) { Excel.Workbook book = new Excel.Workbook(v_excelPath); Excel.Worksheet sheet = book.Worksheets["CString"]; ExcelSheetObject eso = new ExcelSheetObject(sheet, "CString"); eso.init_header(); int row = 3; foreach (string words in _words) { eso.set_vali("Id", row, row - 2); eso.set_vals("Key", row, words); if (_data.ContainsKey(words)) { Dictionary <string, string> language = _data[words]; foreach (string lanHeader in language.Keys) { if (lanHeader != "Id") { eso.set_vals(lanHeader, row, language[lanHeader]); } } } row = row + 1; } book.Save(v_excelPath); }
public void initByFile(string v_excelPath) { Excel.Workbook book = new Excel.Workbook(v_excelPath); Excel.Worksheet sheet = book.Worksheets["CString"]; ExcelSheetObject eso = new ExcelSheetObject(sheet, "CString"); eso.init_header(); eso.init_data("Key"); ExcelSingleKeyData eskd = eso.getExcelSingleKeyData(); string[] headerNames = eskd.dataHeaders.ToArray(); foreach (string key in eskd._datas.Keys) { if (!_data.ContainsKey(key)) { _data[key] = new Dictionary <string, string>(); _words.Add(key); for (int i = 0; i < eskd.dataHeaders.Count; i++) { _data[key][eskd.dataHeaders[i]] = Convert.ToString(eskd._datas[key][i]); } } } }