On Monday, 30 June 2014 18:16:21 UTC+5:30, Peter Otten wrote:
Jaydeep Patil wrote:
I have did excel automation using python.
In my code I am creating python dictionaries for different three columns
data at a time.There are are many rows above 4000. Lets have look in below
Jaydeep Patil wrote:
Dear Peter,
I have tested code written by you. But still it is taking same time.
Too bad ;(
If you run the equivalent loop written in Basic from within Excel -- is that
faster?
If you run the loop in Python with some made-up data instead of that fetched
from Excel --
On Tue, 01 Jul 2014 14:40:18 +0200, Peter Otten wrote:
What I'm trying to tell you: you need to put in some work to identify
the culprit...
His next question was how do I read a range from excel, please give me
an example
I gave him an example of using google to search for solutions to his
I have did excel automation using python.
In my code I am creating python dictionaries for different three columns data
at a time.There are are many rows above 4000. Lets have look in below function.
Why it is taking too much time?
Code:
def transientTestDict(self,ws,startrow,startcol):
Jaydeep Patil wrote:
I have did excel automation using python.
In my code I am creating python dictionaries for different three columns
data at a time.There are are many rows above 4000. Lets have look in below
function. Why it is taking too much time?
Code:
def
On Monday, June 30, 2014 1:32:23 PM UTC+2, Jaydeep Patil wrote:
I have did excel automation using python.
In my code I am creating python dictionaries for different three columns data
at a time.There are are many rows above 4000. Lets have look in below
function. Why it is taking too much
marco.naw...@colosso.nl wrote:
In the past I even dumped an EXCEL sheet as a
CSV file
That's probably the only way you'll speed things up
significantly. In my experience, accessing Excel via
COM is abysmally slow no matter how you go about it.
--
Greg
--