Thank you for watching the video & your suggestion - I have changed the title 👍😃

Hi Johan, *Wow, thank you so much!* I am glad you enjoyed the video 😃 Cheers, Sven

Comments like yours is what gives me the motivation to publish more videos. *Thank you so much for your support.* 🙏

Ah, you're making me blush! Thanks for the kind comments and happy to hear that you're enjoying the videos! Happy Coding! :)

*I am glad you liked the video, thanks for watching and for the comment!* I will try to release the video on how to deploy the web app for free on Heroku this coming weekend 😃

Hi Paul Carr, Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video! Yesterday, I released another streamlit tutorial on how to turn an Excel sheet into a Sales Dashboard. You might be interested in that one too: kzfaq.info/get/bejne/ichgdJyam8qXYmQ.html Regarding your question, I am using two jupyter notebook extensions: 1 - Collapsible headings 2 - Zen mode Here is a great blog article to show you how to install the extensions: ndres.me/post/best-jupyter-notebook-extensions/ I hope this helps! 😃

Thanks for watching and the kind words. Good luck with your project! 🍀 Happy learning & coding!

Thanks for watching and welcome aboard! :)

You're very welcome! Thank you for watching and for the comment!

*Thanks for watching the video & your comment.*

Glad to hear you liked it! Thank you for commenting and watching. Cheers, Sven ✌️

Happy to hear that. I appreciate that you took the time to leave a comment! :)

Obrigado pelo apoio! Fico feliz que esteja aprendendo. Valeu! 👍

Glad you liked it. Thanks for watching and your comment! 👍

*Thank you.* I am glad you enjoyed the video 😃

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

Glad you liked it. Thanks for watching. Greetings to Cuba! 👋

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

Glad to hear you liked it! Thank you for commenting and watching.

Thank you! 🤩

Thanks for watching the video & your kind feedback. Regarding your video request, you might want to check out the following video from 'Excel Macro Mastery': kzfaq.info/get/bejne/pNlzn8ylt6u-oZs.html I hope this help! Greetings to India! ❤

@@CodingIsFun @Coding Is Fun thanks for replying, i meant an excel which already contains VBA's, macros,formulae and user forms to web app with python also by which i mean to ask that, is it possible to convert/write complete vba code with certian user forms which i have to convert in web page/app with python, codes which i already have my in vba...

@@akki803 As a starting point, you could use my free Excel add-in to create a pandas dataframe right inside Excel: kzfaq.info/get/bejne/ptOjaJWQksnRk2w.html Currently, I am not aware of any solution to create a web app directly from Excel. Unfortunately, there is no automatic way to convert your current VBA code to Python.

@@CodingIsFun i request,....if you can make a video to re-type vba codes in python to make a web app, ... I will mail/send you my vba project with sources code, if you are interested please think on it it will be a great help for me and lots like me... and also a interesting way to learn python more. LoL❤ to the channel already its helping a lot. Edit: i saw your ecxel sheet to web video kzfaq.info/get/bejne/ichgdJyam8qXYmQ.html but i wanted to know if you can help in re-coding of vba to python.🙂

*Thank you very much* 😃

Thanks for watching the video and your comment! :)

My pleasure! Appreciate you taking the time to watch and leave a comment.

Glad it is helpful! It depends. Assuming you are hosting your streamlit app on a web server -> in that case, you always need to deploy the latest Excel files to the webserver.

*I am glad to hear you are enjoying them, thanks for watching and for the comment!* You need to deploy on webserver. You've got a couple options here, like using the Streamlit cloud for a free deployment or checking out a hosting platform like Render. I've even made a tutorial on my channel specifically for using Render, so feel free to give it a look. Good luck with the deployment!

@@CodingIsFun sounds great, thank you so much for responding 🙌🙌🙌🤝🤝

*I am glad you liked the video, thanks for watching and for all your support!*

Thank you for tuning in! To address your questions: 1. Based on the documentation (extras.streamlit.app/Dataframe%20explorer%20UI), there doesn't seem to be a parameter for altering the default text. 2. Streamlit does not natively support font size modification, as indicated in the documentation: docs.streamlit.io/library/api-reference/widgets/st.slider However, for both cases (1 & 2), you can utilize custom CSS to achieve the desired changes. Unfortunately, explaining the entire process is beyond the scope of a single comment. I hope this information is helpful. Happy coding!

Hi Gerhard, *Thank you.* I am glad you enjoyed the video 😃

Glad to hear that!

*I am glad you liked the video, thanks for watching and for the comment!*

Glad you liked it. Thanks for watching.

