iX d Z ddlmZ ddlmZmZmZmZmZ ddl m
Z
ddl m Z m
Z
ddlmZ ddefd Zdd
ed ed efd
Zd Zdedededededed efdZdS )u[
학습계획표 엑셀 파일 생성
BASE 엑셀 템플릿 생성 및 데이터 채우기
)Workbook)Font Alignment PatternFillBorderSideget_column_letter) PageMarginsPrintPageSetup)PathN output_pathc | =t t j j j }|dz dz } t | j dd t }|j }d|_ t dddd
}t dd dd
}t dd
}t ddd }t ddd }t ddd } t ddd }
t t d t d t d t d } | d d|d< ||d _
||d _ t dd |d _ d|j d _ d |d < ||d _
||d _ t d d |d _ | d d!|j d" _ g d#} d$}
| D ]\ }}}|d%z ||< t dd d& || _
||| _ t d d || _ | || _ d'||< ||| _
||| _ t d d || _ | || _ d(|
}d'||< ||| _ | || _ d)|j |
_ |
d z
}
d*|d+< ||d+ _
||d+ _ t d d |d+ _ | d, d!|j d- _ d.|d/< t dd-dd01 |d/ _
| d2 d|j d _ g d3}g d4}t) || D ]B\ }}|| d5 }||_ ||_
||_ t dd |_ | |_ Cd!|j d _ g d6}t- |d78 D ]e\ }}||d9| < ||d9| _
|dk r| n|
|d9| _ t d d |d9| _ | |d9| _ d'|d:| < ||d:| _
|dk r| n|
|d:| _ t dd |d:| _ | |d:| _ d'|d;| < ||d;| _
|dk r| n|
|d;| _ t d d |d;| _ | |d;| _ d'|d(| < |dk r| n|
|d(| _ | |d(| _ d)|j | _ gd<|j d9 _ d<|j d: _ d=|j d; _ d>|j d( _ t3 d?d?d?d?d@d@A |_ t7 dBdCd d D |_ d|j _ d|j _ dE|_ g |_ |! dFdG tE dH n)# tF $ r }tE dI| Y d}~nd}~ww xY w |$ d>dF tE dJ n)# tF $ r }tE dK| Y d}~nd}~ww xY wdE|_ t7 dBdCd d D |_ d|j _ d|j _ t3 d?d?d?d?d@d@A |_ g |_ tE dL|j% dM|j& dN|j |' | dOdPl(m)} || } | j } tE dQ| j% dM| j& dN| j | * tW | 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 日曜日
startrF rG rH # 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>))++29@ !225SS ""4$"???
B B BH >XNNNJN$hOOOKN444K (hRYZZZKHPWXXXI 8xSZ[[[L 8xSZ[[[L
v &!!! K NN7 BtH BtHM BtHM"hJJJBtH"$Ba $BtH BtHM BtHM"fxHHHBtHNN7"$Ba J C)3 %z: : "Rd K K K: ':#,#R#R#R: +: : ): ':#,#R#R#R: +: S6
#6
'6
(*# % q 1BuI BuIN BuIN#vIIIBuINN9 #%Bb JBuI~Bt8TTTBuINNN9 #%Bb 655G!//K;00 " " VS***~
"hJJJ! #%Bb kjjH hb111 + +S9s99
(9s99
-02XX\\<9s99
"+v"Q"Q"Q9s99
*9s99
9s99
(9s99
-02XX\\<9s99
"+x("S"S"S9s99
*9s99
9s99
(9s99
-02XX\\<9s99
"+v"Q"Q"Q9s99
*9s99
9s99
-02XX\\<9s99
*9s99
(*# %% ')B #&(B #&(B #&'B # "
BO # BM (,BM$%)BM" BM BNC
r3
OPPPP C C C
AaAABBBBBBBBC
@
q"
LMMMM @ @ @
>1>>????????@ BM # BM (,BM$%)BM" "s#3sSV_bcccBO BN
u
u
u"-
u
ufhfs
u
uvvv GGK '&&&&& }[))HH R8;K R RZbZm R R }E }P R R S S S NN { s0 6%Y
Z&Y==Z%Z, ,
[6[
[time_slot_texthoursreturnc
| }ddddddddd}d }| D ]
\ }}|| v r|} n|rZ|Xt t | d
\ }}|d z |z } | |d z z }
|
d z d z } |
d z } | d
d
| d
}
| d|
S dddddddddd }| D ]
\ }}|| v r|c S d| v sd| v sd
| v r| dd } | S | S )u
시간대 텍스트를 시간 범위 형식으로 변환
학습 시간(hours)이 주어지면 시작 시간부터 해당 시간만큼 계산
Args:
time_slot_text: 시간대 텍스트 (예: "夕方")
hours: 학습 시간 (예: 1, 3) - None이면 기본 범위 반환
Returns:
시간 범위 (예: "17:00~18:00" 또는 "17:00~20:00")
z06:00z09:00z12:00z14:00z17:00z19:00z22:00) 朝 午前 昼 午後 夕方 夜間 深夜
夜間/深夜Nr= < 02d~z 06:00~09:00z 09:00~12:00z 12:00~14:00z 14:00~17:00z 17:00~19:00z 19:00~22:00z 22:00~02:00z 19:00~02:00) r r r r r r r r u 夜間/深夜（19:00〜02:00）u 〜)lowerstripitemsmapintsplitreplace)r r time_slot_lowertime_slot_start_map
start_timekeyrn
start_hour start_min
start_minutes end_minutesend_hourend_minend_time
time_slot_maps r _convert_time_slot_to_ranger s %**,,2244O J)//11
U . J E !
*e' #C)9)9#)>)> ? ?
I"R)3
$urz2 2%+ " 222W222 ))x))) &,9
M $))++
U . LLL ! n 7 73.;P;P'//s;; c J ddl m} ddlm}m} || \ }} || }| j j D ]U}|j |cxk r |j k rj j |
d?j j |
d@t1 j | | |
dA| ddl m} || }|j }|
dB |
d:|j d;|j |
d<|j |
d=|j j d>|j j |
dC | | S )Duy
BASE 엑셀 템플릿에 데이터 채우기
Args:
excel_path: 엑셀 파일 경로
total_duration: 목표 기간
current_status: 현재 상태
weekday_hours: 평일 학습 시간
weekend_hours: 주말 학습 시간
preferred_time_slot: 선호 시간대
Returns:
채워진 엑셀 파일 경로
r r^ c ddl m}m} ddlm} t | }g } || \ }} || } t
j j D ]z}
|
j |cxk r |
j
k ran |
j | cxk r |
j k rGn 6|
t |
t |
{||< | d| d| d| d |D ]} | dS # t$ $ r} | d| d | d
t | }||< | d | d| n[# t$ $ rN}
| d | d |
|| _ n# t% d
| d |
xY wY d}
~
nd}
~
ww xY wY d} ~ dS Y d} ~ dS d} ~ ww xY w)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 r| r r appendr
unmerge_cellsdebugrf rz warningerrorrn )
cell_coordrn r r r
start_cellmerged_ranges_to_restorer r r r merged_range_strr e2r s r safe_write_cellz-fill_excel_with_data..safe_write_cell s XXXXXXXX******) K/J??J (* $--j99HC..s33G !%R_%; < <
8
8 (CGGGG<3GGGGGG (GKKKK|7KKKKKK,33C 4E4EFFF$$S %6%6777 #BzN LL_u__*__R\___ ` ` ` %=
1
1 /0000
1
1 K K K NNUzUUQUUU V V V
K 3B
C C
!&: O O O: O OPPPP
K
K
K E: E E E EFFFK+0BzN((K#$Iz$I$IR$I$IJJJ )((((
K QPPPPP
)((((( KsZ C=D
G G70E('G(
G 2F;
F F; F33F;6G;G GGr 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====================r2 zWrote z (B4): zError writing B4: Nr4 z (B5): zError writing B5: r6 u 時間z (B6): zError writing B6: r8 z (B7): zError writing B7: r: z (B8): zError writing B8: rJ rK rL rG rH r r u 時間, z
(weekday)z
(weekend)zError writing z or r[ r\ z0Force deleted rows 20-120 to clear ghost stylingz Could not delete rows 20-120: rP z-Force deleted cols E-X to clear ghost stylingzCould not delete cols E-X: rZ rS rT r. rU 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_ rd r r infotyper rz r ro r rx r r{ rv r rs rw r| r} rX rY rV 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 s @r fill_excel_with_datar j s '&&&&&
z " "B B.K .K .K .K .Kd 0 '&&&&&
KK()))
KK ]- ] ]mI\I\ ] ]o| ] ] GK LY GZ GZ ] ] ] ^ ^ ^
KKENEE^EEFFF
KK^ 3^^^___
KK'(((,R66 ^444 A[AA AABBBB -!--...
,R66 ^444 A[AA AABBBB -!--...
,R66
%=%=%=>>> F[FF FFFGGGG -!--...
,R66
%=%=%=>>> F[FF FFFGGGG -!--...
,R66 %:;;; H[HH1FHHIIII -!--...
kjjH hb111 SSS Rxx =(@(@(@AAA$?@SUb$c$c! (9::: mV m m} m mf m mPa m m mnnnn =(@(@(@AAA$?@SUb$c$c! (9::: mV m m} m mf m mPa m m mnnn LLC&CCfCCCC D D D =
r3 FGGGG = = =;;;<<<<<<<<=
:
q" CDDDD : : :8Q8899999999: BM # BM BN KK6777
KKC2:CCBMCCDDD
KK-bm--...
KKl"-*CllRTR_Rjllmmm
KKE"-*CEEFFF
KK:S %8%8::;;; GGJ
KK4
44555 '&&&&& }Z((HH
KK7888
KKO8+OO(:MOOPPP
KK3h 133444
KKx(*=*IxxX`XkXvxxyyy
KK8999 NN s 7C: :
D"D D"&7E
F(FF
;G
G.G))G.2;H. .
I8II7J
J: J55J:"B!N
N2 N--N26+O" "
P,P P+P> >
Q*Q%%Q*)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 sV
F F F F F F F F F F F F F F , , , , , , ? ? ? ? ? ? ? ? o o C o o o o dH H HC H3 H H H HV RUXR]`R R R R R Rr