How to Use .NET Class Library in Excel VBA. Your business's software developers can work with Microsoft's .NET framework to create powerful Excel macros for your spreadsheets. The .NET framework ...

That’s the concept behind Xlwings, a BSD-licensed Python library that connects to Excel and allows Excel spreadsheets and Python applications to interact directly.

Microsoft is adding the ability for customers to use their own data as a data type in Excel. Here's how this will work.