Show HN: Script Excel with Python • Hacker News Board

Re: Show HN: Script Excel with Python

#51

Post by jijoy » Sat, Jun 09, 2012, 6:42 AM UTC

This is awesome. Great Work !!

Re: Show HN: Script Excel with Python

#52

Post by DeepDuh » Sat, Jun 09, 2012, 8:29 AM UTC

cheez wrote: post #36

karamazov wrote: post #21

Earlier quoted context omitted.

Glad you like it! We're also backwards compatible - you can keep running old VBA code, and write new scripts in Python.

Wow, backwards compatible?! That's awesome. That must have taken some serious COM magic.

Could you elaborate? Why shouldn't two script engines run alongside each other, as long as it's not at the same time on the same data?

Re: Show HN: Script Excel with Python

#53

Post by edwinyzh » Sat, Jun 09, 2012, 12:05 PM UTC

This is very interesting! Wrapping the entire Excel object model in Python must be a huge work.

Re: Show HN: Script Excel with Python

#54

Post by asto » Sat, Jun 09, 2012, 12:46 PM UTC

Calligra Sheets allows scripting with python, ruby and js!

http://en.wikipedia.org/wiki/Calligra_Sheets

Re: Show HN: Script Excel with Python

#55

Post by cheez » Sat, Jun 09, 2012, 3:40 PM UTC

DeepDuh wrote: post #52

cheez wrote: post #36

Earlier quoted context omitted.

Wow, backwards compatible?! That's awesome. That must have taken some serious COM magic.

Could you elaborate? Why shouldn't two script engines run alongside each other, as long as it's not at the same time on the same data?

I was under the impression that it meant you can call into VBA from Python and vice versa.

Re: Show HN: Script Excel with Python

#56

Post by jimberino » Sat, Jun 09, 2012, 10:14 PM UTC

shazam wrote: post #23

That's funny, I just used xlrd and xlrt and had to convert about 100 files to 97-2003 workbooks

XLRD and XLRT look awesome - esp. for us *nix minded folks who prefer to interact with xls files from a shell, http://www.python-excel.org/

Re: Show HN: Script Excel with Python

#57

Post by AlexDanger » Sun, Jun 10, 2012, 4:37 AM UTC

This is great. I have to work with some very complex excel/VBA apps and this will be a breath of fresh air.

Is there anything out there that allows using C# to script/control excel?

Re: Show HN: Script Excel with Python

#58

Post by Pyinex » Sun, Jun 10, 2012, 12:51 PM UTC

Done two years ago:

Code.google.com/p/pyinex

O.83 alpha version includes the code.

Re: Show HN: Script Excel with Python

#59

Post by fonzie » Sun, Jun 10, 2012, 2:05 PM UTC

This seems pretty great. Any plans for compatibility with Excel 2003 and 2007?

Re: Show HN: Script Excel with Python

#60

Post by karamazov » Mon, Jun 11, 2012, 12:15 AM UTC

fonzie wrote: post #59

This seems pretty great. Any plans for compatibility with Excel 2003 and 2007?

We'll be compatible with 2007 in a day or two. We're not currently planning on supporting 2003, but this might change.