Gmail Calendar Documents Reader Web more »
Recently Visited Groups | Help | Sign in
Google Groups Home
python-excel
Home
+ new post
Pages
Files
About this group
Join this group
Preserve graphs
Options
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
 
mconnors  
View profile  
 More options Nov 5, 2:00 am
From: mconnors <connor...@gmail.com>
Date: Wed, 4 Nov 2009 07:00:52 -0800 (PST)
Local: Thurs, Nov 5 2009 2:00 am
Subject: Preserve graphs
Reply | Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author
Hi,
Using XLRD and XLUtils:
Is it possible to open an excel file that contains graphs in sheet 1
and data in sheet2, and then modify sheet 2 and save it, without
losing the graphs in sheet 1?

    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.
John Machin  
View profile  
 More options Nov 5, 8:12 am
From: John Machin <sjmac...@lexicon.net>
Date: Thu, 05 Nov 2009 08:12:22 +1100
Local: Thurs, Nov 5 2009 8:12 am
Subject: Re: [pyxl] Preserve graphs
Reply | Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author
On 5/11/2009 2:00 AM, mconnors wrote:

> Hi,
> Using XLRD and XLUtils:
> Is it possible to open an excel file that contains graphs in sheet 1
> and data in sheet2, and then modify sheet 2 and save it, without
> losing the graphs in sheet 1?

Sorry, no. As the README says, xlrd skips over charts.

Regards,
John


    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.
Michael Connors  
View profile  
 More options Nov 5, 6:38 pm
From: Michael Connors <connor...@gmail.com>
Date: Thu, 5 Nov 2009 08:38:48 +0100
Local: Thurs, Nov 5 2009 6:38 pm
Subject: Re: [pyxl] Re: Preserve graphs
Reply | Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author

Ok, thanks, COM it is so.

2009/11/4 John Machin <sjmac...@lexicon.net>

> On 5/11/2009 2:00 AM, mconnors wrote:
> > Hi,
> > Using XLRD and XLUtils:
> > Is it possible to open an excel file that contains graphs in sheet 1
> > and data in sheet2, and then modify sheet 2 and save it, without
> > losing the graphs in sheet 1?

> Sorry, no. As the README says, xlrd skips over charts.

> Regards,
> John

--
Michael Connors
Burggravenlaan 148,
Leiden 2313 HZ,
The Netherlands

0031611520252


    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.
Mike  
View profile  
 More options Nov 5, 9:11 pm
From: Mike <mike.i.bradf...@gmail.com>
Date: Thu, 5 Nov 2009 02:11:39 -0800 (PST)
Local: Thurs, Nov 5 2009 9:11 pm
Subject: Re: Preserve graphs
Reply | Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author
I had to use COM for exactly the same reason.

If it helps I can post an example from what I did, which updates the
data in the Excel sheet from a CSV.

Cheers
Mike

On 5 Nov, 07:38, Michael Connors <connor...@gmail.com> wrote:


    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.
Michael Connors  
View profile  
 More options Nov 5, 9:16 pm
From: Michael Connors <connor...@gmail.com>
Date: Thu, 5 Nov 2009 11:16:20 +0100
Local: Thurs, Nov 5 2009 9:16 pm
Subject: Re: [pyxl] Re: Preserve graphs
Reply | Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author

> I had to use COM for exactly the same reason.

> If it helps I can post an example from what I did, which updates the
> data in the Excel sheet from a CSV.

> Cheers
> Mike

Yes please, that sounds extremely helpful.
--
Michael Connors
Leiden 2313 HZ,
The Netherlands

    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.
Mike  
View profile  
 More options Nov 6, 1:02 am
From: Mike <mike.i.bradf...@gmail.com>
Date: Thu, 5 Nov 2009 06:02:53 -0800 (PST)
Local: Fri, Nov 6 2009 1:02 am
Subject: Re: Preserve graphs
Reply | Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author
Hi

I've uploaded a zipfile called excelByComExample.zip.

Contains 3 files
- python script
- Excel file containing graph (in xlsx format)
- csv file containing new data
depending on where you unzip it you will need to change the filenames
in the python script.

However when you run it should see
- Excel file opens on sheet with graphs
- Graphs change as the data is overwritten
- Excel closes once it is saved under new filename.

Any problems let me know.

Must warn you am not a software developer, just somebody who does some
hacking because I'm lazy :-)

Mike

On Nov 5, 10:16 am, Michael Connors <connor...@gmail.com> wrote:


    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.
Michael Connors  
View profile  
 More options Nov 6, 3:35 am
From: Michael Connors <connor...@gmail.com>
Date: Thu, 5 Nov 2009 17:35:05 +0100
Local: Fri, Nov 6 2009 3:35 am
Subject: Re: [pyxl] Re: Preserve graphs
Reply | Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author

| I've uploaded a zipfile called excelByComExample.zip.

Thanks very much, that will save me some time.


    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