利用Python操作VBA
下面是我们本周的新视频,想要及时收看我们发布的视频,不要忘了点赞关注订阅我们的YouTube频道哦!
How To Use Python’s Pandas With The VBA Library
Link
Summary: Pandas is a powerful Python library that allows us to transform and analyze large amounts of data quickly. In this video, we explore how to use Pandas alongside the VBA library in Python. This will allow us to seamlessly transfer data to Pandas, transform it, and sent it right back to Excel without ever having to close our workbook.
Pandas是一个功能强大的Python库,我们可以用来快速转换和分析大量数据。 在本视频中,我们将探讨如何在Python中使用Pandas和VBA库。 我们便可以将数据直接传输到Pandas,对其进行转换,并将其直接发送回Excel,而无需关闭我们的工作簿。
How To Make A Python API Request Using The Excel VBA Library
Link
Summary: APIs allow for a secure framework where users can request and send data as they please. However, working with APIs in Excel and VBA for that matter has always been challenging. Let’s add some new functionality to Excel by creating a way to send API data directly into an Excel Workbook using the VBA model in Python.
API构造了一个安全的框架,用户可以根据需要请求和发送数据。 但是,在Excel和VBA中使用API始终具有挑战性。 我们可以通过创建一种使用Python中的VBA模型将API数据直接发送到Excel工作簿的方法,为Excel添加一些新功能。
How To Run A Python Script Using Excel VBA
Link
Summary: In order to use the Python scripts that we create, we need to be able to execute them from within an Office application. This can be done using VBA, so in this video, we will go over how to execute a Python script using VBA.
为了使用我们创建的Python脚本,我们需要能够在Office应用程序中执行它们。 这可以使用VBA完成,因此在本视频中,我们将介绍如何使用VBA执行Python脚本。