%~d0 cd %~dsp0 @CALL remove.bat @SET EXCEL_FOLDER=%~dp0excelList @SET JSON_FOLDER=%~dp0json @SET EXE=%~dp0lib\excel2json.exe setlocal EnableDelayedexpansion set n=1 echo off ::@ECHO Converting excel files in folder %EXCEL_FOLDER% ... ::@CALL %EXE% --excel %EXCEL_FOLDER%\%%~nxi --json %JSON_FOLDER%\%%a.json --header 2 --a ::echo %EXCEL_FOLDER%\%%~nxi ::echo %JSON_FOLDER%\%%a.json ::set str=%%a ::set /a n+=1 ::echo ---------!n!-------------- ::echo !str:~0,3! for /f "delims=" %%i in ('dir /b /a-d /s %EXCEL_FOLDER%\*.xlsx') do ( for /f "tokens=1,2 delims=_ " %%a in ('echo %%~nxi') do ( set str=%%a if "!str:~0,3!"=="MAP" (@CALL %EXE% --excel %EXCEL_FOLDER%\%%~nxi --json %JSON_FOLDER%\%%a.json --header 2 ) else @CALL %EXE% --excel %EXCEL_FOLDER%\%%~nxi --json %JSON_FOLDER%\%%a.json --header 2 --a ) ) set SOURCE_DIR=.\json set DEST_DIR=..\assets\bundles\first\config xcopy "%SOURCE_DIR%" "%DEST_DIR%" /E /H /C /I /Y