May 2026
Intermediate
418 pages
10h 50m
Italian
Content preview from Python per Excel (Italian Edition), 2nd Edition
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,
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.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.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.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.
Capitolo 8. Automazionedi Excel
Questo lavoro è stato tradotto utilizzando l'AI. Siamo lieti di ricevere il tuo feedback e i tuoi commenti: translation-feedback@oreilly.com
Questo capitolo dà il via alla Parte IV, dedicata a xlwings. Mentre Python in Excel trasforma Excel in un notebook Jupyter, xlwings punta a sostituire VBA con Python. Di conseguenza, xlwings ti permette di automatizzare l'applicazione Excel, eseguire macro e creare funzioni personalizzate. Per farlo, xlwings si basa sull'ambiente Python che abbiamo installato nel Capitolo 2. Puoi quindi lavorare offline e utilizzare qualsiasi pacchetto di terze parti che desideri.
Inizieremo questo capitolo con le nozioni di base, come la lettura e la scrittura dei valori delle celle. Dopo aver imparato come xlwings funziona con i DataFrame di pandas, i grafici e le immagini, metteremo in pratica queste competenze con un caso di studio sulla creazione di report. L'ultima sezione ti insegna come rendere i tuoi script performanti e come ovviarealle funzionalità mancanti. Questo capitolo richiede l'esecuzione degli esempi di codice su Windows o macOS, poiché dipendono da un'installazione locale di Microsoft Excel.
Introduzione a xlwings
L'obiettivo principale di xlwings è quello di fungere da sostituto immediato del VBA di Excel, permettendoti di interagire c da Python. Poiché la griglia di Excel è il layout perfetto per visualizzare strutture di dati come liste, array NumPy e DataFrame di pandas, una delle caratteristiche principali ...
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.