May 2026
Intermediate
418 pages
5h 50m
Chinese
Overview
本作品已使用人工智能进行翻译。欢迎您提供反馈和意见：translation-feedback@oreilly.com
几乎所有行业的专业人员都使用 Excel 来创建强大的工具，以快速适应瞬息万变的环境。但 Excel 的自动化语言 VBA 很久以前就停止了发展。另一方面，Python 的普及率已达到爆炸式的增长，因此微软官方对 Python 的整合也就不足为奇了。这本经过全面修订的实战指南可以帮助你使用 Python 释放 Excel 的全部潜能。
分析师、工程师、数据科学家和其他高级用户将学习如何利用微软的 Python in Excel 功能扩展 Excel 强大的分析引擎。借助 Excel 的 AI Copilot 工具，即使是 Python 新手也能轻松完成高级任务。作者 Felix Zumstein 是广受欢迎的开源软件包 xlwings 的创建者，他还深入探讨了包括 xlwings 和 OpenPyXL 在内的补充解决方案，这些解决方案可以充分利用 Excel 和 Python 的组合功能。
- 学习如何使用 Python 的核心功能
- 开始使用现代工具，包括 Jupyter 笔记本和 Visual Studio Code
- 应用强大的 pandas 命令获取、清理和分析数据
- 通过 Excel 中的 pandas，在 Excel 中使用 Python，使用高级分析方法
- 使用 xlwings 和 OpenPyXL，用 Python 处理 Excel 文件
- 使用 xlwings 和 xlwings Lite，用 Python 实现 Excel 自动化
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.