*Happy New Year!* 🎉 Fantastic! 💪 Thanks for watching the video and your comment.

Glad you liked it. Thanks for watching and taking the time to leave a comment!

Thanks. Check out this tutorial: blog.streamlit.io/streamlit-authenticator-part-1-adding-an-authentication-component-to-your-app/ Happy Coding!

*Hi Bayu Anggoro. I am glad you liked the video. Thanks for watching and for the comment!* Yes, you can either use the Google Sheets API or simply make your Google Spreadsheet public. For doing this, you just have to go to File->Publish to the web. Then choose “Microsoft Excel (.xlsx)” from the dropdown menu and copy the URL. Once done, you could use df = pd.read_excel(YOUR_URL)

Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!

Hey there! Thanks for tuning in! 😊 To speed up loading times and avoid reloading the entire dataframe from scratch, try using Streamlit's caching feature with the @st.cache decorator. For example: @st.cache def load_data(): df = pd.read_excel(excel_file, sheet_name=sheet_name, usecols='B:D', header=3) return df You can find more info on Streamlit caching here: docs.streamlit.io/library/advanced-features/caching Hope this helps!Happy Streamlit-ing! 🚀

Thanks for watching. Please clone the GitHub repo and try again. Thanks! Cheers, Sven ✌️

Thanks for watching! While it might be possible to do this with Google Sheets, I haven't personally tried it. So, I can't provide a definitive answer. Happy Coding!

You're very welcome! Thank you for watching and for the comment!

You're very welcome! Thank you for watching and for the comment!

Sehr gerne! Danke fürs Anschauen!

Thank you very much! 👍

Thanks for watching. Not sure, if it is "the best" solution, but I do like pyecharts for that purpose: kzfaq.info/get/bejne/rqtpaNd636nZe4E.htmlsi=BBEVDvdYD_qUGHAn Happy Coding! Cheers, Sven ✌️

Thanks for watching. I went ahead and tested it for you -> Yes, it also works with xlsm files.

Thank you!

Hard to tell from a distance. My closest guess is that you are getting this issue because you are trying to import a module of a library which is not installed in your virtual environment. If you have run 'pip install openpyxl' already, ensure to call your Python file from the same environment in which you installed the package. For example, in your IDE/text editor, you might have set a different Python environment for executing your script. Therefore, try to run your Python file also from the command prompt. If that does not work, try searching for the text of your error message on Google/StackOverflow. Happy Debugging!

Thanks! I am not entirely sure what you mean by a search button, but it sounds possible. Please check out the streamlit documentation to see all available widgets: docs.streamlit.io/ Happy Coding!

Thanks for watching. You can store each sheet in a different dataframe. Example: df1 = pd.read_excel("filename.xlsx", sheet_name="Sheet1") df2 = pd.read_excel(f"ilename.xlsx", sheet_name="Sheet2") Regarding the styling and the different plotting options, I would suggest to check out my other streamlit videos. Happy Coding!

@@CodingIsFun Thanks ! Much appreciated!

Thanks for watching the video. I am not quite sure if I understand you correctly, but perhaps the following might help you: import streamlit as st first_slider = st.slider('first slider', min_value=1, max_value=10, value=5, step=1) second_slider = st.slider('seconds slider', min_value=1, max_value=20, value=15-first_slider, step=1)

@@CodingIsFun Thanks for reply! ye thats the same logic i was talking about :) just need to try that for multiselecting now, thanks!

Hi Noel! Yes, you can! Kindly give it a try 👍

Hallo Christoph, *Vielen lieben Dank* 👍 Beste Gruesse, Sven ✌

@@CodingIsFun ... wie konfiguriert man ein Jupyter-Notebook so, damit es so schön aussieht wie in deinem Beispiel. Sieht sehr praktisch aus, wenn man nur die Überschriften sehen kann und der ganze Code zusammengeklappt werden kann. Oder arbeitest du hier in JupyterLab? PS: Habe die Webapp nachgebaut - funktioniert echt gut. Danke für die gute Erklärung.

@@christoph231090 *Vielen Dank fuer dein Kommentar.* Du kannst kostenlose Jupyter Notebook Extensions installieren. Hier findest du einen guten Artikel darueber: medium.com/@maxtingle/10-jupyter-notebook-extensions-making-my-lyfe-easier-f40139a334ce Das feature welches ich nutze heisst "Collapsible Headings" (Nr. 9 im Artikel). Ich hoffe, dass dir dies weiterhilft. Beste Gruesse Sven

@@CodingIsFun perfekt - hilft auf jeden Fall weiter. Danke

I guess you just need to give it a try. In general, it sounds possible. Good luck and happy coding!

Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!

