现在的位置: 首页英文图书, 软件>正文
Python for Excel
图书分类:英文图书, 软件 暂无评论 ⁄ 被围观 554 次阅读+

Description:

While Excel remains ubiquitous in the business world, recent Microsoft feedback forums are full of requests to include Python as an Excel scripting language-in fact, it’s the top feature requested. What makes this combination so compelling? In this hands-on guide, Felix Zumstein- creator of xlwings, a popular open source package that allows the automation of Excel with Python-shows experienced Excel users how to integrate these two worlds efficiently.

Excel has added quite a few new capabilities over the past couple of years, but its automation language, VBA, stopped evolving a long time ago. Many Excel power users have already adopted Python for their daily automation tasks. This guide gets you started.

  • Use Python without extensive programming knowledge
  • Get started with modern tools, including Jupyter notebooks and Visual Studio Code
  • Use pandas to acquire, clean, and analyze data and replace typical Excel calculations
  • Automate tedious tasks like consolidation of Excel workbooks and production of Excel reports
  • Use xlwings to build interactive Excel tools that use Python as a calculation engine
  • Connect Excel to databases and CSV files and fetch data from the internet using Python code
  • Use Python as a single tool to replace VBA, Power Query and Power Pivot

 

Author: Felix Zumstein
Length: 315 pages
Edition: 1
Language: English
Publisher: O’Reilly Media
Publication Date: 2021-08-17
ISBN-10: 1492081000
ISBN-13: 9781492081005

标签:, , ,

你可能喜欢

0 0 投票数
文章评分
订阅评论
提醒
0 评论
内联反馈
查看所有评论