from openpyxl import load_workbook
from copy import copy

wb = load_workbook(r"C:\Original File Name.xlsx", data_only = True)   #your file name
ws = wb['10_Yr'] #your sheet name in the file above

for group in list(ws.merged_cells.ranges):
    min_col, min_row, max_col, max_row = group.bounds
    cell_start = ws.cell(row = min_row, column = min_col)
    top_left_cell_value = cell_start.value

    ws.unmerge_cells(str(group))

    for i_row in range(min_row, max_row + 1):
        for j_col in range(min_col, max_col + 1): 
            ws.cell(row = i_row, column = j_col, value = top_left_cell_value)
            #copy the cell format
            ws.cell(row = i_row, column = j_col).alignment = copy(cell_start.alignment)
            ws.cell(row = i_row, column = j_col).border = copy(cell_start.border)
            ws.cell(row = i_row, column = j_col).font = copy(cell_start.font)

wb.save(r"C:\new file name.xlsx")

(Jan-10-2024, 06:37 PM)deanhystad Wrote: I don't see where you create a new workbook.

import openpyxl

# the folder with the XL file
path2XL = '/home/pedro/myPython/openpyxl/xlsx_files/Delta_blanko.xlsx'
savepath = '/home/pedro/myPython/openpyxl/xlsx_files/Delta_blanko_changed.xlsx'
sourceFile = openpyxl.load_workbook(path2XL)
sourceSheetNames = sourceFile.sheetnames
for sheet in sourceSheetNames:
    print('This XL has the sheets:', sheet)

sFsheet = input('Copy and paste the name of the sheet you want to copy.')
# create a target file
targetFile = openpyxl.Workbook()
# a new file has 1 sheet called Sheet
targetFileSheetNames = targetFile.sheetnames
ts = targetFile.active
# rename the sheet Sheet to anything you like
ts.title = 'My shiny new sheet'
count = 1
for row in sourceFile[sFsheet].values:
    print(row)
    for i in range(len(row)):
        targetFile['My shiny new sheet'].cell(row=count, column=i+1).value=row[i]
    count+=1

targetFile.save(savepath)

import openpyxl
 
# the folder with the XL file
path2XL = r'C:\Source_File.xlsx'
savepath = r'C:\New_File_Name.xlsx'
sourceFile = openpyxl.load_workbook(path2XL)
sourceSheetNames = sourceFile.sheetnames
for sheet in sourceSheetNames:
    print(r'C:\Source_File.xlsx', sheet)
 
sFsheet = input('Source File Sheet Name')
# create a target file
targetFile = openpyxl.Workbook()
# a new file has 1 sheet called Sheet
targetFileSheetNames = targetFile.sheetnames
ts = targetFile.active
# rename the sheet Sheet to anything you like
ts.title = 'New Name for Sheet'
count = 1
for row in sourceFile[sFsheet].values:
    print(row)
    for i in range(len(row)):
        targetFile['New Name for Sheet'].cell(row=count, column=i+1).value=row[i]
    count+=1
 
targetFile.save(savepath)

"""Copy sheet from existing spreadsheet to a new file."""

import openpyxl
from pathlib import Path

path = Path("./spreadsheets")  # Where to find spreadsheet files

# Open the existing spreadsheet file and get the worksheet to copy.
source_wb = openpyxl.load_workbook(path / "test.xlsx")
source = source_wb["Sheet1"]

# Make a new workbook and rename the first worksheet.
wb = openpyxl.Workbook()
target = wb[wb.sheetnames[0]]
target.title = "Source File Sheet Name"

# Copy values from source to target.
for row, row_values in enumerate(source.values, start=1):
    for column, value in enumerate(row_values, start=1):
        target.cell(row=row, column=column, value=value)

# Save copy
wb.save(path / "copy.xlsx")