1.打开一个已经存在的excel文件 # -*- coding:utf-8 -*- import xlrd filename = r'demo.xlsx' data = xlrd.open_workbook(filename)