Turn Your Excel Sheet Into An Interactive Application Using Python (Full Project)

Подписаться 97 тыс.

Просмотров 20 тыс.

50% 1

👉 Explore All My Excel Solutions: pythonandvba.com/solutions
𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
This tutorial will teach you how to create interactive applications using Excel and Python. Learn how to use Python scripts to execute tasks and combine the two in one seamless coding environment. In this video, we will build an application to download RU-vid videos as mp3 files, convert the audio files to text using the AssemblyAI API and finally create a word cloud based on that text file.
🌍 𝗟𝗜𝗡𝗞𝗦:
▶ Source code: github.com/Sven-Bo/excel-inte...
▶ AssemblyAI: www.assemblyai.com/?...
⭐ 𝗧𝗜𝗠𝗘𝗦𝗧𝗔𝗠𝗣𝗦:
00:00 - Introduction
00:48 - Installation dependencies
01:40 - Create an Excel starter template
04:34 - Prepare the worksheet
08:44 - Download a RU-vid video mp3
11:40 - Transcribe the audio file
16:59 - Create the word cloud
18:15 - Outro
𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🆓【𝗙𝗥𝗘𝗘】Excel Add-in (𝗠𝘆𝗧𝗼𝗼𝗹𝗕𝗲𝗹𝘁): pythonandvba.com/mytoolbelt
📊 Dashboard Excel Add-In (𝗚𝗿𝗮𝗳𝗹𝘆): pythonandvba.com/grafly
🎨 Cartoon Charts Excel Add-In (𝗖𝘂𝘁𝗲𝗣𝗹𝗼𝘁𝘀): pythonandvba.com/cuteplots
🤪 Fun Emoji Excel Add-In (𝗘𝗺𝗼𝗷𝗶𝗳𝘆): pythonandvba.com/emojify
📑 Excel Templates: pythonandvba.com/go/excel-tem...
🎓 My Courses: pythonandvba.com/go/courses
📚 Books, Tools, and More: pythonandvba.com/resources
𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🔗 LinkedIn: / sven-bosau
📸 Instagram: / codingisfun_official
💻 GitHub: github.com/Sven-Bo
💬 Discord: pythonandvba.com/discord
📬 Contact: pythonandvba.com/contact
☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?
If you want to support this channel, you can buy me a coffee here:
▶ pythonandvba.com/coffee-donation

Опубликовано:

1 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 40

@patloeber 2 года назад

The king of Python+Excel automation :)

@CodingIsFun 2 года назад

Haha, thank you, Patrick!

@TimePasser 2 года назад

You are amazing man.. Thank you very very much. I really appreciate your work and dedication. I love streamlit because of your videos. In my work I started using streamlit and management quite impressed with this approach. Keep it up buddy.

@CodingIsFun 2 года назад

That is fantastic! Happy to hear that & thanks for watching :)

@Kaelthas_Sunstrider 2 года назад

Incredible work! Thank you!

@CodingIsFun 2 года назад

Thanks for the kind words! I am glad you enjoyed it.

@KhalilYasser 2 года назад

Really amazing and inspiring. I have learned a lot from you.

@CodingIsFun 2 года назад

Happy to hear that!

@yigitcelik7965 Год назад

thank you a lot. your videos are so informative and easy to understand.

@CodingIsFun Год назад

*I am glad to hear you are enjoying them, thanks for watching and for the comment!* 👍

@nagendravishwamitra3652 2 года назад

Absolutely Super !! Such a inspiring coder!! Always brings new things !!

@CodingIsFun 2 года назад

Thank you! :)

@nagendravishwamitra3652 2 года назад

@@CodingIsFun sir could you please make a video on how to install xlwings n create addin in Excel

@CodingIsFun 2 года назад

@@nagendravishwamitra3652 Do you mean to create a 'white labelled' xlwings ribbon, as described here? docs.xlwings.org/en/stable/customaddin.html

@eliemoukabed1864 2 года назад

Thank you !

@CodingIsFun 2 года назад

A pleasure. Thanks for watching!

@elsheep6951 Год назад

