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("优化完毕！");
}
