#Unable to read Excel
1 messages · Page 1 of 1 (latest)
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