Files
27-combi/generate_excel.bat

54 lines
1.2 KiB
Batchfile
Raw Permalink Normal View History

@echo off
REM Windows batch script to generate DeFi_Collateral_Simulation.xlsx
REM Check if virtual environment exists
if not exist "venv" (
echo Creating virtual environment...
python -m venv venv
if errorlevel 1 (
echo.
echo ERROR: Failed to create virtual environment
echo Please install Python first
pause
exit /b 1
)
)
REM Activate virtual environment
echo Activating virtual environment...
call venv\Scripts\activate.bat
REM Install xlsxwriter in virtual environment
echo Installing xlsxwriter...
python -m pip install --quiet --upgrade pip
python -m pip install --quiet xlsxwriter
if errorlevel 1 (
echo.
echo ERROR: Failed to install xlsxwriter
echo Please install Python and pip first
call venv\Scripts\deactivate.bat
pause
exit /b 1
)
echo.
echo Generating DeFi_Collateral_Simulation.xlsx...
python generate_defi_simulation.py
if errorlevel 1 (
echo.
echo ERROR: Failed to generate workbook
call venv\Scripts\deactivate.bat
pause
exit /b 1
)
call venv\Scripts\deactivate.bat
echo.
echo SUCCESS: DeFi_Collateral_Simulation.xlsx has been generated!
echo.
pause