简单写了一个，是把读和写分开了，但是有一个问题，就是在写的时候，循环内容，每次都要重新启一个Workbook() 这样会不会有什么问题？但是放在外面的话，每次append()会是叠加之前数据的情况 from openpyxl import Workbook, load_workbook # 读取文件 wb = load_workbook("demo.xlsx") # 激活文件sheet页 ws = wb.active # 获取激活sheet页文件内容 data = [] for row in ws.iter_rows(): tmp = [] for cell in row: tmp.append(cell.value) data.append(tmp) # 写入文件 for row in data: file_name = row[0] write_wb = Workbook() write_ws = write_wb.active write_ws.append(row) write_wb.save(f"{file_name}.xlsx")

import pandas as pd # 读取 Excel 文件 df = pd.read_excel('sample.xlsx') # 遍历每一行 for index, row in df.iterrows(): print(row.iloc[0]) # 使用第一个单元格作为文件名 filename = str(row.iloc[0]) # 将这一行的数据保存到一个新的文件中 row.to_csv(f'{filename}.csv', index=False)

# 一次只读取表格中的一行 import openpyxl excl = '/Users/mike/Desktop/zero-basics-python/0/sample.xlsx' workbook = openpyxl.load_workbook(excl) worksheet = workbook.active for row in worksheet.iter_rows(): cell_list = [] for cell in row: cell_list.append(cell.value) wb = openpyxl.Workbook() ws = wb.active ws.append(cell_list) wb.save(f'{cell_list[0]}.xlsx') # 一次性把表格的所有内容读入内存 import openpyxl excl = '/Users/mike/Desktop/zero-basics-python/0/sample.xlsx' workbook = openpyxl.load_workbook(excl) worksheet = workbook.active for row in worksheet.values: wb = openpyxl.Workbook() ws = wb.active ws.append(row) wb.save(f'{row[0]}.xlsx')

#%% from openpyxl import load_workbook,Workbook from os import chdir chdir(r'C:\Projects\python\0base_py\ch12\exp2') #%% wb=load_workbook('1.xlsx') ws=wb.active for row in ws.iter_rows(): row_val=[] for cell in row: row_val.append(cell.value) wb1 = Workbook() ws1 = wb1.active ws1.append(row_val) wb1.save(row_val[1]+".xlsx")

from openpyxl import workbook, load_workbook from docx import Document wb = load_workbook('excel1.xlsx') ws = wb.active # 获取工作表全部数据的单元格区域 cell_area = ws[ws.calculate_dimension()] max_column = ws.max_column for row in cell_area: document = Document() table = document.add_table(rows=1, cols=max_column) for i, cell in enumerate(row): table.rows[0].cells[i].text = str(cell.value) document.save(f'{table.rows[0].cells[0].text}.docx')

看了下其他同学写的，重新敲下执行了下 from openpyxl import Workbook,load_workbook wb = load_workbook("1.xlsx") ws = wb.active for row in ws.values: wb_part = Workbook() ws_part = wb_part.active ws_part.append(row) wb_part.save(f"{row[0]}.xlsx")

from openpyxl import Workbook,load_workbook # 打开要访问的 Excel wb = load_workbook("1.xlsx") ws = wb.active # 遍历 Excel 默认 SHEET 的每一行 # 以每一行为文件内容，第一个单元格为文件名，创建新的 Excel for row in ws.values: wb_part = Workbook() ws_part = wb_part.active ws_part.append(row) wb_part.save(f"{row[0]}.xlsx")

import openpyxl wb_read = openpyxl.load_workbook('.\极客时间_零基础学Python_2023\\12\sample2.xlsx') ws_read = wb_read.active for i in range(ws_read.max_row): wb_write = openpyxl.Workbook() ws_write = wb_write.active for j in range(ws_read.max_column): ws_write.cell(1,j+1,ws_read.cell(i+1,j+1).value) name = ws_read.cell(i+1,1).value wb_write.save(f'零基础学Python_第95讲_{name}.xlsx')