Gmail Calendar Documents Reader Web more »
Recently Visited Groups | Help | Sign in
Google Groups Home
how can i merge 2 excels into one?
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
  7 messages - Collapse all  -  Translate all to Translated (View all originals)
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:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
honestkent  
View profile  
 More options Oct 18, 9:40 am
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?

    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Jacob Fenwick  
View profile  
 More options Oct 19, 1:55 am
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.


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
曾进  
View profile  
 More options Oct 19, 10:51 am
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>


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Roger Erens  
View profile  
 More options Oct 20, 5:02 am
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


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Chris Withers  
View profile  
 More options Oct 21, 12:44 am
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


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
曾进  
View profile  
 More options Oct 21, 10:51 am
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>


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Chris Withers  
View profile  
 More options Oct 28, 3:07 am
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


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2009 Google