- 1. It's an amazing combination of a spreadsheet application and an IronPython IDE.
- Resolver One shows a typical spreadsheet grid and a code box.
- Whatever you do with the grid is reflected in a generated code.
- In the code box you can write some code which manipulates the workbook object, all the changes are then displayed in the grid.
- Resolver One is now 1.0 !
- 2. You can create maintainable spreadsheets.
- Thanks to the two-ways synchronization a spreadsheet is actually a Python program.
- Thus, you can do everything that you can do with a program.
- Create modules, classes, methods.
- 3. It's probably the first time you can actually unit test your spreadsheet logic and furthermore do some refactoring on it!
- Once you split the logic into classes, you can easily test them using standard unit test tools.
- 4. Because now creating a spreadsheet is limited only by your imagination.
- Would you like to import/export a google spreadsheet?
- Maybe you'd prefer to load data from a database?
- You want to generate a chart?
- It's all limited only to IronPython capabilities.
- 5. It's easy to import your existing spreadsheet, script it with Python and export it back.
Then go and grab a copy of Resolver One
Oh, and did I mention it's free for non-commercial use?