Hello, all. I've been using Spyder to plot thermal data stored in an Excel file (.xlsx). I had a program using Pandas that would read the Excel file, put the data into numpy arrays, and then plot the data. The command I was using to read the excel file is
df = pd.read_excel(fname, sheet_name='Data') where fname is the .xlsx file name. This command worked fine with Spyder 3.x.x when I first downloaded it a while back, but since I updated to 5.0.3 I started getting this error: Missing optional dependency 'xlrd'. Install xlrd >= 1.0.0 for Excel support Use pip or conda to install xlrd. I tried changing the engine to openpyxl, but that returned this error: Missing optional dependency 'openpyxl'. Use pip or conda to install openpyxl. I've looked at several tutorials and articles addressing this issue, but nothing has worked. I've also tried uninstalling and reinstalling Spyder with no luck. Any assistance would be much appreciated. -- You received this message because you are subscribed to the Google Groups "spyder" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/spyderlib/6c3c6cdc-8b5e-4fbc-bb79-7d64374f4c1dn%40googlegroups.com.
