[Python-talk] Excel vs. SQLite w Python ?

[Bill Sconce]

On Sun, 18 May 2008 13:34:55 -0400
"Ben Scott" <dragonhawk at gmail.com> wrote:

> > Thinking further about this, I wondered if there was a Python module
> > that interfaces Excel (or perhaps Perl) ?
> 
>   As someone else already mentioned, you can use Python to script
> Excel by using Python to access the COM interfaces Excel exposes.
> Basically, you'd be able to do the same things VBA does -- just
> without the fancy IDE.

This is one of those things which you write a dozen lines of code,
Excel speaks to you and does your bidding, and you say "I can't
believe it was that easy".

[Assuming:
   1. You steal working code(*).
      As from Mark Hammond.
      (You do want a *certain* dozen lines of code,
      namely working code...  :)
   2. You want to have, or have to have, that Microsoft box anyway.
]

-Bill


(*) class EasyExcel
        """A utility to make it easier to get at Excel."""
        ...
    
    _Python Programming on Win32_, ISBN 1-56592-621-8
    Mark Hammond and Andy Robinson
    O'Reilly
    January 2000 (1st edition)  p. 149