Performance becomes an issue with large datasets too. A poorly written macro can bog down Excel and take forever to complete, ...

Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.

Integration for Jupyter notebooks and Microsoft Excel. See the Python Jupyter Notebooks in Excel blog post for more details. Once installed a "Jupyter Notebook" button will be added to the PyXLL ...

Easily create SQL queries and execute them on a database. For an example on how to use this library with data objects, see the VBA-Drupal-Library. For other examples on using the library, refer to the ...