[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_152":153,"_154":155},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_115":-5,"_20":116,"_22":117,"_118":119,"_120":121,"_25":122,"_24":-5,"_123":-5,"_124":-5,"_125":53,"_126":127,"_128":44,"_129":-5,"_130":-5,"_131":132},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","yuxiaoy","name","image-to-table","branchName","main","version","path","","project",{"_33":61,"_13":14,"_45":62,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":19,"_69":-5,"_70":71,"_72":-5,"_73":53,"_74":-5,"_75":-5,"_76":77,"_78":79,"_80":-5,"_81":-5,"_82":-5,"_83":-5,"_84":85,"_86":85,"_87":88,"_89":88,"_90":88,"_91":85,"_92":85,"_93":94,"_95":96,"_97":98,"_99":53},"tree",[56],"file","contents",[32],"upstream","pull","ahead","behind","envVars",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":55},"id","628864f2-455e-4ffc-96b0-f786f05fd0b3","main.ts","fileId","1294763c-7958-11f1-8900-1607ee4eb77e","parentId","branchId","fe0d3337-0dc5-422d-96a8-879efd307099","branchVersion",22,"latest",true,"createdAt",["D",1789395771272],19,"fileType","http","content","import { OpenAI } from \"https://esm.town/v/std/openai\";\r\n\r\nfunction toBase64(bytes: Uint8Array): string {\r\n let binary = \"\";\r\n const chunk = 0x8000;\r\n for (let i = 0; i < bytes.length; i += chunk) {\r\n binary += String.fromCharCode.apply(\r\n null,\r\n bytes.subarray(i, i + chunk) as unknown as number[],\r\n );\r\n }\r\n return btoa(binary);\r\n}\r\n\r\ntype CellPos = { r: number; c: number };\r\ntype MergeRange = { s: CellPos; e: CellPos };\r\ntype TableResult = { rows: string[][]; merges: MergeRange[] };\r\n\r\nfunction normalizeTable(parsed: unknown): TableResult {\r\n const raw = parsed as { rows?: unknown; merges?: unknown };\r\n const rows = Array.isArray(raw?.rows)\r\n ? raw.rows.map((row) =>\r\n (Array.isArray(row) ? row : []).map((cell) =>\r\n cell == null ? \"\" : String(cell)\r\n )\r\n )\r\n : [];\r\n if (!rows.length) return { rows: [], merges: [] };\r\n const cols = Math.max(...rows.map((row) => row.length), 1);\r\n for (const row of rows) {\r\n while (row.length < cols) row.push(\"\");\r\n }\r\n const merges: MergeRange[] = [];\r\n for (const item of Array.isArray(raw?.merges) ? raw.merges : []) {\r\n const merge = item as { s?: CellPos; e?: CellPos };\r\n const s = merge?.s;\r\n const e = merge?.e;\r\n if (!s || !e) continue;\r\n const sr = Number(s.r), sc = Number(s.c), er = Number(e.r), ec = Number(e.c);\r\n if (![sr, sc, er, ec].every(Number.isFinite)) continue;\r\n if (sr > er || sc > ec || er >= rows.length || ec >= cols) continue;\r\n if (sr === er && sc === ec) continue;\r\n merges.push({ s: { r: sr, c: sc }, e: { r: er, c: ec } });\r\n }\r\n return { rows, merges };\r\n}\r\n\r\nconst EXTRACT_SYSTEM = [\r\n \"你是表格识别助手。精确提取图中可见的全部单元格文字、行列结构和合并单元格。\",\r\n \"这可能是完整表，也可能是长表的一段：只提取图中实际可见的行，不要臆造看不见的内容。\",\r\n '只返回 JSON：{\"rows\":[[\"文本\"]],\"merges\":[{\"s\":{\"r\":0,\"c\":0},\"e\":{\"r\":0,\"c\":1}}]}',\r\n \"所有行列数必须一致；空单元格填空字符串；合并区域文字仅放左上角；坐标从 0 开始；没有合并时 merges 为 []。\",\r\n \"文字必须原样转录，不要翻译、不要省略、不要改写。\",\r\n \"不得返回 Markdown 或解释。\",\r\n].join(\"\\n\");\r\n\r\nasync function extractFromImage(dataUrl: string): Promise<\r\n { ok: true; table: TableResult } | { ok: false; truncated: boolean; error: string }\r\n> {\r\n const completion = await new OpenAI().chat.completions.create({\r\n model: \"gpt-4o\",\r\n messages: [\r\n { role: \"system\", content: EXTRACT_SYSTEM },\r\n {\r\n role: \"user\",\r\n content: [\r\n { type: \"text\", text: \"请提取这张图片中可见的表格（含合并单元格）：\" },\r\n { type: \"image_url\", image_url: { url: dataUrl, detail: \"high\" } },\r\n ],\r\n },\r\n ],\r\n response_format: { type: \"json_object\" },\r\n max_completion_tokens: 16384,\r\n });\r\n\r\n const finishReason = completion.choices[0]?.finish_reason;\r\n let raw = (completion.choices[0]?.message?.content ?? \"\").trim();\r\n raw = raw.replace(/^```json/i, \"\").replace(/^```/, \"\").replace(/```$/, \"\")\r\n .trim();\r\n if (!raw) {\r\n return { ok: false, truncated: finishReason === \"length\", error: \"模型没有返回识别结果\" };\r\n }\r\n try {\r\n const table = normalizeTable(JSON.parse(raw));\r\n if (!table.rows.length) {\r\n return { ok: false, truncated: false, error: \"未识别到表格内容\" };\r\n }\r\n if (finishReason === \"length\") {\r\n return { ok: false, truncated: true, error: \"表格过密，输出被截断\" };\r\n }\r\n return { ok: true, table };\r\n } catch {\r\n return {\r\n ok: false,\r\n truncated: finishReason === \"length\",\r\n error: finishReason === \"length\"\r\n ? \"表格过密，输出被截断\"\r\n : \"模型返回的数据不是合法JSON，请换一张更清晰的截图重试。\",\r\n };\r\n }\r\n}\r\n\r\nconst HTML = /* html */ `\r\n\r\n\r\n\r\n\r\n截图转可编辑表格 → 复制到 PPT / 导出 Excel\r\n\r\n\r\n\r\n\r\n

