3 sheets tagged with "IronPython":

Use Resolver One Spreadsheets from IronPython Programs

RunWorkbook is a function that allows you to access Resolver One spreadsheets from other spreadsheets and access the data they contain. You can even pass in new data and effectively use spreadsheets as functions!

We can also use RunWorkbook to access Resolver One spreadsheets (.rsl files) from IronPython programs. RunWorkbook loads the spreadsheet and allows you to access the contents using the spreadsheet object model (using the same code you write in user code). You could use this for unit testing your spreadsheet logic or integrating your spreadsheets into your applications.

This zipfile includes a module that does all the necessary initialisation for you and brief instructions on how to use it.

06 March 2009. Tagged with IronPython, RunWorkbook

Test Driven Development of Spreadsheets

The RunWorkbook function allows you to load up Resolver One spreadsheets (.rsl files) from IronPython code. One use of this is for embedding the Resolver One calculation engine in .NET / IronPython applications without the user interface.

This example accompanies a Resolver Hacks article showing how we can use the Python testing library unittest in conjunction with IronPython and RunWorkbook to do Test Driven Development (unit testing) of spreadsheets.

This spreadsheet was created for the Resolver Hacks website, and not by Resolver Systems.

08 March 2009. Tagged with IronPython, resolverhacks, RunWorkbook, testing

Charting stock prices in 3D using Resolver One, OpenGL and Tao

A spreadsheet that uses Yahoo! Finance to download the close prices over the last two years for every stock that's currently in the Dow Jones index, then charts them in a 3D window which you can pan and zoom using the mouse.

20 November 2009. Tagged with .NET, 3d, charting, dow, finance, IronPython, jones, opengl, stock, tao, yahoo

<< Resolver Exchange