python -excel读写

# 读取excel

 # load_wokbook  拿到excel实例

wb = openpyxl.load_workbook('./111.xlsx',read_only=True)

# 拿到sheet
ws = wb['Sheet']

# 最大行数
max_row = ws.max_row

# 读取某个单元格值
A2 = ws['A2'].value

print(A2)

 

# 写入excel

from openpyxl.styles import Alignment,PatternFill,Font,colors,Side,Border

# 创建一个新的excel
wb = openpyxl.Workbook()
ws = wb.active

ws['A2'] = '嘻嘻哈哈'
ws['B2']= 'yyds'

# 下面是样式

ws['A2'].font = Font(color="E90F0A") 
ws['B2'].font = Font(color='1EEC13') 
wb.save('111.xlsx')

# 不创建新的excel
workbook = openpyxl.load_workbook(filename=file_name)
sheet = self.workbook[sheet_name]
sheet['A2'] = 3

workbook.save()

 

excel中的样式学习和参考

def set_style(ws,cell_list):
    for i in cell_list:
        ws[i].alignment = Alignment(horizontal='center', vertical='center', wrap_text=True)
        ws[i].fill = PatternFill("solid", fgColor="8DB4E2")
        ws[i].border = Border(left=Side(border_style='thin', color=colors.BLACK),
                             right=Side(border_style='thin', color=colors.BLACK),
                             top=Side(border_style='thin', color=colors.BLACK),
                             bottom=Side(border_style='thin', color=colors.BLACK))
    ws.column_dimensions['J'].width = 15.0
    ws.column_dimensions['A'].width = 14.0
    ws.column_dimensions['F'].width = 14.0
    ws.column_dimensions['L'].width = 17.0
    ws.column_dimensions['M'].width = 27.0
    ws.column_dimensions['B'].width = 15.0
    ws.column_dimensions['G'].width = 15.0
    ws.column_dimensions['I'].width = 42.0
    ws.column_dimensions['D'].width = 42.0