Hi there, how are you? Could someone help me? I’m trying to connect Streamlit to a private Google Sheet. I followed the example in the documentation and it worked. When I changed st.write to st.dataframe and removed the row and column limit, it ended up showing even the columns and rows that have no filled-in information.
How do I make only the information in the used rows and columns appear without me specifying which ones, since I don’t know how many there will be in the final project?