convert me this python data to excel sheet please

25 views
Skip to first unread message

sales vistanovin

unread,
Aug 30, 2025, 6:44:03 AM (8 days ago) Aug 30
to openpyxl-users
import pandas as pd
from openpyxl import Workbook
from openpyxl.styles import Alignment, Font
from openpyxl.utils import get_column_letter

# Create a workbook and select the active worksheet
wb = Workbook()
ws = wb.active
ws.title = "صورتجلسه"

# Set page layout for A4 printing
ws.page_setup.paperSize = ws.page_setup.PAPERSIZE_A4
ws.page_setup.orientation = ws.page_setup.ORIENTATION_PORTRAIT
ws.page_margins.left = 0.5
ws.page_margins.right = 0.5
ws.page_margins.top = 0.5
ws.page_margins.bottom = 0.5

# Define a helper function to merge and write cells
def write_merged_cell(start_row, start_col, end_row, end_col, value, bold=True, center=True):
    cell_range = f"{get_column_letter(start_col)}{start_row}:{get_column_letter(end_col)}{end_row}"
    ws.merge_cells(cell_range)
    cell = ws.cell(row=start_row, column=start_col, value=value)
    cell.font = Font(bold=bold)
    if center:
        cell.alignment = Alignment(horizontal="center", vertical="center")

# Header information
write_merged_cell(1, 1, 1, 8, "صورتجلسه رسمی ساختمان ۱۱ واحدی")
write_merged_cell(2, 1, 2, 2, "شماره جلسه:")
write_merged_cell(2, 3, 2, 4, "تاریخ:")
write_merged_cell(2, 5, 2, 6, "شماره صفحه:")
write_merged_cell(2, 7, 2, 8, "محل تشکیل جلسه:")
write_merged_cell(3, 1, 3, 4, "زمان شروع:")
write_merged_cell(3, 5, 3, 8, "زمان پایان:")
write_merged_cell(4, 1, 4, 8, "مدیر جلسه:")

# حاضرین
write_merged_cell(6, 1, 6, 8, "حاضرین")
ws.append(["واحد", "نام مالک/ساکن", "امضا"] + ["" for _ in range(5)])
for i in range(1, 12):
    ws.append([f"واحد {i}", "", ""] + ["" for _ in range(5)])

# دستور جلسه
write_merged_cell(19, 1, 19, 8, "دستور جلسه:")
ws.append(["" for _ in range(8)])

# تصمیمات اتخاذ شده
write_merged_cell(21, 1, 21, 8, "تصمیمات اتخاذ شده")
ws.append(["موضوع", "تصمیم", "مسئول اجرا", "مهلت اجرا"] + ["" for _ in range(4)])
for _ in range(5):
    ws.append(["", "", "", ""] + ["" for _ in range(4)])

# امضای مدیر جلسه
write_merged_cell(28, 1, 28, 8, "امضای مدیر جلسه:")

# Adjust column widths
for col in range(1, 9):
    ws.column_dimensions[get_column_letter(col)].width = 18

# Save the workbook
wb.save("/mnt/data/Formal_Meeting_Minutes_Template.xlsx")

Charlie Clark

unread,
Aug 30, 2025, 6:47:24 AM (8 days ago) Aug 30
to openpyxl-users
On 30 Aug 2025, at 12:44, sales vistanovin wrote:

We don't write your code for you.

Charlie

--
Charlie Clark
Managing Director
Clark Consulting & Research
German Office
Sengelsweg 34
Düsseldorf
D- 40489
Tel: +49-203-3925-0390
Mobile: +49-178-782-6226
Reply all
Reply to author
Forward
0 new messages