![](https://img-blog.csdnimg.cn/20201014180756738.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
openpyxl
文章平均质量分 73
bdawn
JS全栈|软件工程师,负责公司所有前后端项目的开发和管理。
展开
-
openpyxl 数字格式处理
数字格式处理设置单元格数字格式将单元格的value设置为数字设置单元格的number_format就可以更改excel中的显示格式from openpyxl import Workbookfilename = 'number.xlsx'wb = Workbook()ws = wb.activews.column_dimensions['A'].width = 40ws['A1'] = 111111ws['A1'].number_format = '#,##0'ws['A2'] =原创 2021-01-14 16:04:06 · 12047 阅读 · 3 评论 -
openpyxl 批量操作单元格
openpyxl 批量操作单元格获取一行或一列单元格from openpyxl import Workbookfrom openpyxl.styles import PatternFill, Border, Side, Alignmentfilename = 'rangeCells.xlsx'wb = Workbook()ws = wb.activerangeCell1 = ws['G10']# 获取一列单元格colD = ws['D']for c in colD: c.v原创 2020-12-26 12:01:39 · 6016 阅读 · 0 评论 -
openpyxl单元格合并
openpyxl单元格合并单元格合并调用Worksheet的函数merge_cells就可以很方便的实现单元格合并from openpyxl import Workbookwb = 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)# 单元格取消合原创 2020-12-23 13:53:02 · 11451 阅读 · 1 评论 -
openpyxl 日期格式处理
日期格式处理设置单元格日期格式将单元格的value设置为datetime设置单元格的number_format就可以更改excel中的显示格式from openpyxl import Workbookimport datetimefilename = 'date.xlsx'wb = Workbook()ws = wb.activews.column_dimensions['A'].width = 40ws['A1'] = datetime.datetime.today()ws['A原创 2020-12-22 18:01:58 · 11346 阅读 · 1 评论 -
openpyxl 单元格样式处理
openpyxl 单元格给样式处理from openpyxl.styles import Font, PatternFill, Border, Side, Alignment, Colorfrom openpyxl import load_workbookdest_filename = 'data.xlsx'# 加载工作簿wb = load_workbook(filename=dest_filename)sheet1 = wb['first sheet']# 字体设置# color: 字体原创 2020-12-19 14:07:33 · 2421 阅读 · 2 评论 -
openpyxl-python处理excel开源库
openpyxl-python处理excel开源库基础用法# 安装openpyxl库pip install openpyxl# 安装openpyxl库from openpyxl import Workbook# get_column_letter: 将数字转换成excel列的字母形式, 如:1》A,8》Hfrom openpyxl.utils import get_column_letter# 创建工作簿wb = Workbook()filename = 'data.xlsx'#原创 2020-12-18 13:50:28 · 1346 阅读 · 0 评论