Rux Posted July 7, 2012 Share Posted July 7, 2012 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. Link to comment Share on other sites More sharing options...
water Posted July 7, 2012 Share Posted July 7, 2012 Which version did you use before, which do you use now? My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
trancexx Posted July 7, 2012 Share Posted July 7, 2012 That function is badly written. There is one bug report directly related to it. Even suggested alternative. ♡♡♡ . eMyvnE Link to comment Share on other sites More sharing options...
Rux Posted July 7, 2012 Author Share Posted July 7, 2012 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? Link to comment Share on other sites More sharing options...
water Posted July 7, 2012 Share Posted July 7, 2012 No. Have a look at this ticket and you'll find a modified version of the function. My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Rux Posted July 7, 2012 Author Share Posted July 7, 2012 Wow, thanks! That function reduced the loading time to around 2-3 seconds! Link to comment Share on other sites More sharing options...
water Posted July 8, 2012 Share Posted July 8, 2012 My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now