import xlwings as xw
# 啟動(dòng) Excel，但不新建工作簿
app = xw.App(visible=True,add_book=False)
for i in range(5):
 #新建工作簿
 workbook = app.books.add()
 #保存工作簿
 workbook.save(f'test{i}.xlsx')
 #將工作簿關(guān)閉
 workbook.close()

import xlwings as xw
import os
# 給出工作簿所在的文件夾路徑
path_file = r'E:/python1/python_module'
# 列出該文件夾中所有的子文件或子文件夾
file_list = os.listdir(path_file)
# 啟動(dòng)Excel
app = xw.App(visible=True,add_book=False)
for i in file_list:
 # 判斷文件是否為 Excel文件
 if os.path.splitext(i)[1] =='.xlsx':
  #打開(kāi)
  app.books.open(i)

import xlwings as xw
# 啟動(dòng)Excel
app = xw.App(visible=True,add_book=False)
# 打開(kāi)工作簿
workbook = app.books.open('table.xlsx')
#獲取工作簿的所有工作表
worhsheets = workbook.sheets
for i in range(len(worhsheets)):
 # 重命名工作表
 worhsheets[i].name = worhsheets[i].name.replace('銷(xiāo)售','')
#另存重命名后的工作簿
workbook.save('table1.xlsx')
#退出Excel程序
app.quit()

import xlwings as xw
import os
# 給出工作簿所在的文件夾路徑
path_file = r'E:/python1/python_module'
# 列出該文件夾中所有的子文件或子文件夾
file_list = os.listdir(path_file)
old_book_name = '銷(xiāo)售表'
new_book_name = '分部銷(xiāo)售表'
# 啟動(dòng)Excel
app = xw.App(visible=True,add_book=False)
for i in file_list:
 if i.startswith('~$'):
  continue
 # 執(zhí)行查找和替換，生成新的工作簿名
 new_file = i.replace(old_book_name,new_book_name)
 # 構(gòu)造需要重命名工作簿的完整路徑
 old_path_filr = os.path.join(path_file,i)
 #構(gòu)建重命名后工作簿的完整路徑
 new_path_file = os.path.join(path_file,new_file)
 # 重命名
 os.rename(old_path_filr,new_path_file)
if i.startswith('~$'):
continue

import xlwings as xw
import os
# 給出工作簿所在的文件夾路徑
path_file = r'E:/python1/python_module'
# 列出該文件夾中所有的子文件或子文件夾
file_list = os.listdir(path_file)
old_sheet = 'sheet1'
new_sheet = '員工信息'
app = xw.App(visible=True,add_book= False)
 # 遍歷工作簿
for i in path_file:
 if i.startswith('~$'):
  continue
 # 拼接出完整路徑
 old_path_file = os.path.join(path_file,i)
 # 打開(kāi)工作簿
 workbook = app.books.open(old_path_file)
 # 遍歷工作表
 for j in workbook.sheets:
  if j.name == old_sheet:
j.name = new_sheet
 # 保存工作簿
 workbook.save()
app.quit()

import xlwings as xw
import os
# 給出工作簿所在的文件夾路徑
path_file = r'E:/python1/python_module'
# 列出該文件夾中所有的子文件或子文件夾
file_list = os.listdir(path_file)
app = xw.App(visible=True,add_book= False)
workbook = app.books.open('來(lái)源工作簿路徑')
worksheet = workbook.sheets
 # 子文件
for i in path_file:
 if os.path.splitext(i)[1] =='.xlsx':
  # 打開(kāi)工作簿
  workbooks = app.books.open(path_file+'/'+i)
  # 遍歷工作表
  for j in worksheet:
# 讀取工作表中的信息
contents = j.range('A1').expand('table').value
# 讀取工作表的名稱(chēng)
name = j.name
# 增加同名的工作表
workbooks.sheets.add(name = name,after = len(workbooks.sheets))
# 寫(xiě)入數(shù)據(jù)
workbooks.sheets[name].range('A1').value = contents
  # 保存工作簿
  workbook.save()
app.quit()

import  os
import xlwings as xw
filr_path = 'e:\\table\\產(chǎn)品統(tǒng)計(jì)表.xlsx'
sheet_name = '統(tǒng)計(jì)表'
app = xw.App(visible = True ,add_book= False)
# 打開(kāi)工作簿
workbooh = app.books.open(filr_path)
# 獲取指定的工作表
worksheet = workbooh.sheets[sheet_name]
# 讀取工作表中的所有信息
value = worksheet.range('A2').expand('table').value
# 創(chuàng)建一個(gè)空字典用于按產(chǎn)品名稱(chēng)來(lái)分類(lèi)存放數(shù)據(jù)
data = dict()
#按行遍歷工作表數(shù)據(jù)
for i in range(len(value)):
 # 獲取當(dāng)前行的第一個(gè)空格中的數(shù)據(jù)
 product_name = value[i][1]
 # 如果沒(méi)有該產(chǎn)品
 if product_name not in data:
  # 創(chuàng)建一個(gè)與當(dāng)前行名稱(chēng)對(duì)應(yīng)的空列表
  data[product_name] = []
 # 將當(dāng)前數(shù)據(jù)追加當(dāng)列表中
 data[product_name].append(value[i])
for key,value in data.items():
 # 新建目標(biāo)工作簿
 new_workbook = app.books.add()
 #新建工作表
 new_sheet = new_workbook.sheets.add(key)
 # 將要拆分的工作表的列標(biāo)題復(fù)制到新建的工作表中
 new_sheet['A1'].value = worksheet['A1:H1'].value
 # 將數(shù)據(jù)復(fù)制
 new_sheet['A2'].value = value
 new_workbook.save('{}.xlsx'.format(key))
app.quit()