private static void exportFile(string excelPath, string outputDir, TableExportFormat fmt) { var data = TableExcelReader.loadFromExcel(excelPath); switch (fmt) { case TableExportFormat.Dat: { var exportPath = Path.Combine(outputDir, string.Format("{0}.exdat", Path.GetFileNameWithoutExtension(excelPath))); TableExcelExportDat.exportExcelFile(data, exportPath); } break; case TableExportFormat.Json: { var exportPath = Path.Combine(outputDir, string.Format("{0}.json", Path.GetFileNameWithoutExtension(excelPath))); TableExcelExportJson.exportExcelFile(data, exportPath); } break; case TableExportFormat.Xml: { var exportPath = Path.Combine(outputDir, string.Format("{0}.xml", Path.GetFileNameWithoutExtension(excelPath))); TableExcelExportXml.exportExcelFile(data, exportPath); } break; case TableExportFormat.Lua: { var exportPath = Path.Combine(outputDir, string.Format("{0}.lua", Path.GetFileNameWithoutExtension(excelPath))); TableExcelExportLua.exportExcelFile(data, exportPath); } break; } }
private void _genSingleFileImpl(string filePath, string exportDir, TableExportFormat fmt) { Log.Msg("正在分析 {0}", filePath); try { TableExcelData data = TableExcelReader.loadFromExcel(filePath); string errmsg; if (!data.checkUnique(out errmsg)) { Log.Wrn(errmsg); } switch (fmt) { case TableExportFormat.Json: { var exportPath = Path.Combine(exportDir, string.Format("{0}.json", Path.GetFileNameWithoutExtension(filePath))); TableExcelExportJson.exportExcelFile(data, exportPath); } break; /* * case TableExportFormat.Dat: * { * var exportPath = Path.Combine(exportDir, string.Format("{0}.exdat", Path.GetFileNameWithoutExtension(filePath))); * TableExcelExportDat.exportExcelFile(data, exportPath); * } * break; * case TableExportFormat.Xml: * { * var exportPath = Path.Combine(exportDir, string.Format("{0}.xml", Path.GetFileNameWithoutExtension(filePath))); * TableExcelExportXml.exportExcelFile(data, exportPath); * } * break; * case TableExportFormat.Lua: * { * var exportPath = Path.Combine(exportDir, string.Format("{0}.lua", Path.GetFileNameWithoutExtension(filePath))); * TableExcelExportLua.exportExcelFile(data, exportPath); * } * break; */ } //生成.h文件 { var exportPath = Path.Combine(exportDir, string.Format("{0}.h", Path.GetFileNameWithoutExtension(filePath))); var outCppData = CreateTableCpp.toFileData(Path.GetFileNameWithoutExtension(filePath), data.Headers); File.WriteAllBytes(exportPath, Encoding.UTF8.GetBytes(outCppData)); } Log.Msg("生成成功"); } catch (System.Exception ex) { Log.Err(ex.Message); } }
public static void processOpenExcelFile() { try { var data = TableExcelReader.loadFromExcel(OpenExcelFullPath); openEditUI(data, OpenExcelFullPath); } catch (System.Exception ex) { MsgBox(ex.Message); } }
private void _genSingleFileImpl(string filePath, string exportDir, TableExportFormat fmt) { Log.Msg("正在分析 {0}", filePath); try { TableExcelData data = TableExcelReader.loadFromExcel(filePath); string errmsg; if (!data.checkUnique(out errmsg)) { Log.Wrn(errmsg); } switch (fmt) { case TableExportFormat.Dat: { var exportPath = Path.Combine(exportDir, string.Format("{0}.exdat", Path.GetFileNameWithoutExtension(filePath))); TableExcelExportDat.exportExcelFile(data, exportPath); } break; case TableExportFormat.Json: { var exportPath = Path.Combine(exportDir, string.Format("{0}.json", Path.GetFileNameWithoutExtension(filePath))); TableExcelExportJson.exportExcelFile(data, exportPath); } break; case TableExportFormat.Xml: { var exportPath = Path.Combine(exportDir, string.Format("{0}.xml", Path.GetFileNameWithoutExtension(filePath))); TableExcelExportXml.exportExcelFile(data, exportPath); } break; case TableExportFormat.Lua: { var exportPath = Path.Combine(exportDir, string.Format("{0}.lua", Path.GetFileNameWithoutExtension(filePath))); TableExcelExportLua.exportExcelFile(data, exportPath); } break; } Log.Msg("生成成功"); } catch (System.Exception ex) { Log.Err(ex.Message); } }
public void editForExcel(string filePath) { if (!File.Exists(filePath)) { Log.Err("源文件不存在! {0}", filePath); return; } try { TableExcelData data = TableExcelReader.loadFromExcel(filePath); openExcelView(data, filePath); } catch (System.Exception ex) { Log.Err(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("优化完毕!"); }
private bool _genSingleFileImpl(string filePath, string exportDir, TableExportFormat fmt) { Log.Msg("----------正在导出 {0}----------", filePath); string exportPath = exportDir; try { TableExcelData data = TableExcelReader.loadFromExcel(filePath); string errmsg; if (!data.checkUnique(out errmsg)) { throw new System.Exception(errmsg); } if (!data.checkDataType(out errmsg)) { throw new System.Exception(errmsg); } switch (fmt) { case TableExportFormat.Dat: { exportPath = Path.Combine(exportDir, string.Format("{0}.exdat", Path.GetFileNameWithoutExtension(filePath))); TableExcelExportDat.exportExcelFile(data, exportPath); } break; case TableExportFormat.Json: { // export json exportPath = Path.Combine(exportDir, string.Format("{0}.json", Path.GetFileNameWithoutExtension(filePath))); TableExcelExportJson.exportExcelFile(data, exportPath); // export cs string fileName = Path.GetFileNameWithoutExtension(filePath); fileName = fileName.Substring(0, 1).ToUpper() + fileName.Substring(1); exportPath = Path.Combine(exportDir, string.Format($"{ fileName }.cs")); TableExcelExportCs.ExportExcelFile(data, exportPath); // export csEx exportPath = Path.Combine(exportDir, string.Format($"{ fileName }.Ex.cs")); if (!File.Exists(exportPath)) { TableExcelExportCsEx.ExportExcelFile(data, exportPath, fileName); } } break; case TableExportFormat.Xml: { exportPath = Path.Combine(exportDir, string.Format("{0}.xml", Path.GetFileNameWithoutExtension(filePath))); TableExcelExportXml.exportExcelFile(data, exportPath); } break; case TableExportFormat.Lua: { exportPath = Path.Combine(exportDir, string.Format("{0}.lua", Path.GetFileNameWithoutExtension(filePath))); if (AppData.Config.FitUnity3D == true) { exportPath += ".txt"; } TableExcelExportLua.exportExcelFile(data, exportPath); } break; } Log.Msg("----------导出成功 {0} ----------", exportPath); return(true); } catch (System.Exception ex) { Log.Err(ex.Message); Log.Err("----------导出失败 {0} ----------", exportPath); return(false); } }