Fantastic and inspiring. Thank you. I code for fun and use excel for work.Python is so much neater and more powerful than excel VBA. I now mix fun projects into my work :) p.s. The tool belt is excellent and a real time saver. It took me less than 10 minutes of using the free version to decide to upgrade!

@CodingIsFun Год назад

Thank you so much for your kind words and for taking the time to leave a comment! And I am super happy to hear that you find the MyToolBelt Excel add-in helpful. 🤩

@Yosalsafiesta 2 года назад

Hey buddy thanks so much for sharing! By the way I got another application for you. Super easy to work out montecarlo simulations with excel and python. Most financial models are in corporate finance are in excel. You can use Win32 to open up excel, randomly input values in your cells, extract the output and graph the results. Super useful for risk managemet!

@CodingIsFun 2 года назад

Thanks for your suggestion. There is already an example available that covers a Montecarlo simulation. Have a look at example 3: www.xlwings.org/examples I hope it helps!

@OmerMan992 2 года назад

Hi, can you make a follow-up video showing how you turn this into a web app please? Thanks for the great info!

@CodingIsFun 2 года назад

Thank you. Perhaps the following video will help: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-CrLmgrGiVVY.html Happy Coding!

@pixelmasque Месяц назад

building a GUI type interactivity (data input and visual icons) on an excel table with Python to share interactivity between 3 sheets. is it possible to do this and upload it to OneDrive as a shared excel web application? Or is it for desktop only?

@CodingIsFun 2 года назад

🚨 *Because youtube changed something on its end, you might get the following error message* 🚨 pytube.exceptions.RegexMatchError: get_throttling_function_name: could not find match for multiple ⭐SOLUTION⭐ You need to change the pytube's 'cipher.py' file. Have a look at the following video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-pqIjey6Cbhw.html

@ahmedelhaddad6817 Год назад

thank u so much , pls how to fix this Error Traceback (most recent call last): File "", line 1, in ModuleNotFoundError: No module named 'transcriber'

@CodingIsFun Год назад

Thanks for watching and for your question. Hard to tell from a distance why you are facing an error. I assume that the transcriber.py file is not in the workbook's directory.

@katherinejohnson2487 2 года назад

How do we do this with VBA?

@CodingIsFun 2 года назад

Good questions, but not easy to answer. In general, the logic remains the same. Also, in VBA, you can work with APIs using HTTPS requests. Yet, downloading an mp3 file or creating a word cloud is harder to implement. I am not aware that there are any .bas modules out there. Hence, you would need to write it from scratch.

@emmanuelronstadt2443 2 года назад

When I try to run the SampleCall I get this error message: sh: python: command not found, do you by any chance know why? As I followed your instructions 1to1.

@CodingIsFun 2 года назад

Sounds to me like a Python (installation) problem. You might want to search for your error message on the internet.

@KhalilYasser 2 года назад

I got an error message `Traceback (most recent call last): File "", line 1, in AttributeError: module 'xlwings.utils' has no attribute 'prepare_sys_path'`

@CodingIsFun 2 года назад

Which version of xlwings are you using?

@KhalilYasser 2 года назад

@@CodingIsFun I am using xlwings 0.27.7. I have uninstalled it and then used the version you referred to in the requirements file, then I closed the excel file and reopened it. But the same problem is still there,

@CodingIsFun 2 года назад

@@KhalilYasser Interesting! Could you try to create a simple quickstart project, insert a button and see if you get "Hello xlwings" in cell A1, as shown in the video: 01:40 min?

@KhalilYasser 2 года назад

@@CodingIsFun Yes, I already did that and I got the same problem. Then I have searched and found that I had to install xlwings addin `xlwings addin install` and this seems to solve the problem. Now I can run python from excel without a problem. Now I opened your excel file, and the first error message has gone but got another long message about pytube that ends with ` File "c:\users\future\appdata\local\programs\python\python38\lib\site-packages\pytube\cipher.py", line 296, in get_throttling_function_name raise RegexMatchError( pytube.exceptions.RegexMatchError: get_throttling_function_name: could not find match for multiple`

@KhalilYasser 2 года назад

I have posted the question on s o at this 72145556. Can you have a look at it?