Header banner
Revain logoHome Page
Michael Miner photo
1 Level
757 Review
47 Karma

Review on PyXLL by Michael Miner

Revainrating 4 out of 5

Great tool and amazing community behind !

I am using it for work with excel files, so i need to check if everything is fine or not when working at office because of security issues which can cause problems sometimes but nothing serious as far my experience goes! Also adding new functions/tools would be great option once this product gets more users like other similar products that have been developed by many companies around us (py2excel). If you are looking something simple then just go ahead otherwise there's no harm doing some homework first before considering pyxll purchase!! It does what exactly its purpose about solving problem related data processing while maintaining privacy standards from any third party who has access through your file structure without compromising anything else than user interface level itself!! It is easy to use, it has some nice features like working with multiple sheets or other modules (like xlrd). The debugging can be sometimes tricky. I am not sure if there are any alternatives for this library that would have more support from Microsoft. We needed an addin to quickly access data stored in SQL Server databases using ODBC connection. This made our life easier because we could then write less code than what was required otherwise.

img 1 attached to PyXLL review by Michael Miner

ο»Ώ

Pros
  • Easy way out works well
  • Supports Python 3+ only.
  • No dependency whatsoever except python3 libraries used alongwith numpy & pandas packages; hence makes installation process very light weight compared most popular Excel Addins available today such OpenPyXL etc
Cons
  • Debugging takes time due non availabilityof good debugger tools