how to open xlsx file with python 3

Question

I have an xlsx file with 1 sheet. I am trying to open it using python 3 (xlrd lib), but I get an empty file!

I use this code:

file_errors_location = "C:\\Users\\atheelm\\Documents\\python excel mission\\errors1.xlsx" workbook_errors = xlrd.open_workbook(file_errors_location) 

and I have no errors, but when I type:

workbook_errors.nsheets 

I get "0", even the file has some sheets... when I type:

workbook_errors  

I get:

xlrd.book.Book object at 0x2.. 

any help? thanks

Answer 1

You can use Pandas pandas.read_excel just like pandas.read_csv:

import pandas as pd file_errors_location = 'C:\\Users\\atheelm\\Documents\\python excel mission\\errors1.xlsx' df = pd.read_excel(file_errors_location) print(df)