📊 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",[126],"fa2ea56f-3cfd-40d0-81fe-d46a226c6470",["D",1781634295290],[27],"22758a27-5567-4fd1-a5ee-01d652b01206","fetchtest.ts","254ea0fe-69a9-11f1-aa0a-1607ee4eb77e",9,["D",1781631882109],5,"export default async function handler(req: Request): Promise {\n const urls = [\n \"https://liquidlab1.sharepoint.com/:x:/r/sites/LiquidLab/Shared%20Documents/Esfuerzo%20comercial/Copia%20de%20Revisiones%20renta%20COL%200326%20(2).xlsx?d=w5c3f4221006b495d901571193a9bc73d&download=1\",\n \"https://liquidlab1.sharepoint.com/:x:/r/sites/LiquidLab/Shared%20Documents/Esfuerzo%20comercial/Copia%20de%20Revisiones%20renta%20COL%200326%20(2).xlsx?d=w5c3f4221006b495d901571193a9bc73d&csf=1&web=0&e=hvi7Hd\",\n \"https://liquidlab1.sharepoint.com/sites/LiquidLab/Shared%20Documents/Esfuerzo%20comercial/Copia%20de%20Revisiones%20renta%20COL%200326%20(2).xlsx?download=1\"\n ];\n const out=[];\n for (const url of urls) {\n const r = await fetch(url, {redirect:\"follow\"});\n const ab=await r.arrayBuffer();\n out.push({url, status:r.status, finalUrl:r.url, contentType:r.headers.get(\"content-type\"), len:ab.byteLength, first:Array.from(new Uint8Array(ab.slice(0,8))), txt:new TextDecoder().decode(ab.slice(0,60))});\n }\n return Response.json(out);\n}",[141],"pulls","branches",1,"forks","envVars",{"_156":58,"_158":58},"connections",{"_156":58,"_157":58},"count","unfilledCount","emptyCount",{"_40":140,"_31":141,"_29":142,"_128":-5,"_38":39,"_37":143,"_130":117,"_35":169,"_13":145,"_32":133,"_33":146,"_23":24,"_135":-5,"_163":170,"_26":171},{"_40":137,"_31":27,"_29":30,"_128":-5,"_38":39,"_37":14,"_130":24,"_35":166,"_13":58,"_32":20,"_33":34,"_23":24,"_135":-5,"_163":167,"_26":168},{"_40":125,"_31":126,"_29":127,"_128":-5,"_38":39,"_37":129,"_130":117,"_35":162,"_13":132,"_32":133,"_33":134,"_23":24,"_135":-5,"_163":164,"_26":165},["D",1781626453560],"children",[],[126],["D",1781634295290],[],[27],["D",1781631882109],[],[141],["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":209,"_210":211,"_212":213,"_214":24,"_215":24,"_216":24,"_217":117,"_218":-5,"_219":-7,"_220":-7,"_221":58,"_222":24,"_223":24,"_224":-5,"_225":24,"_226":24,"_227":24,"_228":-5},"ENV",{"_180":181,"_182":183,"_184":82,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202,"_203":204,"_205":206,"_207":208},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","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 · v10