How to get dataframe in excel to a variable using file uploader

Using Streamlit
1

i have a dataframe in excel file. I want to load that to a variable using file uploader. When i read the o/p from file uploder, looks like its byte i.o and when i use pd.DataFrame on top of it. It does not give intended result. Though if i use st.table(), i am able to see results as table

2 Likes
2

Hey @karthico, Welcome to the forums! :slight_smile:

I’ve just tried it using this example and it works perfectly with st.table and st.dataframe

Try this after running pip install xlrd

import streamlit as st
import pandas as pd

uploaded_file = st.file_uploader("Choose a XLSX file", type="xlsx")

if uploaded_file:
    df = pd.read_excel(uploaded_file)

    st.dataframe(df)
    st.table(df)
2 Likes
3

hey buddy, thanks a lot this works. Also any idea like what are the file types we can upload.

4

Hey @karthico - you should be able to upload files of any type (though you can limit which file extensions the file uploader will accept with the optional type argument).

The st.file_uploader widget returns each uploaded file as either a string (if the file is just text) or a BytesIO binary blob (for all other files). In the latter case, you’ll need to have code that can work with the file’s binary format, but you’re not limited in what you can do with it.

3 Likes
6

Hey @arraydude , tried this same code but faced the below error.

I also ran pip install xlrd and the requirement was already satisfied.

Getting this error after running the code:

image
image861Ă—903 49.2 KB

Please help…!!