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.
Apéndice B. Funciones avanzadas de VS Code
Este apéndice te muestra cómo funciona el depurador en VS Code y cómo puedes ejecutar cuadernos Jupyter directamente desde VS Code. Los temas son independientes entre sí, por lo que puedes leerlos en cualquier orden.
Depurador
Si has utilizado alguna vez el depurador VBA de Excel, tengo buenas noticias para ti: depurar con VS Code es una experiencia muy similar. Empecemos abriendo el archivo depurando.py del repositorio compañero en VS Code. Haz clic en el margen a la izquierda de la línea número 4 para que aparezca un punto rojo: éste es tu punto de interrupción, donde se detendrá la ejecución del código. Ahora pulsa F5 para iniciar la depuración: aparecerá el Panel de Comandos con una selección de configuraciones de depuración. Elige "Archivo Python" para depurar el archivo activo y ejecutar el código hasta que llegue al punto de interrupción. La línea se resaltará y la ejecución del código se detendrá, ver Figura B-1. Mientras depuras, la barra de estado se vuelve naranja.
Si la sección Variables no aparece automáticamente a la izquierda, asegúrate de hacer clic en el menú Ejecutar para ver los valores de las variables. Alternativamente, también puedes pasar el ratón por encima de una variable en el código fuente y obtener un tooltip con su valor. En la parte superior, verás la Barra de Herramientas de Depuración que te da acceso a los siguientes botones de izquierda a derecha): Continuar, Pasar por encima, Entrar, Salir, Reiniciar ...
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.