private void btnAddExcel_Clicked(object sender, RoutedEventArgs e) { var panel = new HeaderPage(); panel.IsNewFileMode = true; panel.ExcelDir = AppData.Config.ExcelDir; panel.refreshDislpay(new List <TableExcelHeader>() { new TableExcelHeader() { FieldName = "Id", FieldType = "int", FieldDesc = "唯一Id索引", }, new TableExcelHeader() { FieldName = "KeyName", FieldType = "string", FieldDesc = "唯一Key索引", }, }); var pw = new PopupWindow(panel); pw.ResizeMode = ResizeMode.CanResize; pw.Owner = Window.GetWindow(this); pw.Title = string.Format("新建Excel表格"); pw.MinWidth = 600; pw.MinHeight = 400; if (pw.ShowDialog() == true) { try { TableExcelWriter.genExcel(new TableExcelData(panel.Headers, new List <TableExcelRow>()), panel.ExcelFullPath); refreshExcelPath(AppData.Config.ExcelDir); lv.selectItemByFullPath(panel.ExcelFullPath); } catch (System.Exception ex) { this.ErrBox(ex.Message); } } }
private void btnSave_Clicked(object sender, RoutedEventArgs e) { try { dataGrid1.CommitEdit(DataGridEditingUnit.Row, true); updateDataFromDataGrid(); var fp = filePath_.ToLower(); if (fp.EndsWith(".xls") || fp.EndsWith(".xlsx")) { TableExcelWriter.genExcel(data_, filePath_); } else if (fp.EndsWith(".exdat")) { TableExcelExportDat.exportExcelFile(data_, filePath_); } else if (fp.EndsWith(".json")) { TableExcelExportJson.exportExcelFile(data_, filePath_); } else if (fp.EndsWith(".xml")) { TableExcelExportXml.exportExcelFile(data_, filePath_); } else if (fp.EndsWith(".lua")) { var filePath = filePath_; if (AppData.Config.FitUnity3D == true) { filePath += ".txt"; } TableExcelExportLua.exportExcelFile(data_, filePath); } Window.GetWindow(this).Close(); } catch (System.Exception ex) { this.ErrBox(ex.Message); } }
public void rectifyFileFormat(string filePath) { if (!File.Exists(filePath)) { Log.Err("源文件不存在! {0}", filePath); return; } Log.Msg("================================================="); try { Log.Msg("正在优化 {0}", filePath); TableExcelData data = TableExcelReader.loadFromExcel(filePath); TableExcelWriter.genExcel(data, filePath); Log.Msg("优化完毕!"); } catch (System.Exception ex) { Log.Err(ex.Message); } }
public void rectifyAllFileFormat(List <string> files) { if (files.Count == 0) { Log.Wrn("没有要优化的文件"); return; } Log.Msg("================================================="); foreach (var filePath in files) { try { Log.Msg("正在优化 {0}", filePath); TableExcelData data = TableExcelReader.loadFromExcel(filePath); TableExcelWriter.genExcel(data, filePath); } catch (System.Exception ex) { Log.Err(ex.Message); } } Log.Msg("优化完毕!"); }