^gj ddlZddlZddlZddlZddlmZdedefdZ d deed ed ed e de e eff d Z dS)N)Recordbasereturnctjd|}|rI|d|ddz|ddzS|dzS)Nz(\d{4}_\d{2})(.*) _DETTAGLI__ _DETTAGLI)researchstartgrouplstrip)rms TC:\Users\Mauro Gagliardi\Dropbox\adrian\PYTHON\MonitorOsservatorioPy\app\exporter.py_build_export_namerse &--AIKQWWQZZK </!''!**2C2CC2H2HHH + rrecordssource_file_pathsource_basename header_rowctj|d}|j}|dk}d}||D]7}t|jpddkr |j}n8|j} | dz} | dz} | d z} | d z} | d z}||| d ||| d |rH||| d ||| d |||d |D]}|j d kr|j pd}|dkrdn |dkrdnd}||j | | ||j | |j pd |r||j | |j pd ||j | |j pd |jr|jdnd}||j || |r$||j ||j pd t!j}|||dt(j|pt(j|d}t1|dz}||fS)u% Apre il file sorgente e aggiunge colonne sidecar allineate tramite source_row. Colonne aggiunte sempre: 1 TV INVERTITA | CODICE Solo Germania (header_row=6): + CHANNEL | WEEKDAY | DATE (tutte le righe valorizzate) Inversione 1TV: S→N | N→S | C_notte/C_recap/""→"" T) data_onlyNrChannelrz1 TV INVERTITA)rowcolumnvalueCODICEWeekdayDateSNz%d.%m.%Yrz.xlsx)openpyxl load_workbookactivestrr#stripr" max_columncell source_rowprima_tvcod_osschannelweekdaydatestrftimeioBytesIOsaveseekospathsplitextbasenamerread)rrrrwbws is_germany channel_colr/base_col c_invertitac_codice c_channel c_weekdayc_daterecptv invertitadate_strbufrfilenames rexport_xlsx_sidecarrPs   0D A A AB B/JK: tzR & & ( (I 5 5+K E 6}HQ,KQ,HQ,IQ,IQ,FGG ;6FGGGGGG 8hG???@ Jy BBB Jy BBB Jv??? W W >A   l b#::CC3#::CC2  CN;iHHH CN8ck>QTRRR  W GGy @StG T T T GGy @StG T T T8;Jsx((444dH GGvXG F F F F  W GG{#+BUQUG V V V *,,CGGCLLLHHQKKK 7  OQrw/?/?@P/Q/Q R RST UD!$'''1H 88::x r)rr) r7r;r r) app.importerrr,rlistinttuplebytesrPrrrWs SS > > &\> > >  >  5#: > > > > > > r