import Error:Missing optional dependency ‘openpyxl‘. Use pip or conda to install openpyxl

  When using pandas to import file data, run read_ CSV is normal, and read is running_ If there is an error in Excel, install openpyxl directly according to the prompt.

terms of settlement:

  Upper left corner file — & gt; Settings—> project –>+ Openpyxl search installation number

Run again as follows:

 

Read More: