o
iX @ s d Z ddlmZ ddlmZmZmZmZmZ ddl m
Z
ddl m Z m
Z
ddlmZ ddefd d
Zdd ed ed
efddZdd Zdedededededed
efddZdS )u[
학습계획표 엑셀 파일 생성
BASE 엑셀 템플릿 생성 및 데이터 채우기
)Workbook)Font Alignment PatternFillBorderSideget_column_letter) PageMarginsPrintPageSetup)PathN output_pathc
C sn | du rt t jjj}|d d } t | jjddd t }|j}d|_tdddd d
}tdd dd d
}tdd d
}t dddd}t dddd}t dddd} t dddd}
t
t ddt ddt ddt ddd} | d d|d< ||d _
||d _tddd|d _d|jd _d |d < ||d _
||d _td dd|d _| d d!|jd" _g d#} d$}
| D ]a\}}}|d% ||< tdd dd&|| _
||| _td dd|| _| || _d'||< ||| _
||| _td dd|| _| || _d(|
}d'||< ||| _| || _d)|j|
_|
d 7 }
qd*|d+< ||d+ _
||d+ _td dd|d+ _| d, d!|jd- _d.|d/< tdd-dd0d1|d/ _
| d2 d|jd _g d3}g d4}t||D ] \}}|| d5 }||_||_
||_tddd|_| |_qcd!|jd _g d6}t|d7d8D ]\}}||d9| < ||d9| _
|dk r| n|
|d9| _td dd|d9| _| |d9| _d'|d:| < ||d:| _
|dk r| n|
|d:| _tddd|d:| _| |d:| _d'|d;| < ||d;| _
|dk r| n|
|d;| _td dd|d;| _| |d;| _d'|d(| < |dk r;| n|
|d(| _| |d(| _d)|j| _qd<|jd9 _d<|jd: _d=|jd; _d>|jd( _td?d?d?d?d@d@dA|_tdBdCd d dD|_ d|j _ d|j _ dE|_ g |_ z |!dFdG t"dH W n t#y } z
t"dI| W Y d}~nd}~ww z |$d>dF t"dJ W n t#y } z
t"dK| W Y d}~nd}~ww dE|_ tdBdCd d dD|_ d|j _ d|j _ td?d?d?d?d@d@dA|_g |_ t"dL|j% dM|j& dN|j |'| dOdPl(m)} || } | j} t"dQ| j% dM| j& dN| j | * t+| S )Ru
BASE 엑셀 템플릿 생성
Args:
output_path: 저장할 경로 (없으면 기본 경로)
Returns:
엑셀 파일 경로
Nstudyplan_filesz base_studyplan_template.xlsxT)parentsexist_oku 学習計画表u メイリオ FFFFFF)namesizeboldcolor )r r 4472C4solid) start_color end_color fill_typeD9E1F2E7F3FFFFF2CCthin)style)leftrighttopbottomzA1:D1A1center)
horizontalvertical u 【基本情報】A3r# zA3:D3 ))u 目標期間B4C4)u 現在の状態B5C5)u 平日学習時間B6C6)u 週末学習時間B7C7)u 希望時間帯B8C8 :)r r r D u 【週間スケジュール】A10zA10:D10
u8 (このパターンを目標期間中繰り返します)A11666666)r r italicr zA11:D11)u 曜日u 学習時間u 時間帯)ABC12u 月曜日u 火曜日u 水曜日u 木曜日u 金曜日u 土曜日u 日曜日
startrD rE rF # g ?g333333?)r# r$ r% r& headerfooter landscape orientation paperSize fitToHeight
fitToWidthA1:D19 d z?BASE Template: Force deleted rows 20-120 to clear ghost stylingz-BASE Template: Could not delete rows 20-120: z jj d? jj |
d@ jj |
dAt j || |
dB| ddl m} || }|j}|
dC |
d;|j d<|j |
d=|j |
d>|jj d?|jj |
dD | | S )Euy
BASE 엑셀 템플릿에 데이터 채우기
Args:
excel_path: 엑셀 파일 경로
total_duration: 목표 기간
current_status: 현재 상태
weekday_hours: 평일 학습 시간
weekend_hours: 주말 학습 시간
preferred_time_slot: 선호 시간대
Returns:
채워진 엑셀 파일 경로
r r\ c s ddl m}m} ddlm} zdt | }g }||\}}||} t jjD ],}
|
j | kr4|
j
krRn q&|
j | krB|
j krRn q&|
t|
t|
q&| |< |d| d| d| d |D ]} | qhW dS ty } zc|d| d | d
zt | }| |< |d | d| W n2 ty }
z&|d | d |
z| | _W n
td
| d |
W Y d}
~
n d}
~
ww W Y d} ~ dS W Y d} ~ dS d} ~ ww )u2 병합된 셀도 안전하게 값을 쓰는 함수r r loggerzSuccessfully wrote z to z (original: )zError writing to : z, trying direct writezDirect write succeeded: zFailed to write to zCannot write to N)r r r app.core.configr r listr r r rz r r appendr
unmerge_cellsdebugrd rx warningerrorrl )
cell_coordrl r r r
start_cellmerged_ranges_to_restorer r r r merged_range_strr e2r r r safe_write_cell sJ
z-fill_excel_with_data..safe_write_cellr z=== Filling Excel ===z Received values: weekday_hours=z (type: z), weekend_hours=r z Duration=z , Status=z Time slot: z) (will be calculated per weekday/weekend)z====================r0 zWrote z (B4): zError writing B4: Nr2 z (B5): zError writing B5: r4 u 時間z (B6): zError writing B6: r6 z (B7): zError writing B7: r8 z (B8): zError writing B8: rH rI rJ rE rF r r u 時間, z
(weekday)z
(weekend)zError writing z or rY rZ z0Force deleted rows 20-120 to clear ghost stylingz Could not delete rows 20-120: rN z-Force deleted cols E-X to clear ghost stylingzCould not delete cols E-X: rX rQ rR r, rS z#=== Excel File Info Before Save ===zmax_row=r[ z print_area=zpage_setup.fitToHeight=z
, fitToWidth=zpage_setup.orientation=zpage_breaks count=zExcel file saved to: z$=== Excel File Info After Reload ===z%=====================================)r} r] rb r r infotyper rx r rm r rv r ry rt r rq ru rz r{ rV rW rT lenr| r~ )r r r r r r r] r r time_slot_for_summaryr target_cellr r r r b_cellc_celltime_slot_weekdaytime_slot_weekendr r r r r fill_excel_with_dataj s 2
,
&
$
r )N)__doc__r} r openpyxl.stylesr r r r r r r openpyxl.worksheet.pager
r pathlibr r r r r r r r r r r s& sK