Greenery2023-07-27 来自新加坡#%% 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")
Geek_fb1a3e2023-03-14 来自巴勒斯坦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')
Cy232023-01-31 来自辽宁看了下其他同学写的，重新敲下执行了下 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")
Matthew2023-01-29 来自江苏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")
PatrickL2023-01-26 来自上海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')