首先pip install xlrd和pip install xlwt
# -*- coding: utf-8 -*-
import xlrd
import xlwt
from datetime import date,datetime
def read_excel():
# 打开文件
workbook01= xlrd.open_workbook("file.xls")
table01 = workbook01.sheet_by_index(0)
print(table01.name,table0.nrows,table0.ncols)
# 根据sheet索引或者名称获取sheet内容
sheet2 = workbook01.sheet_by_index(0) # sheet索引从0开始
sheet2 = workbook01.sheet_by_name('sheet2')
# sheet的名称,行数,列数
print(sheet2.name,sheet2.nrows,sheet2.ncols)
# 获取整行和整列的值(数组)
rows = table0.row_values(3) # 获取第四行内容
cols01 = table01.col_values(3) # 获取第三列内容
print(rows)
print(cols01)
# 获取单元格内容
print(table0.cell(1,0).value.encode('utf-8'))
print(table0.cell_value(1,0).encode('utf-8'))
print(table0.row(1)[0].value.encode('utf-8'))
# 获取单元格内容的数据类型
print(table0.cell(1,0).ctype)
def main():
read_excel()
if __name__ == '__main__':
main()