Hello James, I agree to Pat that the easiest solution would be installing *xlrd* using *conda* or *pip*. Though whether you can use *conda* or *pip *is decided by whether you used the stand-alone installer for Spyder or installed it using Anaconda.
Kind regards yfprojects pa...@well.com schrieb am Mittwoch, 26. Mai 2021 um 18:46:59 UTC: > 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 jamesjoh...@gmail.com > 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 spyderlib+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/spyderlib/d64204fa-d4df-45b6-91cf-6a97d11cea22n%40googlegroups.com.
