I want to style (conditionally format) a dataframe and add it to a powerpoint/document which can be downloaded on the Streamlit app.
This is easily done locally, by using the dataframe-image package:
import dataframe_image as dfi
from io import BytesIO
from pptx import Presentation
df_styled = df.style.format(precision=0)
temp_file = BytesIO()
dfi.export(df_styled, temp_file)
slide.shapes.add_picture(temp_file)
However, when I then do this on my Streamlit Cloud app, it fails, saying: OSError: Chrome executable not able to be found on your machine
I tried searching how to fix this error message but couldn’t seem to with chrome_installer etc. Does anyone know how to fix this?
A possible work around could be to convert the dataframe to HTML, then export the HTML to an image but I think, although I could style this with CSS, I would lose the ability to conditionally format numbers.
So I put this in the packages.txt chromium-chromedriver
I then download the chromium package from their website, put the file into my lib folder as it says here, but that didn’t work and Streamlit said it was looking for a ‘chromium-chromedriver’ folder, so literally created a folder called that and put the file in there, and now the app is just forever loading without any other message
Sorry I just don’t really know about this package stuff - I might just have to write it in HTML/CSS haha
Thanks for stopping by! We use cookies to help us understand how you interact with our website.
By clicking “Accept all”, you consent to our use of cookies. For more information, please see our privacy policy.
Cookie settings
Strictly necessary cookies
These cookies are necessary for the website to function and cannot be switched off. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms.
Performance cookies
These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us understand how visitors move around the site and which pages are most frequently visited.
Functional cookies
These cookies are used to record your choices and settings, maintain your preferences over time and recognize you when you return to our website. These cookies help us to personalize our content for you and remember your preferences.
Targeting cookies
These cookies may be deployed to our site by our advertising partners to build a profile of your interest and provide you with content that is relevant to you, including showing you relevant ads on other websites.