Disable spinner from google sheets library

juanff · December 14, 2023, 12:39pm

Hi!
I’m using GSheets library on my app and it’s working fine. However, a spinner is shown each time data is pulled using .read(ttl="3m")
I have attached a screenshot of the spinner message.
I would like to remove this message but I don’t know how as I think the spinner message comes from the GSheets library’s code.
Any ideas would be appreciated.
Thanks!

tonykip · December 16, 2023, 12:29pm

Hi @juanff,

Thanks for posting!

Can you share the code you’re working with? Are you using the Google Sheet connection?

juanff · December 16, 2023, 1:43pm

Sure, here is the code:

github.com

jnferfer/text-magnet/blob/master/app.py

from ast import literal_eval
from styles import *
from st_click_detector import click_detector
from streamlit_agraph import agraph, Node, Edge, Config
from streamlit_gsheets import GSheetsConnection
from about import *


@st.cache_data(show_spinner=False, ttl="7m")
def load_data_and_titles():
    """
    Read data from GSheets.

    :return: Tuple with dataframe and a list of titles
    """

    conn = st.connection("gsheets", type=GSheetsConnection)
    data = conn.read(ttl="7m")
    data.fillna("", inplace=True)
    data["links"] = data["links"].apply(lambda x: literal_eval(x))

This file has been truncated. show original

I have used GSheet connection

Topic		Replies	Views
Solved issue of pulling private google sheet into a streamlit app using gspread instead of gsheetsdb 💬 Show the Community! pandas , google-sheets	5	1526	March 21, 2024
Prevent from creating dataframe 🎈 Using Streamlit	1	359	August 15, 2022
Google Sheet Connection when I have more than one page 🎈 Using Streamlit	2	1722	August 15, 2022
Data editor sort column 🎈 Using Streamlit pandas , data_editor	3	1769	February 13, 2024
Reading data from google sheets 🎈 Using Streamlit	5	5184	January 19, 2022

Disable spinner from google sheets library

Related Topics

Hello there 👋🏻

Cookie settings

Strictly necessary cookies

Performance cookies

Functional cookies

Targeting cookies