September 2024
Intermediate to advanced
338 pages
9h 21m
Spanish
Content preview from Python para 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,
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.
Capítulo 9. Automatización de Excel
Este trabajo se ha traducido utilizando IA. Agradecemos tus opiniones y comentarios: translation-feedback@oreilly.com
Hasta ahora, hemos aprendido a sustituir las tareas típicas de Excel por pandas(Parte II) y a utilizar los archivos de Excel tanto como fuente de datos como formato de archivo para tus informes(Parte III). Este capítulo da el pistoletazo de salida a la Parte IV, en la que dejamos de manipular archivos de Excel con los paquetes reader y writer y empezamos a automatizar la aplicación de Excel con xlwings.
El principal caso de uso de xlwings en es crear aplicaciones interactivas en las que las hojas de cálculo de Excel actúen como interfaz de usuario, permitiéndote llamar a Python pulsando un botón o llamando a una función definida por el usuario: ése es el tipo de funcionalidad que no cubren los paquetes de lectura y escritura. Pero eso no significa que xlwings no pueda utilizarse para leer y escribir archivos, siempre que estés en macOS o Windows y tengas Excel instalado. Una ventaja que tiene xlwings en este ámbito es la capacidad de editar realmente archivos de Excel, en todos los formatos, sin cambiar ni perder nada del contenido o el formato existentes. Otra ventaja es que puede leer los valores de las celdas de un libro de Excel sin necesidad de guardarlo primero. Sin embargo, también puede tener mucho sentido utilizar conjuntamente un paquete lector/escritor de Excel y xlwings, como veremos cuando retomemos una vez más el ...
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.