'How to read xlsx files using fread from pydatatable?

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?

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'How to read xlsx files using fread from pydatatable?

Sources

Related Questions