gilest's comments

On: The story BCG offered me $16,000 not to tell

[gilest]

You can do almost exactly that in Resolver One (http://www.resolversystems.com/), which has got a Python console as well as allowing Python functions and Python syntax in the grid. It's a separate spreadsheet program, though, not an Excel plug-in.

Alternatively, there's PyXLL (http://www.pyxll.com/), which lets you write Excel user-defined functions in Python, but doesn't have a console.

(Full disclosure: I work for Resolver Systems.)

On: 2000-2009: Microsoft's Decade of Shattered Dreams

[gilest]

There are actually two third-party plugins for Excel that let you use IronPython for scripting to some degree: DiscoveryScript at http://www.xefion.com/getting_started_diss.html and PyXLL at http://www.pyxll.com/ -- I don't use either, though, so I can't comment on how good they are.

(BTW thanks for the kind words about Resolver One -- that's my day job :-)

[clofresh → gilest]

Sweet, thanks! I'll be sure to try them out. Np re: Resolver One. How is it working there? When are you guys gonna kill Microsoft already?? ;p

[gilest → clofresh]

Oh, it's tough -- crushing Microsoft beneath your feet is hard work ;-)

[echion → gilest]

I use PyXLL and it works great.