Return to Snippet

Revision: 22159
at January 4, 2010 12:29 by laurenceosx


Updated Code
@rem Run Resolver One Spreadsheet Py File with same name as bat file
@rem Laurence Toenjes Monday, January 04, 2010

@rem # RunAddNums.py for standalone mode
@rem from resolverlib import RunWorkbook
@rem import sys
@rem wb = RunWorkbook( 'AddNums.rsl', {'param1': eval(sys.argv[1]), 'param2': eval(sys.argv[2]) } )
@rem print wb['Sheet1'].A3

@SETLOCAL

@IF EXIST "%~dp0resolverlib" (
GOTO :StandAloneMode
)

@IF EXIST "%ProgramFiles(x86)%" (
GOTO :ProgFileX86
) ELSE (
GOTO :ProgFile
)

:StandAloneMode
@PUSHD "%~dp0"
@SET r1home=%CD%
@POPD
@SET r1exe=%~dp0resolverlib\RSIronpython.exe
@GOTO :Ready

:ProgFileX86
@SET r1home=%ProgramFiles(x86)%\Resolver One
@SET r1exe=%r1home%\bin\RSIronpython.exe
@GOTO :Ready

:ProgFile
@SET r1home=%ProgramFiles%\Resolver One
@SET r1exe=%r1home%\bin\RSIronpython.exe
@GOTO :Ready

:Ready
"%r1exe%" "%~dpn0.py" %*
@ENDLOCAL

Revision: 22158
at January 4, 2010 12:24 by laurenceosx


Updated Code
@rem Run Resolver One Spreadsheet Py File with same name as bat file
@rem Laurence Toenjes Monday, January 04, 2010

@rem # RunAddNums.py for standalone mode
@rem from resolverlib import RunWorkbook
@rem import sys
@rem wb = RunWorkbook( 'AddNums.rsl', {'param1': eval(sys.argv[1]), 'param2': eval(sys.argv[1]) } )
@rem print wb['Sheet1'].A3

@SETLOCAL

@IF EXIST "%~dp0resolverlib" (
GOTO :StandAloneMode
)

@IF EXIST "%ProgramFiles(x86)%" (
GOTO :ProgFileX86
) ELSE (
GOTO :ProgFile
)

:StandAloneMode
@PUSHD "%~dp0"
@SET r1home=%CD%
@POPD
@SET r1exe=%~dp0resolverlib\RSIronpython.exe
@GOTO :Ready

:ProgFileX86
@SET r1home=%ProgramFiles(x86)%\Resolver One
@SET r1exe=%r1home%\bin\RSIronpython.exe
@GOTO :Ready

:ProgFile
@SET r1home=%ProgramFiles%\Resolver One
@SET r1exe=%r1home%\bin\RSIronpython.exe
@GOTO :Ready

:Ready
"%r1exe%" "%~dpn0.py" %*
@ENDLOCAL

Revision: 22157
at January 4, 2010 12:12 by laurenceosx


Updated Code
@rem Run Resolver One Spreadsheet Py File with same name as bat file
@rem Laurence Toenjes Monday, January 04, 2010

@SETLOCAL

@IF EXIST "%~dp0resolverlib" (
GOTO :StandAloneMode
)

@IF EXIST "%ProgramFiles(x86)%" (
GOTO :ProgFileX86
) ELSE (
GOTO :ProgFile
)

:StandAloneMode
@PUSHD "%~dp0"
@SET r1home=%CD%
@POPD
@SET r1exe=%~dp0resolverlib\RSIronpython.exe
@GOTO :Ready

:ProgFileX86
@SET r1home=%ProgramFiles(x86)%\Resolver One
@SET r1exe=%r1home%\bin\RSIronpython.exe
@GOTO :Ready

:ProgFile
@SET r1home=%ProgramFiles%\Resolver One
@SET r1exe=%r1home%\bin\RSIronpython.exe
@GOTO :Ready

:Ready
"%r1exe%" "%~dpn0.py" %*
@ENDLOCAL

Revision: 22156
at January 4, 2010 12:11 by laurenceosx


Updated Code
@rem Run Resolver One Spreadsheet Py File with same name as bat file

@SETLOCAL

@IF EXIST "%~dp0resolverlib" (
GOTO :StandAloneMode
)

@IF EXIST "%ProgramFiles(x86)%" (
GOTO :ProgFileX86
) ELSE (
GOTO :ProgFile
)

:StandAloneMode
@PUSHD "%~dp0"
@SET r1home=%CD%
@POPD
@SET r1exe=%~dp0resolverlib\RSIronpython.exe
@GOTO :Ready

:ProgFileX86
@SET r1home=%ProgramFiles(x86)%\Resolver One
@SET r1exe=%r1home%\bin\RSIronpython.exe
@GOTO :Ready

:ProgFile
@SET r1home=%ProgramFiles%\Resolver One
@SET r1exe=%r1home%\bin\RSIronpython.exe
@GOTO :Ready

:Ready
"%r1exe%" "%~dpn0.py" %*
@ENDLOCAL

Revision: 22155
at January 4, 2010 12:09 by laurenceosx


Initial Code
@rem Run Resolver One Spreadsheet Py File with same name as bat file

@SETLOCAL

@IF EXIST "%~dp0resolverlib" (
GOTO :StandAloneMode
)

@IF EXIST "%ProgramFiles(x86)%" (
GOTO :ProgFileX86
) ELSE (
GOTO :ProgFile
)

:StandAloneMode
@PUSHD
@SET r1home=%CD%
@POPD
@SET r1exe=%~dp0resolverlib\RSIronpython.exe
@GOTO :Ready

:ProgFileX86
@SET r1home=%ProgramFiles(x86)%\Resolver One
@SET r1exe=%r1home%\bin\RSIronpython.exe
@GOTO :Ready

:ProgFile
@SET r1home=%ProgramFiles%\Resolver One
@SET r1exe=%r1home%\bin\RSIronpython.exe
@GOTO :Ready

:Ready
"%r1exe%" "%~dpn0.py" %*
@ENDLOCAL

Initial URL


Initial Description


Initial Title
Run Resolver One Spreadsheet Py File with same name as bat file

Initial Tags


Initial Language
DOS Batch