Hi James - is there some reason you don't want to use either conda or pip? They'd resolve all the necessary dependencies. Conda is the default for Spyder but I found I was able to successfully switch Sypder to my pre-existing Python 3.8 installation (under Tools | Preferences | Python interpreter) and so I'm able to continue to use pip.
Just now installed xlrd (which I'd used in the past) into my 3.8 installation - using pip - and had no problems. On Wednesday, May 26, 2021 at 9:36:36 AM UTC-7 [email protected] wrote: > > 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/1f032038-f1b6-4739-a42c-e3af4e21edcdn%40googlegroups.com.
