【python读取文件】

系列文章目录

---

前言

一、python读取文件的几种方式

pip install xlwd
pip install xlwt
pip install openpyxl
pip install pandas

1.用xlrd和wlwt进行读写

file_path = os.path.dirname(os.path.abspath(__file__))
base_path = os.path.join(file_path,'data.xlsx')
book = xlrd.open_workbook(path)
sheet1 = book.sheets()[0]
nrows = sheet1.nrows
ncols = sheet1.ncols
row3_values = sheet1.row_values(2)  #第三行值
col3_values = sheet1.col3_values(2) #第三列值
cell_3_3 = sheet1.cell(2, 2).value  #单元格值

workbook = xlwt.Workbook(encoding = 'utf-8')
worksheet = workbook.add_sheet('Worksheet')
worksheet.write(0, 0, label = '测试')  #写入excel对应行、列、值
worksheet.col(0).width = 3333  #单元格宽度
tall_style = xlwt.easyxf('font:height 520')
worksheet.row(0).set_style(tall_style)

2.用openpyxl进行读写

openpyxl是一个python库，用于读写excel 2010 xlsx/xlsm/xltx/xltm文件

file_path = os.path.dirname(os