python excel读写(第三方库xlwt+xlrt)

最新推荐文章于 2023-02-13 22:09:14 发布

Jerry104393

最新推荐文章于 2023-02-13 22:09:14 发布

阅读量378

点赞数

分类专栏： Python

原文链接：https://blog.csdn.net/csdnsevenn/article/details/80863658

版权

Python 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

1.安装第三方库:

pip install xlwt -i https://pypi.tuna.tsinghua.edu.cn/simple
pip install xlrd -i https://pypi.tuna.tsinghua.edu.cn/simple

2.excel读取（xlrt）:

import xlrd


file = 'C:/Users/Jerry/Desktop/test.xls'

wb = xlrd.open_workbook(filename=file)#打开文件


sheet1 = wb.sheet_by_index(0)#通过索引获取指定sheet

for row in sheet1.row_values(0):#获取第一行的所有值
    print(row)

for col in sheet1.col_values(0):#获取第一列的所有值
    print(col)

3.excel写入(xlwt):

import xlwt



#写Excel
f = xlwt.Workbook()

sheet1 = f.add_sheet('sheet',cell_overwrite_ok=True)

row0 = ["姓名","年龄","出生日期","爱好"]
#第0行内容

colum0 = ["张三","李四","恋习Python","小明","小红","无名"]
#第0列内容


#写第一行

for i in range(0,len(row0)):

    sheet1.write(0,i,row0[i])

#写第一列

for i in range(0,len(colum0)):

    sheet1.write(i+1,0,colum0[i])



sheet1.write(7,0,'2006/12/12')

f.save('test.xls')

参考链接：https://blog.csdn.net/csdnsevenn/article/details/80863658