.ʼNᠫ9~wY{\=õldzJ*;_0lr=R * |4QxK u}wz`H񖪨nGfsV)x(  [3D\НE7 Op$ p>1&\‰I`fJRc:n$qOtP6-~ Nfpz,uyBhCyKK㔌èa$!ұ6Zv3Qi"ن 0Djah#`r>LVۏVmp ]3; ^%jVkBYudYYT(;SnbU )s%kwK#6@(lO =a >N''tedjI\MwwS"fZY/(i `5dHm*r[?݄utBAf"d1ƽ0@OFz.ٞ^^֠egmc%H q&ʋ3|{oQ,啢nGw3.&_L\J>a>A,x͜-ey_VL:AE 'sQkS2 {@z,AWy~ o+++b \$DM+?Mz<}&r"za0 ҆. 鞸(xq:^D*xco40tQ׺{@6[$;(8%Wr"xT[?AxcͣgY|ްe Z,ê!s9PWU,(EJnY]f3()hR͗H"L}ؑ Id+Bܔ.Ѣ'N^K>6r77 sъ:wлJK:y,*3N5m>*?QYlG8>iW]p`xLd(ӄ3,q`\OHN~v1AS](z8JWhr³`[3^'hBix5Fo#X6dڨ, 3? 9-1NӺɋ +k8 XbA&ڍd (%Sa#20{lH7Ut6̞hiulz E8AgTЩC)Fc +/Յo#z-,\Q6X7lbtzC騃-(R ]Bix5Fo#X6d$`WUx(A>v\@+C #xW Qum%$Ao`BC}{k1IԚZip1Fvдܤ4rcD 9IٜkhL[:.k*\~4߮U:4$rMFy{5..LXȡLjm3="܁z;>h~W` kg+lPv9)p<ak$!>`S\bs9oJ  $TC]hW(HoO>hCD6,ۡ1r4yK |>7Xo 56-OT>|!{.髿@x)VI0͜i۟]6 GݞGE|,+3_!aAlbP|p⣦J}I&NF UG؂߇$- S0k$9(*",/'LGO))Հo>ZMD+ʹh:ǥ:S;绪Zȶ~h%@5 -Y0>e/B/9j P&Mn-y1o;`Y+jsDn/½k{+h[GMI#~( ɖg&oInTz+AqmzFYlz٫=*مkzL) zɚ]^F*5|}E_G{>h lEXlgl=ZKVЫh͢}-KH0jhΐ=Ur/r9Q1ڢ@HogNo}X"o# S}IDYn銏wAmE:uOXX?uɫƂ`cM_YԸQ^ ̃kF䇗G;^ةǷ=͌ lr-&O7W4lW,DXx-q!vtLcP?wLܟXQLuxbg(LD.먖SR`!RZI)NzblT>2E6_ xԜ]-M=OK&a強jaٵ`@G`i/ 4NzfʇJKp:jLx,R]nzBIknԜ]-M=OK&a強ja /JfIS`&5"`8E܌L' ᜂ<fǮ@wdF:QhZ3,:@|e4  1EWX6R5Jܐ4X^w!7Nl&M\^5ߒfɒ0ãY#73~hV+5t]R? ;v!>erT*&WR(VJN,3E:je1 (8u#. 0ܓLFC57evs `ꥧCq0\X7ԇ=2mSU #8<91:SQ eNJSOB&'&{!J=Wd$C)C4gct寬)z;\fSVփ03fSVփ03fSVփ03񐗎yN&rp lS17n;fSVփ03fSVփ03@* <(eL0r/Ynĵw V"v M]A+Fp+nvDȒi^hi]ei>f YQ'p/\ln F^ȝL(SGu`}S1Rg<`CQKQc>s:J"]>KriݟSs]gYB(j?dYxhCmHTO캊Frٮ:yyQ`VpA^YEm\/V\c%%3}]!Rla', S_GREEN_HDR) # Fila 4 – Período ws.write(4, 0, 'Periodo', S_GREEN_HDR) ws.write(4, 2, int(periodo), S_INFO_VAL) # Fila 5 – Cantidad + Líneas Error ws.write(5, 0, 'Cantidad Registros', S_GREEN_HDR) ws.write(5, 2, float(len(rows)), S_INFO_VAL) ws.write(5, 10, 'Lineas de Error', S_ERR_LBL) for c in (3,4,5,6,7,8,11): ws.write(5, c, '', S_EMPTY_WHITE) # Fila 6 – valor Líneas Error for c in (0,1,3,4,5,6,7,8): ws.write(6, c, '', S_EMPTY_WHITE) ws.write(6, 10, 0.0, S_ERR_VAL) for c in (11,15,16,17,18,19): ws.write(6, c, '', S_ERR_VAL) # Fila 7 – vacía # Fila 8 – barra "Detalle" ws.write(8, 0, '', S_GREEN_BAR) ws.write(8, 1, 'Detalle', S_GREEN_BAR) for c in range(2, 27): ws.write(8, c, '', S_GREEN_BAR) # Fila 9 – números de columna (1..23 con huecos en 7 y 9) num_cols = {0: '', 1:1, 2:2, 3:3, 4:4, 5:5, 6:6, 7:'', 8:7, 9:'', 10:8, 11:9, 12:10, 13:11, 14:12, 15:13, 16:14, 17:15, 18:16, 19:17, 20:18, 21:19, 22:20, 23:21, 24:22, 25:23, 26:''} for c, v in num_cols.items(): ws.write(9, c, float(v) if v != '' else '', S_GREEN_HDR_C) # Fila 10 – nombres de columna hdr_names = [ 'Lineas','RNC o Cedula','Tipo Id','Tipo Bienes y Servicios Comprados', 'NCF','NCF o Documento Modificado','Fecha Comprobante','', 'Fecha Pago','','Monto Facturado en Servicios','Monto Facturado en Bienes', 'Total Monto Facturado','ITBIS Facturado','ITBIS Retenido', 'ITBIS sujeto a Proporcionalidad (Art. 349)','ITBIS llevado al Costo', 'ITBIS por Adelantar','ITBIS percibido en compras','Tipo de Retencion en ISR', 'Monto Retencion Renta','ISR Percibido en compras','Impuesto Selectivo al Consumo', 'Otros Impuesto/Tasas','Monto Propina Legal','Forma de Pago','Estatus' ] for c, h in enumerate(hdr_names): ws.write(10, c, h, S_GREEN_HDR_C) # ============================================================ # DATOS (a partir de fila 11) # ============================================================ for i, row in enumerate(rows): r = 11 + i ws.write(r, 0, float(i+1), S_LINE_NUM) # Linea ws.write(r, 1, row[0] or '', S_DATA_TXT) # RNC ws.write(r, 2, row[1] or '', S_DATA_TXT) # Tipo ID ws.write(r, 3, row[2] or '', S_DATA_TXT) # Tipo Bien ws.write(r, 4, row[3] or '', S_DATA_TXT) # NCF ws.write(r, 5, row[4] or '', S_DATA_TXT) # NCF Mod ws.write(r, 6, row[5] or '', S_DATA_TXT) # F.Comp ws.write(r, 7, '', S_DATA_TXT) # (hueco) ws.write(r, 8, row[6] or '', S_DATA_TXT) # F.Pago ws.write(r, 9, '', S_DATA_TXT) # (hueco) ws.write(r, 10, float(row[7] or 0), S_DATA_NUM) # Servicios ws.write(r, 11, float(row[8] or 0), S_DATA_NUM) # Bienes ws.write(r, 12, float(row[9] or 0), S_DATA_NUM) # Total ws.write(r, 13, float(row[10] or 0), S_DATA_NUM) # ITBIS Fact ws.write(r, 14, float(row[11] or 0), S_DATA_NUM) # ITBIS Ret ws.write(r, 15, float(row[12] or 0), S_DATA_NUM) # ITBIS Prop ws.write(r, 16, float(row[13] or 0), S_DATA_NUM) # ITBIS Costo ws.write(r, 17, float(row[14] or 0), S_DATA_NUM) # ITBIS Adel ws.write(r, 18, float(row[15] or 0), S_DATA_NUM) # ITBIS Perc ws.write(r, 19, row[16] or '', S_DATA_TXT) # Tipo Ret ISR ws.write(r, 20, float(row[17] or 0), S_DATA_NUM) # Ret Renta ws.write(r, 21, float(row[18] or 0), S_DATA_NUM) # ISR Perc ws.write(r, 22, float(row[19] or 0), S_DATA_NUM) # ISC ws.write(r, 23, float(row[20] or 0), S_DATA_NUM) # Otros Imp ws.write(r, 24, float(row[21] or 0), S_DATA_NUM) # Propina ws.write(r, 25, row[22] or '', S_DATA_TXT) # Forma Pago ws.write(r, 26, row[23] or '', S_DATA_TXT) # Estatus # ============================================================ # ANCHOS DE COLUMNA # ============================================================ w = { 0:2200, 1:4500, 2:2000, 3:6500, 4:5800, 5:5800, 6:3800, 7:1600, 8:3800, 9:1600, 10:5200, 11:5200, 12:5200, 13:4400, 14:4400, 15:5800, 16:4800, 17:4800, 18:4800, 19:4800, 20:4800, 21:4500, 22:3800, 23:3800, 24:3800, 25:3400, 26:2200 } for c, v in w.items(): ws.col(c).width = v # Congelar paneles (fila 11 hacia abajo, col A fija) ws.set_panes_frozen(True) ws.set_horz_split_pos(11) ws.set_vert_split_pos(1) ws.set_remove_splits(True) wb.save(output_path) print(f"OK:{output_path}") cur.close() db.close()