Zum Hauptinhalt springen Zur Suche springen Zur Hauptnavigation springen
Beschreibung

Professionals in nearly every industry use Excel to create powerful tools that can adapt quickly to fast-changing environments. But Excel's automation language, VBA, stopped evolving a long time ago. Python, on the other hand, has exploded in popularity, so Microsoft's official Python integration came as no surprise. This thoroughly revised hands-on guide helps you unlock Excel's full potential using Python.

Analysts, engineers, data scientists, and other power users will learn how to extend Excel's powerful analytics engine with Microsoft's Python in Excel feature. And with Excel's AI Copilot tool, even Python newbies can easily accomplish advanced tasks. Author Felix Zumstein--creator of the popular open source package xlwings--also dives into complementary solutions, including xlwings and OpenPyXL, that make the most of the combined capabilities of Excel and Python.

  • Learn how to use Python's core features
  • Get started with modern tools, including Jupyter notebooks and Visual Studio Code
  • Apply powerful pandas commands to acquire, clean, and analyze data
  • Use advanced analytics via pandas in Excel, using Python in Excel
  • Manipulate Excel files with Python, using xlwings and OpenPyXL
  • Automate Excel with Python, using xlwings and xlwings Lite

Professionals in nearly every industry use Excel to create powerful tools that can adapt quickly to fast-changing environments. But Excel's automation language, VBA, stopped evolving a long time ago. Python, on the other hand, has exploded in popularity, so Microsoft's official Python integration came as no surprise. This thoroughly revised hands-on guide helps you unlock Excel's full potential using Python.

Analysts, engineers, data scientists, and other power users will learn how to extend Excel's powerful analytics engine with Microsoft's Python in Excel feature. And with Excel's AI Copilot tool, even Python newbies can easily accomplish advanced tasks. Author Felix Zumstein--creator of the popular open source package xlwings--also dives into complementary solutions, including xlwings and OpenPyXL, that make the most of the combined capabilities of Excel and Python.

  • Learn how to use Python's core features
  • Get started with modern tools, including Jupyter notebooks and Visual Studio Code
  • Apply powerful pandas commands to acquire, clean, and analyze data
  • Use advanced analytics via pandas in Excel, using Python in Excel
  • Manipulate Excel files with Python, using xlwings and OpenPyXL
  • Automate Excel with Python, using xlwings and xlwings Lite
Über den Autor
Felix Zumstein is an independent software developer and the founder of Zoomer Analytics GmbH. He pioneered the integration of Python and Excel with his open-source project xlwings.

His work, which predates Microsoft's own "Python in Excel" feature by a decade, has enabled countless companies across the globe to connect Excel with Python. Felix is also a LinkedIn instructor and runs the xlwings meetup in London.

Details
Erscheinungsjahr: 2026
Fachbereich: Programmiersprachen
Genre: Importe, Informatik
Rubrik: Naturwissenschaften & Technik
Medium: Taschenbuch
Inhalt: Einband - flex.(Paperback)
ISBN-13: 9798341640290
Sprache: Englisch
Einband: Kartoniert / Broschiert
Autor: Zumstein, Felix
Auflage: 2nd ed
Hersteller: O'Reilly Media
Verantwortliche Person für die EU: Libri GmbH, Europaallee 1, D-36244 Bad Hersfeld, gpsr@libri.de
Maße: 230 x 178 x 22 mm
Von/Mit: Felix Zumstein
Erscheinungsdatum: 30.06.2026
Gewicht: 0,708 kg
Artikel-ID: 135713580

Ähnliche Produkte