Calling Python code from Excel with ExcelPython

最新推荐文章于 2020-10-29 20:19:12 发布

lk5423968

最新推荐文章于 2020-10-29 20:19:12 发布

阅读量267

点赞数

本文链接：https://blog.csdn.net/lymemoryzz/article/details/107135502

版权

ExcelPython是一个轻量级COM库，允许从Excel VBA调用Python代码和操作Python对象。通过它，你可以扩展Excel的功能，利用Python丰富的库和强大的语言特性。本文介绍了如何使用ExcelPython在Excel中运行Python代码。

摘要由CSDN通过智能技术生成

xcelPython is a lightweight COM library which enables you to call Python code and manipulate Python objects from Excel VBA.

Is your email address OK? You are signed up for our newsletters but your email address is either unconfirmed, or has not been reconfirmed in a long time. Please click here to have a confirmation email sent so we can confirm your email address and start sending you newsletters again. Alternatively, you can update your subscriptions.

Introduction

ExcelPython is a lightweight COM library which enables you to call Python code and manipulate Python objects from Excel VBA (or indeed any language supporting COM). In this article I will show you how this is done.

Background

Though its supremacy is being challenged by free (OpenOffice) or cloud (Google Sheets) alternatives, Excel remains the most widely used application for user-friendly computation and data processing in an office environment. Being able to call Python code from Excel vastly expands Excel's capabilities by leveraging the vast collection of libraries and powerful language features.

ExcelPython is an in-process COM library which enables you to load Python modules, call methods and manipulate objects. Other Python/Excel interfaces, such as PyXLL and Python-Excel, which are both excellent tools, differ from