欧美成人午夜免费全部完,亚洲午夜福利精品久久,а√最新版在线天堂,另类亚洲综合区图片小说区,亚洲欧美日韩精品色xxx

千鋒扣丁學堂Python培訓之實現(xiàn)自動化辦公學習筆記

2019-08-06 15:26:46 3727瀏覽

今天千鋒扣丁學堂Python培訓老師給大家分享一篇關于基于python實現(xiàn)自動化辦公學習筆記，文中通過示例代碼介紹的非常詳細，下面我們一起來看一下吧。

1、CSV

（1）寫csv文件

import csv
 
 
def writecsv(path,data):
  with open(path, "w") as f:
    writer = csv.writer(f)
    for rowData in data:
      print("rowData=", rowData)
      writer.writerow(rowData)
 
path = r"E:\\Python\\py17\\automatictext\\000001.csv"
writecsv(path, [[1, 2, 3], [4, 5, 6], [7, 8, 9]])

（2）讀csv文件

import csv
def readcev(path):
  infolist = []
  with open(path, "r") as f:
    allFile = csv.reader(f)
    for row in allFile:
      infolist.append(row)
  return infolist
 
 
path = r"E:\\Python\\py17\\automatictext\\PCB3.csv"
info = readcev(path)

2、word文件

（1）讀word文件

import win32com
import win32com.client
 
 
def readWordFile(path):
  # 調(diào)用系統(tǒng)word功能，可以處理doc和docx兩種文件
  mw = win32com.client.Dispatch("Word.Application")
  # 打開文件
  doc = mw.Documents.Open(path)
  for paragraph in doc.Paragraphs:
    line = paragraph.Range.Text
    print(line)
  doc.Close()
  mw.Quit()
 
 
path = r"E:\\Python\\py17\\Keyboardtext\\001.docx"
readWordFile(path)

（2）讀取doc并寫入word

import win32com
import win32com.client
 
 
def readWordFiletootherFile(path, topath):
  mw = win32com.client.Dispatch("Word.Application")
  doc = mw.Documents.Open(path)
  # 將word的數(shù)據(jù)保存在另一個文件
  doc.SaveAs(topath, 2)
  doc.Close()
  mw.Quit()
 
 
path = r"E:\\Python\\py17\\Keyboardtext\\001.docx"
topath = r"E:\\Python\\py17\\Keyboardtext\\a.txt"
 
readWordFiletootherFile(path, topath)

（3）創(chuàng)建word文件

import win32com
import win32com.client
import os
 
 
def makeWordFile(path, name):
  word = win32com.client.Dispatch("Word.Application")
  # 讓文檔可見
  word.Visible = True
  # 創(chuàng)建文檔
  doc = word.Documents.Add()
  # 寫內(nèi)容從頭開始寫
  r = doc.Range(0, 0)
  r.InsertAfter("你好，" + name + "\n")
  r.InsertAfter("python\n")
  # 存儲文件
  doc.SaveAs(path)
  doc.Close()
  word.Quit()
 
 
names = ["張三", "李四", "王五"]
for name in names:
  path = os.path.join(os.getcwd(), name)
  makeWordFile(path, name)

3、Excel

（1）寫xls文件

# 有序字典
from collections import OrderedDict
# 存儲數(shù)據(jù)
from pyexcel_xls import save_data
 
 
def makeExcelFile(path, data):
  dic = OrderedDict()
  for sheetNum, sheetValue in data.items():
    d = {}
    d[sheetNum] = sheetValue
    dic.update(d)
 
  save_data(path, dic)
 
 
path = r"E:\\Python\\py17\\automatictext\\b.xlsx"
makeExcelFile(path, {"表1": [[1, 2, 3], [4, 5, 6], [7, 8, 9]],
           "表2": [[11, 22, 33], [44, 55, 66],
              [77, 88, 99]]})

（2）讀xls文件

