Ok, so I have this program I am working on that uses Excel.au3, it handles with excel files that have around 10,000 rows. Now, I had an older version of AutoIT (forgot it, but it was downloaded in 2010) and then just decided to update today, and now the above stated function takes about 10 minutes to go through, where before it only took about a minute and a half. Why is it taking so much longer now?
Thanks.
Excel.au3 _ExcelReadSheetToArray Slower In New AutoIT Than Old?
Started by
Rux
, Jul 07 2012 06:45 AM
6 replies to this topic
#2
water
-
- MVPs
-
- 10,693 posts
?
Posted 07 July 2012 - 07:35 AM
Which version did you use before, which do you use now?
UDFs:
Active Directory (2012-10-12 - Version 1.3.0.0 released) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2012-10-07 - Version 0.9.0.0 released) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2013-01-21 - Version 0.3.1.1 released) - Download - General Help & Support - Example Scripts
WordEX (2012-12-29 - Version 1.3 released) - Download
ExcelEX (2013-05-11 - Alpha 4 released) - Download
#3
trancexx
-
- Active Members
-
- 5,192 posts
Hm, I really shouldn't.
Posted 07 July 2012 - 08:01 AM
That function is badly written. There is one bug report directly related to it. Even suggested alternative.
eMyvnE
#4
Rux
-
- Active Members
- 39 posts
Seeker
Posted 07 July 2012 - 08:52 PM
Which version did you use before, which do you use now?
I used 3.3.6.1 before, now I use the newest one, which is 3.3.8.1.
That function is badly written. There is one bug report directly related to it. Even suggested alternative.
Alternative? Does that mean I have to make my own function that does this?
#5
water
-
- MVPs
-
- 10,693 posts
?
Posted 07 July 2012 - 09:19 PM
No. Have a look at this ticket and you'll find a modified version of the function.
UDFs:
Active Directory (2012-10-12 - Version 1.3.0.0 released) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2012-10-07 - Version 0.9.0.0 released) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2013-01-21 - Version 0.3.1.1 released) - Download - General Help & Support - Example Scripts
WordEX (2012-12-29 - Version 1.3 released) - Download
ExcelEX (2013-05-11 - Alpha 4 released) - Download
#6
Rux
-
- Active Members
- 39 posts
Seeker
Posted 07 July 2012 - 09:43 PM
Wow, thanks! That function reduced the loading time to around 2-3 seconds!
#7
water
-
- MVPs
-
- 10,693 posts
?
Posted 08 July 2012 - 06:10 AM
UDFs:
Active Directory (2012-10-12 - Version 1.3.0.0 released) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2012-10-07 - Version 0.9.0.0 released) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2013-01-21 - Version 0.3.1.1 released) - Download - General Help & Support - Example Scripts
WordEX (2012-12-29 - Version 1.3 released) - Download
ExcelEX (2013-05-11 - Alpha 4 released) - Download
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users
