PK’s Powers Checker Upgrade

I have now “upgraded” the Powers Checker application to use Microsoft’s ACE OLEDB library to load the Excel sheet as if it’s a database for querying, rather than using EPPlus to import the ExcelPackage one row at a time. This speeds up the startup of the application SUBSTANTIALLY, from something like five minutes to just a couple of seconds.

If anyone gets any errors running this new version, try installing the required Microsoft Access Database Engine 2010 Redistributable (https://www.microsoft.com/en-us/download/confirmation.aspx?id=13255) first, then try again. If you still can’t load it, contact me on the Homecoming forums, and I’ll look into it. I have saved the EPPlus method in the code as a backup in case this fails for most people. I’ve also updated the source code zip file with the latest version of the source code.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.