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 10. Herramientas de Excel con Python
Este trabajo se ha traducido utilizando IA. Agradecemos tus opiniones y comentarios: translation-feedback@oreilly.com
En el último capítulo, aprendimos a escribir scripts en Python para automatizar Microsoft Excel. Aunque esto es muy potente, el usuario debe sentirse cómodo utilizando Anaconda Prompt o un editor como VS Code para ejecutar los scripts. Lo más probable es que éste no sea el caso si tus herramientas las utilizan usuarios empresariales. Para ellos, querrás ocultar la parte Python para que la herramienta Excel vuelva a sentirse como un libro de trabajo normal con macros. Cómo conseguirlo con xlwings es el tema de este capítulo. Empezaré mostrándote el camino más corto para ejecutar código Python desde Excel antes de examinar los retos de la implementación de las herramientas xlwings, lo que también nos permitirá echar un vistazo más detallado a las configuraciones disponibles que ofrece xlwings. Al igual que el último capítulo, este capítulo requiere que tengas una instalación de Microsoft Excel en Windows o macOS.
Utilizar Excel como Frontend con xlwings
El frontend es la parte de una aplicación que el usuario ve y con la que interactúa. Otros nombres comunes para frontend son interfaz gráfica de usuario (GUI) o simplemente interfaz de usuario (UI ). Cuando pregunto a los usuarios de xlwings por qué crean su herramienta con Excel en lugar de crear una aplicación web moderna, lo que suelo oír es lo siguiente: "Excel es ...
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.