python操作excel

先安装 openpyxl 模块

文件的创建

from openpyxl import Workbook#导入模块

#创建

wb = Workbook() #creat an excel file in RAM

sheet = wb.active

print(sheet.title)

sheet.title = "Hello"#表单名叫做Hello

wb.save("excel_test.xlsx")#保存

向文件中写数据

from openpyxl import Workbook

wb = Workbook() #creat an excel file in RAM

sheet = wb.active

print(sheet.title)

sheet.title = "Hello"#表单名叫做Hello

sheet["B5"] = "ZLP"

sheet["B7"] = "FYF"

sheet.append(["fff","MLT","CZP","CHN"])

wb.save("excel_test.xlsx")#保存

遍历单元格

from openpyxl import load_workbook#导入模块

wb = load_workbook("name.xlsx")#打开表格

print(wb.sheetnames)#打印出所有的sheet

print(wb.get_sheet_names())

sheet = wb.get_sheet_by_name("Sheet1")#获取指定的Sheet

print(sheet["B5"].value)#打印B5单元格的内容

# 获取指定单元格的长度

# for cell in sheet["D2:D10"]:

# print(cell[0].value)

#获取所有单元格

# for row in sheet:

# for cell in row:

# print(cell.value,end=",")

# print()

#获取指定行列的单元格内容

# for row in sheet.iter_rows(min_row=4,max_row=20,max_col=4):

# for cell in row:

# print(cell.value,end=",")

# print()

#按列循环

# for column in sheet.columns:

# for cell in column:

# print(cell.value,end=",")

# print()

#指定列循环

# for column in sheet.iter_cols(min_col=1,max_col=1,min_row=2,max_row=20):

# for cell in column:

# print(cell.value,end=",")

# print()

给excel表数据设置各种样式

个人觉得暂时没有什么用处