python - ModuleNotFoundError: No module named 'xlxswriter'

Question

Language: Python 3.8.3
I faced this error when I was importing my xlxs file ModuleNotFoundError: No module named 'xlxswriter'

import xlxswriter

import pandas as pd

from pandas import DataFrame

path = ('mypath.xlxs')

xl = pd.ExcelFile(path)

print(xl.sheet_names)

How can I fix this?

question from:https://stackoverflow.com/questions/65647981/modulenotfounderror-no-module-named-xlxswriter

Answer 1

Instead of typing xlsx, type xlsx like this:

import xlsxwriter

import pandas as pd

from pandas import DataFrame

path = ('mypath.xlsx')

xl = pd.ExcelFile(path)

print(xl.sheet_names)

It'll work.