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
Garrett said,
Wrote on March 20, 2011 @ 11:27 pm
I have written a module for python to interface with excel (and Gnumeric and eventually Open Office) Worksheets natively. Check it out here:
https://sourceforge.net/projects/pyworkbooks/files/
Garrett said,
Wrote on March 21, 2011 @ 9:58 pm
I also recommend the PyWorkbooks project, which I have recently written and is in Beta — it works well and has documentation for beginners.
PyWorkbooks is a module to treat open Excel or Gnumeric files (and eventually Open Office) as native python objects, and interface with them using standard calls. (i.e. B[[1, :10] will get you the first 10 points of data on row 1, the same as B[’A2:J2′], both are valid), and change it using standard calls as well.
check out the source, distutils install file, and documentation here:
http://sourceforge.net/projects/pyworkbooks/
Garrett said,
Wrote on March 21, 2011 @ 10:00 pm
Crap, doing a little too much evangelizing lately. Sorry for the double post.