Hi @andfanilo the social-media-tutorials you shared are great. I've implemented the Streamlit Excel Dashbaord and enjoyed it.

Couple of questions

1. How can I invert the color or change the background?
2. If I want to move the grid of data to the bottom of the page or to a different page, can you give me broad strokes to adjust that?
3. If I am specifying the filename and location of the file why can't streamlit use that vs having to manually upload the excel file each time in the web app
4. What are the steps to setup github with streamlit to deploy this?
5. Are there projects you would like collaboration on or need help with as I found your dashboard just helped solve several days worth of work and I'd like to pay it forward.

Hi @andfanilo , thank you for your hard work and tutorials,
im having problems with saving to excel file that i have in folder within my streamlit_app

the code runs quite when using streamlit (server), however when trying it using stlite it keeps saying error in saving

is it possible to save to the excel while its within the exe file? like im using the excel such as database

import streamlit as st
import pandas as pd
import micropip
await micropip.install("openpyxl")

def main():
st.set_page_config(
page_title="Omar's Reports",
page_icon="👋",
)

st.title("Driving Teacher's Dashboard")

# Load the existing Excel file into a DataFrame
try:
    students_df = pd.read_excel('files_omar/students.xlsx')
    st.dataframe(students_df.sort_index(ascending=False))

    # Add a form to input new data
    st.subheader("Add New Student")
    with st.form(key='add_student_form'):
        name = st.text_input("Name")
        age = st.number_input("Age", min_value=0, max_value=150)
        grade = st.selectbox("Grade", ['A', 'B', 'C', 'D', 'F'])

        submit_button = st.form_submit_button("Add Student")

        if submit_button:
            # Create a new DataFrame with the input data
            new_student = pd.DataFrame({
                'Name': [name],
                'Age': [age],
                'Grade': [grade]
            })

            # Append the new student data to the existing DataFrame
            students_df = students_df.append(new_student, ignore_index=True)

            # Write the updated DataFrame back to the Excel file
            students_df.to_excel('files_omar/students.xlsx', index=False)


            st.success("New student added successfully!")

except FileNotFoundError:
    st.error("File not found: 'files_omar/students.xlsx'")
except Exception as e:
    st.error(f"An error occurred: {str(e)}")

if name == "main":
main()

After few conversation with bot, it generates this error