How to Solve NameError: name 'ctype_text' is not defined -- xlrd
Solution: Import the 'ctype_text' module
To Solve the error, add the following line to the top of your code.
from xlrd.sheet import ctype_text
For more information:
Python xlrd ctype_text