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 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - 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 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - 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 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - 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