废话不说,直接代码即可,每一步都有注释:
# coding:utf-8
import xlrd
def open_txt():
# 指定需要读取的文件位置
workbook1 = xlrd.open_workbook(r'C:/Users/dell/Desktop/111.xls')
names = workbook1.sheet_names()
# 输出内置表名称
# print(names)
# 指定需要读取文件内的第几个内置表
worksheet = workbook1.sheet_by_index(0)
print(worksheet)
# 输出内置表名称
name = worksheet.name
# print(name)
# 获取文件的行数
number = worksheet.nrows
# print(number) # 155
# 获取文件的列数
columns = worksheet.ncols
# print(columns) # 5
# 循环打印文件内所有信息
for i in range(number):
list1 = worksheet.row_values(i)
print(list1)
open_txt()