41
|
1 @echo off
|
|
2
|
|
3 rem --------------------------
|
|
4 rem Config (make porori.json)
|
|
5 rem --------------------------
|
65
|
6 porori64.exe
|
41
|
7
|
|
8 rem --------------------------
|
|
9 rem Get Data (recent)
|
|
10 rem --------------------------
|
65
|
11 set ACCESS="C:\Program Files\Microsoft Office\Office15\MSACCESS.EXE"
|
41
|
12 set MDB=C:\Users\KAIGO\Desktop\Porori\export.mdb
|
65
|
13 set NCSV=C:\Users\KAIGO\Documents\nintei.csv
|
|
14 set ICSV=C:\Users\KAIGO\Documents\i.csv
|
|
15 set CCSV=C:\Users\KAIGO\Documents\c.csv
|
|
16 set TCSV=t.csv
|
|
17 set EXCELFILE=【被保険者番号 前0仕様追加後】受付台帳(R3.6.11最新).xlsm
|
41
|
18
|
|
19 %ACCESS% %MDB% /nostartup /x data
|
|
20
|
|
21 rem --------------------------
|
65
|
22 rem rem Excel 2 Csv
|
|
23 rem --------------------------
|
|
24 excelize.exe %EXCELFILE% > %TCSV%
|
|
25
|
|
26 rem --------------------------
|
41
|
27 rem Do Filter
|
|
28 rem --------------------------
|
65
|
29 porori64_go.exe %NCSV% %ICSV% %CCSV% %TCSV% > a.csv
|
41
|
30 start a.csv
|
|
31
|