摘要：from openpyxl import Workbook , load_workbook from openpyxl.utils import get_column_letter date = [ { 'name':'小白', 'tall':188, 'age':12, 'weight':74 } 阅读全文

摘要：from openpyxl import Workbook , load_workbook #打开文件 wb = load_workbook('newexcel.xlsx') #使用哪个页签 ws = wb.active #合并单元格 ws.merge_cells('A1:E1') #解除合并单元格 阅读全文

摘要：#打开文件 wb = load_workbook('newexcel.xlsx') #使用哪个页签 ws = wb.active #读取数值 for row in range(1,5): for col in range(1,5): char = get_column_letter(col) pri 阅读全文

摘要：from openpyxl import Workbook , load_workbook wb = Workbook() ws = wb.active ws.title = 'qq' #新增、修改数据 ws['A1'].value = '测试' ws.append([123,456,789,0]) 阅读全文

摘要：from openpyxl import Workbook , load_workbook #打开文件 wb = load_workbook('F:\\RF\\output.xlsx') #使用哪个页签 ws = wb.active #新增页签 #wb.create_sheet('新页签') ws 阅读全文