How to copy one xl sheet from diff workbook into another sheet of diff workbook?

[NikunjBadjatya]

Hi,
I have two xl files one.xls and two.xls,
both having two-two sheets namely (o1,o2) and (t1,t2) respectively.
I want to copy t2 sheet into o2 sheet. !!
Is there any way to do that?
Please help..!!
provide the suedo code if possible..!

Thanks,
Nikunj

[Chris Withers]

As mentioned a few times on this list, xlutils.copy is the closest thing
for this, but xlutils.filter, on which its based, doesn't support
filtering multiple files into one file.

You;d either need to fund a rewrite of xlutils.filter, or you can hack
up your own stuff, likely by subclassing xlutils.filter.BaseWriter, but
the problem comes from getting styles from multiple source files.

cheers,

Chris

--
Simplistix - Content Management, Batch Processing & Python Consulting
- http://www.simplistix.co.uk