BDawn的专栏

openpyxl-python处理excel开源库 基础用法 # 安装openpyxl库 pip install openpyxl # 安装openpyxl库 from openpyxl import Workbook # get_column_letter: 将数字转换成excel列的字母形式, 如：1》A，8》H from openpyxl.utils import get_column_letter # 创建工作簿 wb = Workbook() filename = 'data.xlsx' #

openpyxl 单元格给样式处理 from openpyxl.styles import Font, PatternFill, Border, Side, Alignment, Color from openpyxl import load_workbook dest_filename = 'data.xlsx' # 加载工作簿 wb = load_workbook(filename=dest_filename) sheet1 = wb['first sheet'] # 字体设置 # color: 字体

数字格式处理 设置单元格数字格式 将单元格的value设置为数字 设置单元格的number_format就可以更改excel中的显示格式 from openpyxl import Workbook filename = 'number.xlsx' wb = Workbook() ws = wb.active ws.column_dimensions['A'].width = 40 ws['A1'] = 111111 ws['A1'].number_format = '#,##0' ws['A2'] =

openpyxl 批量操作单元格 获取一行或一列单元格 from openpyxl import Workbook from openpyxl.styles import PatternFill, Border, Side, Alignment filename = 'rangeCells.xlsx' wb = Workbook() ws = wb.active rangeCell1 = ws['G10'] # 获取一列单元格 colD = ws['D'] for c in colD: c.v

openpyxl单元格合并 单元格合并 调用Worksheet的函数merge_cells就可以很方便的实现单元格合并 from openpyxl import Workbook wb = Workbook() ws = wb.active # 需要合并的左上方和右下方单元格坐标 ws.merge_cells(range_string='A1:B3') ws.merge_cells(start_row=5, start_column=4, end_row=8, end_column=8) # 单元格取消合

日期格式处理 设置单元格日期格式 将单元格的value设置为datetime 设置单元格的number_format就可以更改excel中的显示格式 from openpyxl import Workbook import datetime filename = 'date.xlsx' wb = Workbook() ws = wb.active ws.column_dimensions['A'].width = 40 ws['A1'] = datetime.datetime.today() ws['A