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

[David Hutto]

On Mon, Feb 28, 2011 at 7:14 PM, Andrew MacIntyre
<Andrew.MacIntyre at acma.gov.au> wrote:
> [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

I'm not an expert on excel either, but isn't excel a file that can be
read in and parsed for tags?
> 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            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.
>
> _______________________________________________
> python-win32 mailing list
> python-win32 at python.org
> http://mail.python.org/mailman/listinfo/python-win32
>
>



-- 
According to theoretical physics, the division of spatial intervals as
the universe evolves gives rise to the fact that in another timeline,
your interdimensional counterpart received helpful advice from me...so
be eternally pleased for them.