在excel表格添加vba代码
Private Sub Workbook_BeforeSave(ByVal SaveAsUi As Boolean, Cancel As Boolean)
Shell ActiveWorkbook.Path & "/win_startExcelExport.bat " & ActiveWorkbook.Path
End Sub
把win_startExcelExport.bat改为
cd %1
cd /d ../Bin
dotnet Server.dll --AppType=ExcelExporter
Server/Model/ExcelExporter/ExcelExporter.cs脚本80行[导表成功]后添加
Console.WriteLine("导表成功!");
Process.GetCurrentProcess().Kill();//新增
每次保存excel都会自动导表,再也不用担心策划忘了导表了