#Unable to read Excel

1 messages · Page 1 of 1 (latest)

patent plank
#

Everything's in the title, i've tried multiple time, with multiple file format (csv, xlsx and even Htm) but each time it just says "error analyzing"

#

step to reproduce : upload any kind of excel file i believe
expected result : gpt reading the excel and providing me infos
Actual result : gpt not working with "error analyzing"

#

gpt code :

Attempting to load the .htm file which is often used as an alternative to .xlsx for Excel files

try:
# Pandas can read .htm files assuming they are HTML tables
freedom_scores_htm = pd.read_html('/mnt/data/freedom_scores_by_year.htm')
# Displaying the first few rows to understand the structure of the data
display_htm = freedom_scores_htm[0].head() # Assuming the first table contains the data we need
except Exception as e:
# If there's an error, display the error message
display_htm = e

display_htm