\r\n

截图转可编辑表格

\r\n

粘贴表格截图 → 识别（支持合并单元格）→ 编辑 → 复制到 PPT / 导出 Excel

\r\n\r\n

\r\n 点击此处后按 Ctrl/Cmd + V 粘贴截图，或把图片拖进来\r\n

\r\n\r\n

$\"预览\"$

\r\n\r\n \r\n\r\n

\r\n

\r\n 提示：长截图或文字较多时会自动分段高清识别再拼接，不必再手动拆图。
\r\n 识别结果可直接在表格里编辑；「复制到 PPT」会保留微软雅黑+黑色边框+合并单元格。
\r\n 「导出 Excel」会保留数据与合并单元格（Excel 字体/边框可在 Excel 中一键套用样式）。\r\n

\r\n

\r\n\r\n\r\n\r\n`;\r\n\r\nexport default async function (req: Request): Promise {\r\n if (req.method === \"POST\") {\r\n try {\r\n let form: FormData;\n try {\n form = await req.formData();\n } catch {\n return Response.json({ error: \"缺少图片数据\" }, { status: 400 });\n }\r\n const file = form.get(\"image\");\r\n if (!(file instanceof File)) {\r\n return Response.json({ error: \"缺少图片数据\" }, { status: 400 });\r\n }\r\n const bytes = new Uint8Array(await file.arrayBuffer());\r\n if (!bytes.length) {\r\n return Response.json({ error: \"图片不能为空\" }, { status: 400 });\r\n }\r\n const dataUrl = \"data:\" + (file.type || \"image/jpeg\") + \";base64,\" +\r\n toBase64(bytes);\r\n const result = await extractFromImage(dataUrl);\r\n if (!result.ok) {\r\n return Response.json(\r\n { error: result.error, code: result.truncated ? \"truncated\" : \"extract_failed\" },\r\n { status: result.truncated ? 422 : 500 },\r\n );\r\n }\r\n return Response.json(result.table);\r\n } catch (e) {\r\n console.error(\"识别出错:\", e);\r\n return Response.json({ error: String(e) }, { status: 500 });\r\n }\r\n }\r\n\r\n const u = new URL(req.url);\r\n return new Response(HTML.replace(\"__ENDPOINT__\", u.origin + u.pathname), {\r\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\r\n });\r\n}\r\n","deleted",false,"label",[35],{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":59,"_18":60},["D",1789395771272],"children",[],[35],"f267c0bd-eb7a-491f-9b6b-21ff6b9d1736",["D",1783355460069],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","96c2793d-57c8-41d2-a49a-d1ee82f9dd24","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","93515af8-c7b7-459c-9bf2-3bb3df310a75","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_114":110},"org",{"_11":12,"_108":-5,"_109":110,"_70":71,"_111":112,"_113":53},"branch",{"_17":42,"_13":16,"_33":40,"_100":61,"_101":-5,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":14,"_107":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJObXd1QWdCZmVtaUh0bGU5TkswOG1sM0xheiIsImluaXRpYWxzIjoiRlkifQ","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":61,"_13":14,"_45":148,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":19,"_69":-5,"_70":71,"_72":-5,"_73":53,"_74":-5,"_75":-5,"_76":77,"_78":79,"_80":-5,"_81":-5,"_82":-5,"_83":-5,"_84":85,"_86":85,"_87":88,"_89":88,"_90":88,"_91":85,"_92":85,"_93":149,"_95":150,"_97":151,"_99":53},[145],"files",[145],"counts",{"_135":77,"_136":137,"_138":77,"_31":139,"_140":141},[133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":134},[35],"pulls","branches",1,"forks",{"_142":77,"_144":77},"connections",{"_142":77,"_143":77},"count","unfilledCount","emptyCount",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":146,"_18":147},[],[35],["D",1783355460069],{"_11":12,"_114":110},{"_11":12,"_108":-5,"_109":110,"_70":71,"_111":112,"_113":53},{"_17":42,"_13":16,"_33":40,"_100":61,"_101":-5,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":14,"_107":12},"ctx",{"_93":-5,"_130":185,"_186":187,"_188":189,"_190":53,"_191":53,"_192":53,"_193":44,"_194":-5,"_195":-7,"_196":-7,"_197":77,"_198":53,"_199":53,"_200":-5,"_201":53,"_202":53,"_203":53,"_204":-5},"ENV",{"_156":157,"_158":159,"_160":16,"_161":162,"_163":164,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","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"]