sales vistanovin
unread,Aug 30, 2025, 6:44:03 AM (8 days ago) Aug 30Sign in to reply to author
Sign in to forward
You do not have permission to delete messages in this group
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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")