📊 Actualizar Excel — Revisiones Renta COL 0326

Sube el Excel original. El procesador añade las 3 filas en la hoja \"Esf. Comercial\" preservando todo el formato, fórmulas y estilos del archivo original.

\n\n

RENEWALREGUS ESP028, S.L. — Martínez Villergas, 49 · UE 225079 · 1.125 m² · 16 €/m²/mes · Apr-26 → Mar-30

NEW LETTINGNEPTUNE NORTH SPAIN S.L.U. — Castellana, 52 · UE 225041 · 928 m² · 38 €/m²/mes · May-26 → May-33

RE-LETNASH21 WORLDWIDE, S.L. — Don Ramón de la Cruz, 84 · UE 225142 · 477 m² · 31 €/m²/mes · Mar-26 → Mar-31

\n\n

⚠️ Nota: En \"Esf. Comercial (Offices)\" y \"Mov 2026\" estos contratos ya existen y son correctos. Solo se modificará la hoja \"Esf. Comercial\".

\n\n \n

\n\n`;\n return new Response(html, {headers: {'Content-Type': 'text/html; charset=utf-8'}});\n }\n\n // ── POST: Procesar Excel ──────────────────────────────────────────────────\n if (req.method === 'POST') {\n try {\n const fd = await req.formData();\n const file = fd.get('excel') as File;\n if (!file) return new Response('No se proporcionó archivo.', {status: 400});\n\n const buf = await file.arrayBuffer();\n const wb = XLSX.read(new Uint8Array(buf), {\n type: 'array',\n cellStyles: true,\n cellNF: true,\n cellFormula: true,\n cellDates: true,\n sheetStubs: true\n });\n\n const SHEET = 'Esf. Comercial';\n if (!wb.SheetNames.includes(SHEET)) {\n return new Response(`Error: hoja \"${SHEET}\" no encontrada. Hojas disponibles: ${wb.SheetNames.join(', ')}`, {status: 400});\n }\n\n const ws = wb.Sheets[SHEET];\n const log: string[] = [];\n\n // Buscar filas de referencia (de abajo a arriba para insertar en orden)\n const autoregRow = findRowByTenant(ws, 'AUTOREGULACI'); // RE-LET → NASH21 después\n const sorecoRow = findRowByTenant(ws, 'SORECO'); // NEW LETTING → NEPTUNE después\n const salvatRow = findRowByTenant(ws, 'SALVAT'); // RENEWAL → REGUS después\n\n // Insertar de abajo hacia arriba para no desplazar las filas siguientes\n if (autoregRow > 0) {\n insertRowAfter(ws, autoregRow, NASH21_ROW);\n log.push(`✅ NASH21 insertado (fila ${autoregRow + 2}, RE-LET SURFACES)`);\n } else {\n log.push('⚠️ ASOC. AUTOREGULACIÓN no encontrada → NASH21 no insertado');\n }\n\n if (sorecoRow > 0) {\n insertRowAfter(ws, sorecoRow, NEPTUNE_ROW);\n log.push(`✅ NEPTUNE NORTH SPAIN insertado (fila ${sorecoRow + 2}, NEW LETTINGS)`);\n } else {\n log.push('⚠️ SORECO AUDIT no encontrado → NEPTUNE no insertado');\n }\n\n if (salvatRow > 0) {\n insertRowAfter(ws, salvatRow, REGUS_ROW);\n log.push(`✅ REGUS ESP028 insertado (fila ${salvatRow + 2}, RENEWALS)`);\n } else {\n log.push('⚠️ EDITORIAL SALVAT no encontrado → REGUS no insertado');\n }\n\n const outBuf = XLSX.write(wb, {type: 'array', bookType: 'xlsx', cellStyles: true});\n const outName = file.name.replace(/\\.(xlsx|xls)$/i, '_ACTUALIZADO.xlsx');\n\n return new Response(outBuf, {\n status: 200,\n headers: {\n 'Content-Type': 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',\n 'Content-Disposition': `attachment; filename=\"${outName}\"`,\n 'X-Log': log.join(' | '),\n 'Access-Control-Allow-Origin': '*'\n }\n });\n\n } catch (e: any) {\n return new Response(`Error: ${e.message}\\n${e.stack}`, {status: 500});\n }\n }\n\n return new Response('Method not allowed', {status: 405});\n}\n","label",[125],"b3537b8d-3002-4f48-82bf-d3e7270c9f5b",["D",1781631062136],[27],"pulls","branches",1,"forks","envVars",{"_147":58,"_149":58},"connections",{"_147":58,"_148":58},"count","unfilledCount","emptyCount",{"_40":136,"_31":27,"_29":30,"_127":-5,"_38":39,"_37":14,"_129":24,"_35":156,"_13":58,"_32":20,"_33":34,"_23":24,"_134":-5,"_153":157,"_26":158},{"_40":124,"_31":125,"_29":126,"_127":-5,"_38":39,"_37":128,"_129":117,"_35":152,"_13":131,"_32":132,"_33":133,"_23":24,"_134":-5,"_153":154,"_26":155},["D",1781626453560],"children",[],[125],["D",1781631062136],[],[27],["D",1781612571402],{"_92":91,"_99":95},{"_92":91,"_93":-5,"_94":95,"_18":52,"_96":97,"_98":24},{"_13":81,"_31":82,"_40":39,"_83":41,"_84":-5,"_85":-5,"_86":-5,"_87":-5,"_88":-5,"_89":42,"_90":91},"ctx",{"_74":-5,"_119":196,"_197":198,"_199":200,"_201":24,"_202":24,"_203":24,"_204":117,"_205":-5,"_206":-7,"_207":-7,"_208":58,"_209":24,"_210":24,"_211":-5,"_212":24,"_213":24,"_214":24,"_215":-5},"ENV",{"_167":168,"_169":170,"_171":82,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189,"_190":191,"_192":193,"_194":195},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","9e167d8120a57de5d747867e0b686da51bcc19a4","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v4