日本免费全黄少妇一区二区三区-高清无码一区二区三区四区-欧美中文字幕日韩在线观看-国产福利诱惑在线网站-国产中文字幕一区在线-亚洲欧美精品日韩一区-久久国产精品国产精品国产-国产精久久久久久一区二区三区-欧美亚洲国产精品久久久久

  1. 首頁 > 云知道 > >

如何用Python自動化操作Excel Python辦公自動化( 二 )

云知道Python


7、使用公式業(yè)務(wù)中需要批量處理的操作，我們可以代碼化 。Python利用Excel的公式功能來處理數(shù)據(jù)，可以達(dá)到事半功倍的效果 。
from openpyxl import Workbookfrom openpyxl import load_workbookwb = load_workbook('/Users/***/work/document01.xlsx')ws1=wb.activews1["F2"] = "=SUM(B2:E2)"# 使用公式# Save the filewb.save('/Users/***/Desktop/document01.xlsx')8、給單元格設(shè)定字體顏色# -*- coding: utf-8 -*-from openpyxl import Workbookfrom openpyxl.styles import colorsfrom openpyxl.styles import Fontwb = Workbook()ws = wb.activea1 = ws['A1']d4 = ws['D4']ft = Font(color=colors.RED)# color="FFBB00"，顏色編碼也可以設(shè)定顏色a1.font = ftd4.font = ft# If you want to change the color of a Font, you need to reassign it#italic 傾斜字體a1.font = Font(color=colors.RED, italic=True) # the change only affects A1a1.value = "https://www.shwenmu.com/wenda/abc"# Save the filewb.save("/Users/***/Desktop/document01.xlsx")9、設(shè)定字體和大小# -*- coding: utf-8 -*-from openpyxl import Workbookfrom openpyxl.styles import colorsfrom openpyxl.styles import Fontwb = Workbook()ws = wb.activea1 = ws['A1']d4 = ws['D4']a1.value = "https://www.shwenmu.com/wenda/abc"from openpyxl.styles import Fontfrom copy import copyft1 = Font(name=u'宋體', size=14)ft2 = copy(ft1)#復(fù)制字體對象ft2.name = "Tahoma"10、設(shè)定單元格的邊框、字體、顏色、大小和邊框背景色# -*- coding: utf-8 -*-from openpyxl import Workbookfrom openpyxl.styles import Fontfrom openpyxl.styles import NamedStyle, Font, Border, Side,PatternFillwb = Workbook()ws = wb.activehighlight = NamedStyle(name="highlight")highlight.font = Font(bold=True, size=20,color= "ff0100")highlight.fill = PatternFill("solid", fgColor="DDDDDD")#背景填充bd = Side(style='thick', color="000000")highlight.border = Border(left=bd, top=bd, right=bd, bottom=bd)print dir(ws["A1"])ws["A1"].style =highlight# Save the filewb.save("/Users/***/Desktop/document01.xlsx")

推薦閱讀