from openpyxl.reader.excel import load_workbook
 
 
def readXlsxFile(path):
  file = load_workbook(filename=path)
  print(file.get_sheet_names)
  sheets = file.get_sheet_names()
  sheet = file.get_sheet_by_name(sheets[0])
  for lineNum in range(1, sheet.max_row + 1):
    lineList = []
    print(sheet.max_row, sheet.max_column)
    for columnNum in range(1, sheet.max_column + 1):
      # 拿數(shù)據(jù)
      value = sheet.cell(row=lineNum,
                column=columnNum).value
      if value != None:
        lineList.append(value)
    print(lineList)
 
 
path = r"E:\\Python\\py17\\automatictext\\001.xlsx"
readXlsxFile(path)

（3）返回xls數(shù)據(jù)

from openpyxl.reader.excel import load_workbook
 
 
def readXlsxFile(path):
  dic = {}
  file = load_workbook(filename=path)
  sheets = file.get_sheet_names()
  print(len(sheets))
  for sheetName in sheets:
    sheet = file.get_sheet_by_name(sheetName)
    # 一張表的所有數(shù)據(jù)
    sheetInfo = []
    for lineNum in range(1, sheet.max_row + 1):
      lineList = []
      for columnNum in range(1, sheet.max_column + 1):
        value = sheet.cell(row=lineNum,
                  column=columnNum).value
        lineList.append(value)
      sheetInfo.append(lineList)
      # 將一張表的數(shù)據(jù)存到字典
      dic[sheetName] = sheetInfo
    return dic
 
 
path = r"E:\\Python\\py17\\automatictext\\001.xlsx"
dic = readXlsxFile(path)
print(dic)
  
# 有序字典
from collections import OrderedDict
# 讀取數(shù)據(jù)
from pyexcel_xls import get_data
 
 
def readXlsAndXlsxFile(path):
  dic = OrderedDict()
  # 抓取數(shù)據(jù)
  xdata = get_data(path)
  for sheet in xdata:
    dic[sheet] = xdata[sheet]
  return dic
 
 
path = r"E:\\Python\\py17\\automatictext\\001.xlsx"
dic = readXlsAndXlsxFile(path)
print(dic)
print(len(dic))

4、PPT

（1）寫PPT

import win32com
import win32com.client
 
 
def makeppt(path):
  ppt = win32com.client.Dispatch("PowerPoint.Application")
  ppt.Visible = True
  pptFile = ppt.Presentations.Add()
 
  # 創(chuàng)建頁
  page1 = pptFile.Slides.Add(1, 1)
  t1 = page1.Shapes[0].TextFrame.TextRange
  t1.Text = "sunck"
  t2 = page1.Shapes[1].TextFrame.TextRange
  t2.Text = "sunck is a good man"
  # 保存
  pptFile.SaveAs(path)
  pptFile.Close()
  ppt.Quit()
 
 
path = r"E:\\Python\\py17\\automatictext\\sunk.ppt"
makeppt(path)

5、PDF

import win32com
import win32com.client
 
 
def makeppt(path):
  ppt = win32com.client.Dispatch("PowerPoint.Application")
  ppt.Visible = True
  pptFile = ppt.Presentations.Add()
 
  # 創(chuàng)建頁
  page1 = pptFile.Slides.Add(1, 1)
  t1 = page1.Shapes[0].TextFrame.TextRange
  t1.Text = "sunck"
  t2 = page1.Shapes[1].TextFrame.TextRange
  t2.Text = "sunck is a good man"
  # 保存
  pptFile.SaveAs(path)
  pptFile.Close()
  ppt.Quit()
 
 
path = r"E:\\Python\\py17\\automatictext\\sunk.ppt"
makeppt(path)

以上就是關于千鋒扣丁學堂Python培訓之實現(xiàn)自動化辦公學習筆記的全部內(nèi)容，想要了解更多關于Python開發(fā)方面內(nèi)容的小伙伴，請關注扣丁學堂Python培訓官網(wǎng)、微信等平臺，扣丁學堂IT職業(yè)在線學習教育有專業(yè)的Python講師為您指導，此外扣丁學堂老師精心推出的Python視頻教程定能讓你快速掌握Python從入門到精通開發(fā)實戰(zhàn)技能。扣丁學堂Python技術交流群：279521237。

                          

      【關注微信公眾號獲取更多學習資料】         【掃碼進入Python全棧開發(fā)免費公開課】

查看更多關于"Python開發(fā)資訊"的相關文章>