Attempting to upload Metadata in xlsx format and received error

CirroBioApps / mudata-explorer

Exploratory data analysis of multimodal datasets

0 stars 0 forks source link

Attempting to upload Metadata in xlsx format and received error #11

Closed jswarts14 closed 3 months ago

jswarts14 commented 3 months ago

Screenshot 2024-06-24 at 11 40 06 AM

sminot commented 3 months ago

The logs say "0 sheets found". Would you mind emailing me the file so that I can take a look?

sminot commented 3 months ago

It looks like you ran into this issue: https://stackoverflow.com/questions/69948897/pandas-valueerror-worksheet-index-0-is-invalid-0-worksheets-found

The file which caused the error was saved as "Strict Open XML Spreadsheet (.xlsx)". If you resave as "Excel Workbook (.xlsx)" instead, it should work.