how can i merge 2 excels into one?
The group you are posting to is a
Usenet group . Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
From:
honestkent <honestk... @gmail.com>
Date: Sat, 17 Oct 2009 16:40:05 -0700 (PDT)
Local: Sun, Oct 18 2009 9:40 am
Subject: how can i merge 2 excels into one?
python-excel can copy a excel an modify it, but use copy cann't merge
2 sheets from different xls files, how to to do?
You must
Sign in before you can post messages.
You do not have the permission required to post.
From:
Jacob Fenwick <jacob.fenw... @gmail.com>
Date: Sun, 18 Oct 2009 11:55:58 -0400
Local: Mon, Oct 19 2009 1:55 am
Subject: Re: [pyxl] how can i merge 2 excels into one?
Extract the data from the two sheets using xlrd and then create a new sheet
that merges the data using xlwt.
On Sat, Oct 17, 2009 at 7:40 PM, honestkent <honestk
... @gmail.com> wrote:
> python-excel can copy a excel an modify it, but use copy cann't merge
> 2 sheets from different xls files, how to to do?
You must
Sign in before you can post messages.
You do not have the permission required to post.
From:
曾进 <honestk... @gmail.com>
Date: Mon, 19 Oct 2009 08:51:03 +0800
Local: Mon, Oct 19 2009 10:51 am
Subject: Re: [pyxl] Re: how can i merge 2 excels into one?
How to copy the 2 sheets from 2 excel into 1excel have 2 sheets? Is there
have any way like copy method?
2009/10/18 Jacob Fenwick <jacob.fenw... @gmail.com>
> Extract the data from the two sheets using xlrd and then create a new sheet
> that merges the data using xlwt.
> On Sat, Oct 17, 2009 at 7:40 PM, honestkent <honestk... @gmail.com> wrote:
>> python-excel can copy a excel an modify it, but use copy cann't merge
>> 2 sheets from different xls files, how to to do?
You must
Sign in before you can post messages.
You do not have the permission required to post.
From:
Roger Erens <ro... @erens-krekels.net>
Date: Mon, 19 Oct 2009 21:02:15 +0200
Local: Tues, Oct 20 2009 5:02 am
Subject: Re: [pyxl] Re: how can i merge 2 excels into one?
Hi 曾进,
On Mon, Oct 19, 2009 at 02:51, 曾进 <honestk
... @gmail.com> wrote:
> How to copy the 2 sheets from 2 excel into 1excel have 2 sheets? Is there
> have any way like copy method?
Extract the data from the two sheets using xlrd and then create two
new sheets that contain the data using xlwt.
What did you try, by the way, and what were the difficulties you experienced? Maybe the tutorial could help you (specifically page 22), see the website at http://www.python-excel.org/ where a link to it can be found.
Cheers,
Roger
You must
Sign in before you can post messages.
You do not have the permission required to post.
From:
Chris Withers <ch... @simplistix.co.uk>
Date: Tue, 20 Oct 2009 15:44:21 +0100
Local: Wed, Oct 21 2009 12:44 am
Subject: Re: [pyxl] how can i merge 2 excels into one?
honestkent wrote: > python-excel can copy a excel an modify it,
I'm guessing you mean xlutils.copy and xlwt here?
> but use copy cann't merge > 2 sheets from different xls files, how to to do?
I'd love for xlutils.filter to grow this ability, but it would require a
total rewrite and new APIs... I need funded time to do that :-(
Chris
-- Simplistix - Content Management, Batch Processing & Python Consulting - http://www.simplistix.co.uk
You must
Sign in before you can post messages.
You do not have the permission required to post.
From:
曾进 <honestk... @gmail.com>
Date: Wed, 21 Oct 2009 08:51:29 +0800
Local: Wed, Oct 21 2009 10:51 am
Subject: Re: [pyxl] Re: how can i merge 2 excels into one?
Thank you very much.
xlutils.copy only can copy one excel to a new. My requirement is copy some
sheets from many excels to one excel, or copy some rows to a new excel
sheet.
It seems not easy to do it.
2009/10/20 Chris Withers <ch... @simplistix.co.uk>
> honestkent wrote:
> > python-excel can copy a excel an modify it,
> I'm guessing you mean xlutils.copy and xlwt here?
> > but use copy cann't merge
> > 2 sheets from different xls files, how to to do?
> I'd love for xlutils.filter to grow this ability, but it would require a
> total rewrite and new APIs... I need funded time to do that :-(
> Chris
> --
> Simplistix - Content Management, Batch Processing & Python Consulting
> - http://www.simplistix.co.uk
You must
Sign in before you can post messages.
You do not have the permission required to post.
From:
Chris Withers <ch... @simplistix.co.uk>
Date: Tue, 27 Oct 2009 16:07:55 +0000
Local: Wed, Oct 28 2009 3:07 am
Subject: Re: [pyxl] Re: how can i merge 2 excels into one?
?? wrote: > Thank you very much. > xlutils.copy only can copy one excel to a new. My requirement is copy > some sheets from many excels to one excel,
Yes, hence my cunning phrasing:
>I'd love for xlutils.filter to grow this ability, but it would require > a total rewrite and new APIs... I need funded time to do that :-(
> or copy some rows to a new > excel sheet.
This can be done already.
Chris
-- Simplistix - Content Management, Batch Processing & Python Consulting - http://www.simplistix.co.uk
You must
Sign in before you can post messages.
You do not have the permission required to post.