How to process data in excel sheet with Python

import xlrd

x1 = xlrd.open_workbook("")

# -*- coding:utf-8 -*-

import xlrd
import os

filename = ""
filePath = ((), filename)

print filePath

# 1. Open the file
x1 = xlrd.open_workbook(filePath)

# 2, get sheet object
print 'sheet_names:', x1.sheet_names()  # Get all sheet names
print 'sheet_number:',         # Get the number of sheets
print 'sheet_object:', ()       # Get all sheet objects
print 'By_name:', x1.sheet_by_name("test")  # Find by sheet name
print 'By_index:', x1.sheet_by_index(3)  # Search by index

sheet_names: [u' plan', u'team building', u'modile', u'test']
sheet_number: 4
sheet_object: [< object at 0x10244c190>, < object at 0x10244c150>, < object at 0x10244c110>, < object at 0x10244c290>]
By_name: < object at 0x10244c290>
By_index: < object at 0x10244c290>

# -*- coding:utf-8 -*-

import xlrd
import os
from datetime import date,datetime

filename = ""
filePath = ((), filename)
print filePath

# Open the file
x1 = xlrd.open_workbook(filePath)

# Get summary data for the sheet
sheet1 = x1.sheet_by_name("plan")
print "sheet name:",    # get sheet name
print "row num:",   # get sheet all rows number
print "col num:",   # get sheet all columns number

pip uninstall xlrd
pip install xlrd==1.2.0

df=pandas.read_excel(‘',engine=‘openpyxl')