Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #72591

Re: Lock Windows Screen GUI using python

References (2 earlier) <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 2014-06-03 22:58 -0600
Subject Re: Lock Windows Screen GUI using python
Newsgroups comp.lang.python
Message-ID <mailman.10676.1401857956.18130.python-list@python.org> (permalink)

Show all headers | View raw

On Tue, Jun 3, 2014 at 9:55 PM, Jaydeep Patil <patil.jay2009@gmail.com> wrote:
> 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 another single master excel file. This master excel file consists of all data from 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 = wb2.Sheets(1).Range("A1:F100").Value

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.

Back to comp.lang.python | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Lock Windows Screen GUI using python Jaydeep Patil <patil.jay2009@gmail.com> - 2014-06-02 21:28 -0700
  Re: Lock Windows Screen GUI using python Ian Kelly <ian.g.kelly@gmail.com> - 2014-06-02 23:09 -0600
    Re: Lock Windows Screen GUI using python Jaydeep Patil <patil.jay2009@gmail.com> - 2014-06-02 23:40 -0700
      Re: Lock Windows Screen GUI using python Ian Kelly <ian.g.kelly@gmail.com> - 2014-06-03 01:09 -0600
        Re: Lock Windows Screen GUI using python Jaydeep Patil <patil.jay2009@gmail.com> - 2014-06-03 00:53 -0700
          Re: Lock Windows Screen GUI using python Mark Lawrence <breamoreboy@yahoo.co.uk> - 2014-06-03 09:05 +0100
          Re: Lock Windows Screen GUI using python Chris Angelico <rosuav@gmail.com> - 2014-06-03 19:11 +1000
          Re: Lock Windows Screen GUI using python Ian Kelly <ian.g.kelly@gmail.com> - 2014-06-03 09:27 -0600
            Re: Lock Windows Screen GUI using python Jaydeep Patil <patil.jay2009@gmail.com> - 2014-06-03 20:55 -0700
              Re: Lock Windows Screen GUI using python Ian Kelly <ian.g.kelly@gmail.com> - 2014-06-03 22:58 -0600
                Re: Lock Windows Screen GUI using python Jaydeep Patil <patil.jay2009@gmail.com> - 2014-06-03 22:44 -0700
                Re: Lock Windows Screen GUI using python Ian Kelly <ian.g.kelly@gmail.com> - 2014-06-04 00:02 -0600
              Re: Lock Windows Screen GUI using python Chris Angelico <rosuav@gmail.com> - 2014-06-04 21:21 +1000
              Re: Lock Windows Screen GUI using python Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2014-06-04 22:04 -0400

csiph-web