Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!feeds.phibee-telecom.net!newsfeed.xs4all.nl!newsfeed3a.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail
Return-Path: <ian.g.kelly@gmail.com>
X-Original-To: python-list@python.org
Delivered-To: python-list@mail.python.org
X-Spam-Status: OK 0.015
X-Spam-Evidence: '*H*': 0.97; '*S*': 0.00; 'python,': 0.02; 'subject:Windows': 0.02; 'subject:using': 0.09; 'macro.': 0.16; 'patil': 0.16; 'side.': 0.16; 'subject:GUI': 0.16; 'subject:python': 0.16; 'files.': 0.16; 'wrote:': 0.18; 'input': 0.22; 'file.': 0.24; 'this:': 0.26; 'excel': 0.26; 'header:In- Reply-To:1': 0.27; 'array': 0.29; 'message-id:@mail.gmail.com': 0.30; 'with,': 0.31; 'file': 0.32; 'another': 0.32; 'could': 0.34; 'something': 0.35; 'test': 0.35; 'but': 0.35; 'received:google.com': 0.35; 'doing': 0.36; 'implement': 0.38; 'to:addr:python-list': 0.38; 'files': 0.38; 'pm,': 0.38; 'sure': 0.39; 'to:addr:python.org': 0.39; 'how': 0.40; 'consists': 0.60; 'then,': 0.60; 'entire': 0.61; 'back': 0.62; 'more': 0.64; 'skip:w 30': 0.69
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type:content-transfer-encoding; bh=64Ozodf1e52yhECLAkb6vQAqEP0E/CxRutr2+fyRQ1Q=; b=Ri54wZg+xyInINM9+qN+KfSr+8K8CQodBveUE8IMh6PVwUQAGwjACsHe80+Okxeg7i ODs67oqgltj+2u1EKXsAtlksLZveqyU18MVcAcv8MayKmCO3kRyF7wtWLJ7Ab31P7MwM 3TuxvuV5AzZhBgznGZHJqCeuWDnfRL6JVFvRMiPDhAj1uPU3gzgRZsqRt/QxVw1VDUyb uQJmx53peV/NI73HTd8ATViojopzmz4eekXozEnkRhvjtRiA/epaUCOZWIsZIacwWCoH cYjM0kIB1pGWInEc9ne/g+yDbkOEMYVIE78LAL2P1Yw4tF6VoShxcQrkalKpRsWM9BtK 0eUQ==
X-Received: by 10.236.229.133 with SMTP id h5mr70265629yhq.64.1401857948342; Tue, 03 Jun 2014 21:59:08 -0700 (PDT)
MIME-Version: 1.0
In-Reply-To: <fee30f59-a010-4a05-b42f-2bfb60c51712@googlegroups.com>
References: <0d04724b-d800-407f-9614-1a86c4a58769@googlegroups.com> <mailman.10590.1401772221.18130.python-list@python.org> <a0ff3687-7d33-4748-8666-359a694cacd4@googlegroups.com> <mailman.10599.1401779421.18130.python-list@python.org> <bf3b983f-81bd-420d-9296-962591608717@googlegroups.com> <mailman.10630.1401809255.18130.python-list@python.org> <fee30f59-a010-4a05-b42f-2bfb60c51712@googlegroups.com>
From: Ian Kelly <ian.g.kelly@gmail.com>
Date: Tue, 3 Jun 2014 22:58:28 -0600
Subject: Re: Lock Windows Screen GUI using python
To: Python <python-list@python.org>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
X-BeenThere: python-list@python.org
X-Mailman-Version: 2.1.15
Precedence: list
List-Id: General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe: <https://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive: <http://mail.python.org/pipermail/python-list/>
List-Post: <mailto:python-list@python.org>
List-Help: <mailto:python-list-request@python.org?subject=help>
List-Subscribe: <https://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups: comp.lang.python
Message-ID: <mailman.10676.1401857956.18130.python-list@python.org>
Lines: 20
NNTP-Posting-Host: 2001:888:2000:d::a6
X-Trace: 1401857956 news.xs4all.nl 2965 [2001:888:2000:d::a6]:41338
X-Complaints-To: abuse@xs4all.nl
Xref: csiph.com comp.lang.python:72591

On Tue, Jun 3, 2014 at 9:55 PM, Jaydeep Patil <patil.jay2009@gmail.com> wro=
te:
> Hi lan,
>
> For plotting one graph, I need to use four to five excel files. Currently=
 I am reading excel files one by one and copy data of excel files to anothe=
r single master excel file. This master excel file consists of all data fro=
m all input excel files. So this is the reason i am using system clipboard.

I don't currently have Excel around to test with, but I think you
could do something like this:

wb1.Sheets(1).Range("A1:F100").Value =3D wb2.Sheets(1).Range("A1:F100").Val=
ue

Not sure how efficient this is -- I envision it serializing an entire
array of data to send over COM to Python, only to send it right back
again at the other side.  But then, the clipboard would be doing more
or less the same thing.  It might be more efficient to implement the
above as a macro in Excel and then just call the macro.