Dealing with multiple excel sheets

[kyosohma at gmail.com]

On Aug 7, 1:05 pm, Rohan <vodela.... at gmail.com> wrote:
> Hello,
> I would like to write a script which does the following job.
> Take column1 and 7 from 10 different excel sheets and pasthe them into
> a new excel worksheet.
> Any ideas on how to do it
> Thanks,

Try studying this code:

http://snippets.dzone.com/posts/show/2036

or this:

http://www.oreilly.com/catalog/pythonwin32/chapter/ch12.html

or this:

http://mathieu.fenniak.net/plotting-in-excel-through-pythoncom/

Learning COM objects can be fun...or it can be a pain, depending on
your attitude and what you're trying to automate.

Mike