Lock Windows Screen GUI using python

[Jaydeep Patil]

On Wednesday, 4 June 2014 10:28:28 UTC+5:30, Ian  wrote:
> On Tue, Jun 3, 2014 at 9:55 PM, Jaydeep Patil <patil.jay2009 at 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.

Hi lan,

Below is the sample function which doing copy paste in my case.
I am copying data directly by column, not reading each & every value.
Data is too big in heavy.

def copyPaste(self,ws):
        # todo
        self.ws = ws 
        
        startRowPaste = self.headerRow
        self.col = self.getColToPaste(ws)
        rngPaste = ws.Cells( startRowPaste, self.col)
        
        self.datafile.openDataFile()
        self.datafile.ws.Activate()
        rngCopy = self.datafile.ws.Cells(self.datafile.headerRow,self.colCopy)
        rngCopy = self.datafile.ws.Range(rngCopy,rngCopy.End(util.Xl.xlDown))
        
        rngCopy.Copy()
        
        ws.Activate()
        ws.Paste(Destination=rngPaste)
        
        self.dataRange = self.getDataRange()
        self.datafile.closeDataFile()
        pass