Python & Excel
Chris Withers has just set up a website at: http://www.python-excel.org/ to act (if I understand correctly) as a sort of springboard for people who are looking for help in using Excel with Python. With that domain name, it might also become a company specialising in Python training I suppose. Chris points out that if you simply drop: python excel into Google or Bing.. or anywhere[*] you get a whole scatter of possibly useful pages but no clear focus of information.
The Python Excel Google Group has been in existence for a while now and people are pointed there from the Python mailing lists with a certain regularity but it doesn’t figure particularly highly in search engine results either. Hopefully the presence of python-excel.org will at least provide a focus for search engine enquiries.
[*] “Balham, Gateway to the South” (about 3:09)
Wrote on June 19, 2009 @ 10:16 am
Hey,
If you’re stuck with Excel, then you should check that out. But if you just want a spreadsheet that’s written in Python, has a document object model in Python, uses cell formulae in Python, allows arbitrary Python objects as values in cells, and lets you interweave arbitrary Python code (eg. function definitions) into your spreadsheet, then you should be using Resolver One (http://resolversystems.com). (Windows only)
Wrote on June 19, 2009 @ 10:19 am
Ohno! My ‘flagrant plug’ tags were stripped out!
tim said,
Wrote on June 19, 2009 @ 10:31 am
@Tartley: Don’t worry; I’m sure most people are capable of cutting-and-pasting a URL into their address bar. (It’s probably a Wordpress feature, btw, nothing I’ve done explicitly).
Wrote on June 19, 2009 @ 8:12 pm
Oh, thanks, but I didn’t even mean that - I had bracketted my whole first comment with <flagrant plug> tags
Hugs!
rick said,
Wrote on July 7, 2009 @ 5:40 pm
And unfortunately Resolver 1 is so slow to be almost unusable
Chris Withers said,
Wrote on July 8, 2009 @ 3:39 pm
That website will never be for a company, it’s to try and help people find the actively maintained libraries for working with excel files in python: xlrd, xlwt and xlutils.
(The companies who do this stuff really well are plugged at the bottom of the site ;-) )
Tony said,
Wrote on May 8, 2010 @ 3:00 pm
If you want to be able to call python functions from Excel as worksheet functions, menu items or macros you could take a look at PyXLL (www.pyxll.com).
cheers,
Tony