[python-win32] Python Excel - 2 workbooks affect each other [SEC=UNCLASSIFIED]

[Andrew MacIntyre]

[apologies for top post]

 

I'm far from an expert, or even experienced, in Excel however the term "paste" rings bells.  Behind the scenes, material in the clipboard has lots of metadata and a selection copied from one open workbook includes the references to that workbook so when you paste it Excel includes those references and effectively links the pasted to cells to the pasted from cells.  If you must use paste, then you will probably need to use "paste special" and select "values" - this should break the references back to the original source.

 

If you carefully look at the "formula" of a pasted cell, you might see how the source workbook & worksheet are identified - I know that this sort of thing is visible when using the "function wizard" with such Excel functions as VLOOKUP.

 

-------------------------> "These thoughts are mine alone!" <---------

Andrew MacIntyre           Operations Branch

tel:   +61 2 6219 5356     Communications Infrastructure Division

fax:   +61 2 6253 3277     Australian Communications & Media Authority

email: andrew.macintyre at acma.gov.au <mailto:andrew.macintyre at acma.gov.au>             http://www.acma.gov.au/ <http://www.acma.gov.au/> 

 

From: python-win32-bounces+andrew.macintyre=acma.gov.au at python.org [mailto:python-win32-bounces+andrew.macintyre=acma.gov.au at python.org] On Behalf Of Stefanie Lück
Sent: Tuesday, 1 March 2011 1:19 AM
To: python-win32 at python.org
Subject: [python-win32] Python Excel - 2 workbooks affect each other

 

Hello!

 

I have a strange excel behaviour if 2 workbooks are open. I'm trying to create an excel workbook with a bar chart from some data which comes from my wxPython program. If I paste the data into my program from any source except another excel file, everything works as expected. But if I copy the values from a source excel workbook into my program and then try to create a new excel workbook with a chart, the new workbook takes the data of the chart from the source workbook and not from the sheet I specified. This happens only if the data of the source workbook are still selected from the copy before, if I click into another cell, my new created workbook will use the data of its sheet which I specified.

 

Does anybody know what this could be? In my code I clearly specify to use the data of my new created worksheet. The name of the source workbook sheet is completely different. Looks like excel ignore it and use the currently selected data of any workbook. Is there a way to specify the Workbook and Worksheet, which I want to use? 

 

Any help would be appreciated!

Thanks,

Stefanie


NOTICE: This email message is for the sole use of the intended recipient(s) 
 and may contain confidential and privileged information. Any unauthorized 
 review, use, disclosure or distribution is prohibited. If you are not the 
 intended recipient, please contact the sender by reply email and destroy all 
 copies of the original message.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-win32/attachments/20110301/91fa0df4/attachment-0001.html>