advanced code snippet search

Posted By

laurenceosx on 01/04/10


Tagged

ResolverOne


Versions (?)

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

 / Published in: DOS Batch
 
Expand | Embed | Plain Text 
  1. @rem Run Resolver One Spreadsheet Py File with same name as bat file
  2. @rem Laurence Toenjes Monday, January 04, 2010
  3.  
  4. @rem # RunAddNums.py for standalone mode
  5. @rem from resolverlib import RunWorkbook
  6. @rem import sys
  7. @rem wb = RunWorkbook( 'AddNums.rsl', {'param1': eval(sys.argv[1]), 'param2': eval(sys.argv[2]) } )
  8. @rem print wb['Sheet1'].A3
  9.  
  10. @SETLOCAL
  11.  
  12. @IF EXIST "%~dp0resolverlib" (
  13. GOTO :StandAloneMode
  14. )
  15.  
  16. @IF EXIST "%ProgramFiles(x86)%" (
  17. GOTO :ProgFileX86
  18. ) ELSE (
  19. GOTO :ProgFile
  20. )
  21.  
  22. :StandAloneMode
  23. @PUSHD "%~dp0"
  24. @SET r1home=%CD%
  25. @POPD
  26. @SET r1exe=%~dp0resolverlib\RSIronpython.exe
  27. @GOTO :Ready
  28.  
  29. :ProgFileX86
  30. @SET r1home=%ProgramFiles(x86)%\Resolver One
  31. @SET r1exe=%r1home%\bin\RSIronpython.exe
  32. @GOTO :Ready
  33.  
  34. :ProgFile
  35. @SET r1home=%ProgramFiles%\Resolver One
  36. @SET r1exe=%r1home%\bin\RSIronpython.exe
  37. @GOTO :Ready
  38.  
  39. :Ready
  40. "%r1exe%" "%~dpn0.py" %*
  41. @ENDLOCAL

Report this snippet  

Comments

RSS Icon Subscribe to comments
Posted By: laurenceosx on January 4, 2010

RunAddNums.py

from resolverlib import RunWorkbook import sys wb = RunWorkbook( 'AddNums.rsl', {'param1': eval(sys.argv[1]), 'param2': eval(sys.argv[1]) } ) print wb['Sheet1'].A3

You need to login to post a comment.