0

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?

myamulla_ciencia
  • 1,282
  • 1
  • 8
  • 30

0 Answers0