Thank you for watching the video. You could convert the column to integers: df_participants = pd.read_excel(excel_file, sheet_name= sheet_name, usecols='F:G', converters={'Participants': int}, header=3) Hope this helps :)

@@CodingIsFun It works!! Thanks a lot!!

Have you checked my Deployment Tutorial already? kzfaq.info/get/bejne/pLB4pbanvt7emnk.html

Thanks for watching. That would be possible with Streamlit. Happy coding! :)

Thanks for watching the video & your question. Currently, there are a lot of discussions on how to implement a user authentication into a streamlit app: discuss.streamlit.io/t/user-authentication/612 The simplest (but not a very secure way) is to request the user to enter a password to access your streamlit app: access_token = st.text_input(‘Please enter your access token:’) if access_token != ‘your_secret_token’: st.write(‘Sorry, your token is invalid. Please try again or contact the administrator.’) st.stop() Depending on the access token/password you could then show the different Excel file/tab (pandas dataframe) I hope this helps! Happy Coding! 😃

@@CodingIsFun Nice eventually will need something more secure but thank you so much for replying, video was sensational and now your comment is the cherry on top, super appreciate it!!!!

Hi Florian, *Thanks for watching the video & your question.* It depends also on the firewall settings within your company, but the web app would be available under the 'Network Url' [see screenshot]: 👉 prnt.sc/10mq6tb If you want to export the web app to a standalone HTML file, this is currently not possible (see also the open issue on Github): 👉 github.com/streamlit/streamlit/issues/611 I am not sure about your use-case, but if you 'only' want to export visuals in a 'Dashboard' format (without the slider/multi-select), you could use other libraries, like 'Plotly' or 'Pyechart'. Those can be exported to HTML as well. Please see the example below: 👉 gallery.pyecharts.org/#/Tab/tab_base Hope this helps. Cheers, Sven

@@CodingIsFun Many thanks for your response. I would like to make certain tables available interactively so that employees in the company can compile the data themselves with the help of sliders, etc. For example, we have several production lines with daily outputs and disruptions. Here you could filter the data depending on the production line. I have already created such a dashboard with streamlit, but it only works on my computer with Python.

@@selimalili Another option could be to install Python on a shared drive/folder within your company (where everybody can have access) & create a .bat file (example below): set root=Z:\SharedFolder\Miniconda3\ call %root%\Scripts\activate.bat call streamlit run "path\to\file\app.py" The end-user then only needs to run the Batch File. Please note, that I have not tested out the solution myself, but theoretically this should work 🙏

Hard to tell from a distance. My closest guess is that you are getting this issue because you are trying to import a module of a library which is not installed in your virtual environment. If you have run 'pip install ' already, ensure to call your Python file from the same environment in which you installed the package. For example, in your IDE/text editor, you might have set a different Python environment for executing your script. Therefore, try to run your Python file also from the command prompt. If that does not work, try searching for the text of your error message on Google/StackOverflow. Happy Debugging!

Thanks for watching. PowerBI is primarily used for business analytics, allowing you to create interactive visualizations and business intelligence reports. Streamlit, on the other hand, is a fast and easy way to build custom machine learning tools, letting you create interactive web applications by just writing Python scripts.

Thanks for watching. Please clone the repo and try again. Happy Coding! Cheers, Sven ✌️

Thanks for watching. Sorry, I am not sure what you are trying to achieve.

Yes, you could also insert Plotly charts into a flask app. You might want to check out the module 'Dash'.

Thanks for watching the video. I have received your mail :)

Thanks a ton for the support! 🙏

Thanks for watching. So far, I do not have any paid courses.

Thanks for watching. Have a look here: discuss.streamlit.io/t/new-library-streamlit-jupyter-a-new-way-to-develop-streamlit-apps-in-jupyter-notebooks/35679 Happy Coding! Cheers, Sven ✌️

Here you are: kzfaq.info/get/bejne/arl_ZqaGvLa9lmQ.htmlsi=3jKXsu_iybs79KWA

Thanks for watching the video. Did you install streamlit already (pip install streamlit)? docs.streamlit.io/library/get-started/installation

2:45 min

@@CodingIsFun yes sir i use command prompt from anaconda but it doesn't work

@@wbw922 Unfortunately, with that bit of information, I cannot help you. You might want to take some time to write down which line of code is causing the error; let me know if you have modified the code from the tutorial, explain in more depth what you did to troubleshoot the problem and provide some more context. Thanks!

Sorry for my late response. You could add 'secrets' to your streamlit app when deploying. See documentation below: docs.streamlit.io/en/stable/deploy_streamlit_app.html#secrets-management

