I have a thousands of excel files with .xlsx extentions, i'm trying to import them using fread from pydatatable.
fread('sample.xlsx')
I also have installed xlrd library in my environment.
however it gives an error as below.
24 import xlrd
25 # Fixes the warning
26 # "PendingDeprecationWarning: This method will be removed in future
27 # versions. Use 'tree.iter()' or 'list(tree.iter())' instead."
---> 28 xlrd.xlsx.ensure_elementtree_imported(False, None)
29 xlrd.xlsx.Element_has_iter = True
30 except ImportError:
AttributeError: module 'xlrd' has no attribute 'xlsx'
How to read .xlsx files using pydatatable?