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.jay2...@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.
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.
self.ws = ws
startRowPaste = self.headerRow
self.col = self.getColToPaste(ws)
rngPaste = ws.Cells( startRowPaste, self.col)
rngCopy = self.datafile.ws.Cells(self.datafile.headerRow,self.colCopy)
rngCopy = self.datafile.ws.Range(rngCopy,rngCopy.End(util.Xl.xlDown))
self.dataRange = self.getDataRange()