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

[@CodingIsFun]

🚨 *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: kzbin.info/www/bejne/pqKsm5iva6iVntk

[@patloeber]

The king of Python+Excel automation :)

[@CodingIsFun]

Haha, thank you, Patrick!

[@TimePasser]

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]

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

[@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!* 👍

[@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]

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]

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!

[@nagendravishwamitra3652]

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

[@CodingIsFun]

Thank you! :)

[@nagendravishwamitra3652]

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

[@CodingIsFun]

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

[@KhalilYasser]

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

[@CodingIsFun]

Happy to hear that!

[@Kaelthas_Sunstrider]

Incredible work! Thank you!

[@CodingIsFun]

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

[@OmerMan992]

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

[@CodingIsFun]

Thank you. Perhaps the following video will help: kzbin.info/www/bejne/eaOvnpqofM6JjLs Happy Coding!

[@eliemoukabed1864]

Thank you !

[@CodingIsFun]

A pleasure. Thanks for watching!

[@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?

[@katherinejohnson2487]

How do we do this with VBA?

[@CodingIsFun]

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.

[@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.

[@holybusta]

I created a data entry form for my persomal business, i gave it too much time created a macro enabled button for entries in excel but at the end when i completed it i download the file in my mobile but macro vba is not working in mobile can i create something dashboard kinda data form which works on mobile for entries in excel sheet please help

[@CodingIsFun]

Thanks for watching. It's hard to recommend a specific solution without more details. If you need more personalized advice, you can schedule a consulting call with me here: pythonandvba.com/go/consulting-call Cheers, Sven ✌️

[@emmanuelronstadt2443]

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]

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

[@hakimdz3358]

I have a question, how can I contact you?

[@CodingIsFun]

www.pythonandvba.com/contact/

[@hakimdz3358]

@@CodingIsFun I sent you a message..please try to help me

[@KhalilYasser]

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]

Which version of xlwings are you using?

[@KhalilYasser]

@@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]

@@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]

@@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]

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