Thanks for watching. Links are in the description: github.com/Sven-Bo/excel-webapp-streamlit

Thanks for watching the video. Can you perhaps elaborate on what it is you're trying to achieve? Please provide some additional info. Thanks!

@@CodingIsFun haha its amazing how fast you answered! RESPECT! To be brief, I would like to display a dataframe (maybe from excel type) and create also some filters for selection! As end goal, I have to export the filtered 'new' datafame. Imagine that I want to extract a specific sample of Users from a list that obeys to my filters selection (eaaaaaaaaasyyyyy)

@@efthymiosmakrandreou1285 Thanks for the additional info. In the following tutorial, I have done something very similar: kzfaq.info/get/bejne/kKqWmdKBm83OqJc.html I hope it helps! Happy Coding!

@@CodingIsFun greatly appreciate your help !!!!! You rock

Thanks for watching. As mentioned in the description: Deploy your Streamlit Application to Heroku for free: 👉 kzfaq.info/get/bejne/pLB4pbanvt7emnk.html

Thanks for watching. It is the website you see in the video - a dynamic one.

Thanks for watching the video. Regarding your question, kindly check out the following site: docs.streamlit.io/streamlit-cloud/trust-and-security

I cloned Eckhart Tolle with the help of AI

Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!

Please run 'pip install plotly-express'

Thanks for watching the video. Actually, in the video, I am declaring sheet_name already as a variable: excel_file = 'Survey_Results.xlsx' sheet_name = 'DATA' df = pd.read_excel(excel_file, sheet_name=sheet_name, usecols='B:D', header=3)

Hi, no

Thank you for watching the video. I am using 'atom' (atom.io/)

Thank you for watching the video & your questions. As far as I know, currently there is no option/solution to host streamlit on SharePoint or to convert it to standalone files (HTML, CSS, JS) 😕

@@CodingIsFun Thank you for the quick response. Which other which other python packages I could use to get output as HTML, CSS , JS. So that I just copy all the files on to SP and it functions as a SP site

@@PavanKumarNarbolikar Hi Pavan Kumar Narbolikar! Sorry, but I'm not really an expert on web development.

Thanks for watching the video. Django is another high-level Python Web framework. Depending on your project, you could also replicate this project with Django. Yet, Streamlit might be more straightforward to develop & deploy (Machine Learning)Web Apps quickly.

Here you are: kzfaq.info/get/bejne/rqtpaNd636nZe4E.html

Thanks for watching the video. Have you tried to install streamlit into a separate virtual environment (kzfaq.info/get/bejne/hJumpsaBub2vf58.html)?

@@CodingIsFun thanks, but I finished the hackathon I needed this for. Ended up using JavaScript. Hackathon was a great success tho! Thank you

*Thanks for watching the video & your question.* Could you please try to enable the view of 'filename extensions' and try to rename your file again? 👉 vtcri.kayako.com/article/296-view-file-extensions-windows-10 Hope this helps 🙏 Cheers, Sven

@@CodingIsFun I followed all of the steps again but still didn't change the file into a python file as you have in the video, I will be so glad if you can help me with that. I really need to learn that. Thanks, millions. I would appreciate it if we can share my screen with you to see the things, I am sure you can solve the problem within a minute.

​@@findthetruth3021 Alternatively, you could also open up 'Notepad', go to 'File' > 'Save As...' and then type 'app.py' Kindly have a look at the screenshot: prnt.sc/10lsr3p

@@CodingIsFun thanks a lot, and I really made you tired with that. But, I am so desperate because I even uninstalled the conda and reinstalled again and followed all of the steps still the same issue 😌☹️ I am sure if we have Skype call and give you access to my desktop will solve the issue in minutes. Thanks in advance.

Thank you for watching the video :)

Thanks for watching the video and your video request. Can you perhaps elaborate on what it is you're actually trying to achieve? Please provide some additional info. Thanks!

@@CodingIsFun in the vba excel toolbox section, there is a web browser, in the web browser a chart can be made, but with the condition that the chart is in HTML program language, maybe I can continue to email along with pictures, so that it is clearer and understandable

@@mfeproject615 Thanks for the further input. Most likely, I will not create a separate video about VBA charts. Here is already a comprehensive tutorial on VBA charts: kzfaq.info/get/bejne/nL2pqpd1r6m3o3k.html

Get well soon!

Thanks for watching. The excel file name is: Survey_Results.xlsx Kindly change it and try again.

Thanks for watching. Links are in the description: github.com/Sven-Bo/excel-webapp-streamlit