Recently, error loading password’s fault file is always reported when opening excel, which is puzzling. However, xlsx file can still be opened, and I didn’t care about it.
However, it is not enough to import xlsx file as data.
Then, after carefully reading the error information, we found that it was MySQL for Excel. What the hell?How did excel get into MySQL.
So find out what’s wrong with MySQL, and then go online.
Finally, I found that when MySQL was installed, there was a component named MySQL for Excel.
Since there is a problem with MySQL for Excel and it can’t be used now, it’s time to unload it.
So, open MySQL installer, check MySQL for Excel (pay attention not to check other, otherwise it’s not good to unload MySQL), and choose Remove. It’s really a good thing.
OK, open excel and never report this error again
- [Python] pandas Library pd.to_ Parameter arrangement and example of Excel operation writing into excel file
- MySQL password setting error message: error 1054 (42s22): unknown column ‘password’ in ‘field list’
- MySQL error — multiple methods of failed to find valid data directory and MySQL setting password appear
- MySQL 8 — error in setting simple password error 1819 (HY000): your password does not satisfy the current policy requirements
- Pychar console error: xmlrpc.client.Fault : Fault 0: ‘ java.lang.NullPointerException
- Panda was unable to open the. Xlsx file, xlrd.biffh.XLRDError : Excel xlsx file； not supported
- Error 1064 in MySQL password change
- MySQL forgot the root password
- Modify the password of mysql8 on Windows
- django.core.exceptions . improveconfigured: error loading MySQL DB module. Django configuring MySQL database
- MySQL startup problem (ERROR 1045 (28000): Access denied for user’ODBC’@’localhost’ (using password: NO))
- MySQL error 1054 (42s22) unknown column ‘password’ in ‘field list’
- MYSQL:ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
- Error (1820) if the password is not changed in time after MySQL installation
- Linux-mysql8.0 password reset problem – error 1396 (HY000): Operation alter user failed for ‘root’ @’localhost ‘
- Read multiple sheets of an excel file according to npoi
- MySQL — initialize failed to generate temporary password in error log after initialization
- XLRDError: Excel xlsx file； Not supported error reporting solutions
- Solve the problem of error loading MySQL DB module. Encountered during Django project
- MySQL ERROR 1054 (42S22): Unknown column’password’ in’field list’ error