Did you know that you can use an SQL formula in Excel? Learn in this video how to run SQL queries in Excel. You don't have to be a programmer to be able to get the most out of SQL. In this video, you'll learn how to add the SQL formula to your Excel application. In particular, we will use the Python package xlwings and the xlwings Excel add-in. After setting everything up, I will walk you through some practical examples and share my tips and tricks for using SQL in Excel..
Install the dependencies with pip
pip install xlwings
Install the xlwings Excel add-in
xlwings addin install
- 📺 YouTube: CodingIsFun
- 🌐 Website: PythonAndVBA
- 💬 Discord: Join our Community
- 💼 LinkedIn: Connect with me
- 📸 Instagram: Follow me
Love my content and want to show appreciation? Why not buy me a coffee to fuel my creative engine? Your support means the world to me! 😊
Got some thoughts or suggestions? Don't hesitate to reach out to me at contact@pythonandvba.com. I'd love to hear from you! 💡