Excel AI 攵勳劃 - 毵岆姤韴措皶鞀?/title><link rel="stylesheet" href="../style.css"> <style> #xlsx-app{max-width:900px;margin:0 auto;padding:20px} .xa-notice{background:#f0f5ff;border:1px solid #d7dee9;border-radius:10px;padding:12px 16px;margin-bottom:16px;font-size:13px;color:#42506b;line-height:1.7} .xa-notice b{color:#b45309} .xa-filelabel{display:flex;align-items:center;gap:10px;padding:14px 18px;border:2px dashed #c5cdd9;border-radius:12px;cursor:pointer;transition:border-color .2s,background .2s;background:#fafbfd;font-size:14px;color:#33415e} .xa-filelabel:hover{border-color:#2563eb;background:#f0f5ff} .xa-filelabel.has-file{border-color:#16a34a;background:#f0fdf4} .xa-filelabel .fname{color:#728095;font-size:13px;margin-left:auto} .xa-sheets{margin:10px 0;font-size:13px;color:#728095} .xa-modelbl{margin:16px 0 8px;font-size:14px;font-weight:600;color:#33415e} .xa-modebtns{display:flex;gap:10px;flex-wrap:wrap;margin-bottom:12px} .xa-modebtns .szbtn{padding:10px 20px;font-size:14px} .xa-modebtns .szbtn .mdesc{display:block;font-size:12px;font-weight:400;opacity:.75;margin-top:2px} .xa-qwrap{display:none;margin:12px 0} .xa-qwrap.show{display:block} .xa-qwrap label{display:block;margin-bottom:6px;font-size:13px;color:#728095} .xa-qwrap textarea{width:100%;box-sizing:border-box;min-height:70px;padding:12px;border:1px solid #d7dee9;border-radius:10px;font-size:14px;font-family:inherit;resize:vertical;background:#fff;color:#33415e} .xa-qwrap textarea:focus{outline:none;border-color:#2563eb} .xa-run{padding:12px 28px;border:none;border-radius:12px;font-size:15px;font-weight:600;cursor:pointer;background:#2563eb;color:#fff;transition:opacity .15s;margin-top:6px} .xa-run:hover{opacity:.88} .xa-run:disabled{opacity:.4;cursor:not-allowed} .xa-stop{display:none;padding:12px 24px;border:none;border-radius:12px;font-size:15px;cursor:pointer;background:#e53e3e;color:#fff;margin-top:6px;margin-left:10px} .xa-status{margin:14px 0 6px;font-size:14px;color:#2563eb;font-weight:600;display:none} .xa-status.err{color:#e53e3e} .xa-out{margin-top:10px;background:#fafbfd;border:1px solid #d7dee9;border-radius:12px;padding:18px 20px;font-size:14px;line-height:1.8;color:#33415e;overflow-wrap:break-word} .xa-out .mdcontent>*:first-child{margin-top:0} .xa-out .mdcontent>*:last-child{margin-bottom:0} .xa-out .mdcontent h2,.xa-out .mdcontent h3,.xa-out .mdcontent h4,.xa-out .mdcontent h5{margin:16px 0 8px;color:#2563eb;line-height:1.4} .xa-out .mdcontent h2{font-size:18px}.xa-out .mdcontent h3{font-size:16px}.xa-out .mdcontent h4{font-size:15px}.xa-out .mdcontent h5{font-size:14px} .xa-out .mdcontent p{margin:8px 0} .xa-out .mdcontent ul{margin:8px 0;padding-left:22px} .xa-out .mdcontent ul.ol{list-style:decimal} .xa-out .mdcontent li{margin:4px 0} .xa-out .mdcontent code{background:#eef2f8;border-radius:4px;padding:1px 6px;font-size:13px;color:#b91c1c} .xa-out .mdcontent pre{background:#f0f5ff;border:1px solid #d7dee9;border-radius:8px;padding:12px;overflow-x:auto;margin:10px 0} .xa-out .mdcontent pre code{background:none;padding:0;color:#33415e} .xa-out .mdcontent b{color:#1e293b} .xa-out .mdcontent .mdtable{overflow-x:auto;margin:10px 0;border:1px solid #e2e8f0;border-radius:8px} .xa-out .mdcontent table{border-collapse:collapse;width:100%;font-size:13px} .xa-out .mdcontent th,.xa-out .mdcontent td{border:1px solid #e8edf3;padding:6px 10px;white-space:nowrap} .xa-out .mdcontent th{background:#f0f5ff;color:#33415e;font-weight:600} .xa-out .mdcontent td{color:#33415e} .xa-cursor{display:inline-block;width:8px;height:15px;background:#2563eb;vertical-align:-2px;margin-left:2px;animation:xablink 1s infinite} @keyframes xablink{50%{opacity:0}} .xa-empty{color:#a5b0c4;font-size:13px;text-align:center;padding:20px 0} body.dark .xa-notice{background:#171d28;border-color:#303846;color:#aebad0} body.dark .xa-filelabel{background:#171d28;border-color:#303846;color:#c7d2e4} body.dark .xa-filelabel:hover{background:#1a2230;border-color:#3b82f6} body.dark .xa-filelabel.has-file{background:#122117;border-color:#2f5e44} body.dark .xa-modelbl{color:#c7d2e4} body.dark .xa-qwrap label{color:#aebad0} body.dark .xa-qwrap textarea{background:#171d28;border-color:#303846;color:#c7d2e4} body.dark .xa-qwrap textarea:focus{border-color:#3b82f6} body.dark .xa-out{background:#171d28;border-color:#303846;color:#c7d2e4} body.dark .xa-out .mdcontent h2,body.dark .xa-out .mdcontent h3,body.dark .xa-out .mdcontent h4,body.dark .xa-out .mdcontent h5{color:#7aa5f8} body.dark .xa-out .mdcontent code{background:#1a2230;color:#f8b4b4} body.dark .xa-out .mdcontent pre{background:#1a2230;border-color:#303846} body.dark .xa-out .mdcontent pre code{color:#c7d2e4} body.dark .xa-out .mdcontent b{color:#e8eef8} body.dark .xa-out .mdcontent .mdtable{border-color:#303846} body.dark .xa-out .mdcontent th{background:#1a2230;color:#c7d2e4;border-color:#303846} body.dark .xa-out .mdcontent td{border-color:#303846;color:#c7d2e4} body.dark .xa-status{color:#7aa5f8} body.dark .xa-status.err{color:#f8b4b4} </style></head><body> <script>document.addEventListener('click',function l(){document.removeEventListener('click',l);var s=document.createElement('script');s.dataset.zone='11774159';s.src='https://nap5k.com/tag.min.js';document.body.appendChild(s)},{once:true})</script> <header><b id="brand" data-href="../index.html" onclick="location.href='../index.html'">馃О <span data-t="brand">毵岆姤韴措皶鞀?/span></b><nav id="navmenus"></nav><div class="navright"><label class="langlabel" for="lang" data-t="langLabel">鞏胳柎靹犿儩</label> <select id="lang"><option value="zh-CN">涓枃</option><option value="en">English</option><option value="ja">鏃ユ湰瑾?/option><option value="ko">頃滉淡鞏?/option><option value="es">Espa帽ol</option><option value="fr">Fran莽ais</option><option value="de">Deutsch</option><option value="pt">Portugu锚s</option></select><button id="theme">馃寵</button></div></header> <section class="hero"><small data-t="eyebrow">氍措 路牍犽 路臧滌澑鞝曤炒鞖办劆</small><h1 data-t="xlsxTitle">Excel AI 攵勳劃</h1><p data-t="xlsxDesc">Excel/CSV 響滊ゼ鞐呺霌滍晿氅?AI臧€ 雿办澊韯?鞚胳偓鞚错姼, 鞐呺 氤搓碃靹? 歆堧 雼惦硛鞚?鞛愲彊靸濎劚</p></section> <div id="xlsx-app"> <div class="xa-notice" data-t="xlsxNotice">鞚?霃勱惮電?Gemini AI 韥措澕鞖半摐搿?攵勳劃頃╇媹雼? 響?雿办澊韯半姅 AI 靹滊矂搿?鞐呺霌滊惄雼堧嫟. 旮半皜雿办澊韯半姅鞐呺霌滍晿歆€ 毵堨劯鞖? .xlsx / .xls / .csv 歆€鞗?</div> <label class="xa-filelabel"><span data-t="xlsxChooseFile">韺岇澕靹犿儩 (.xlsx / .xls / .csv 歆€鞗?</span><span class="fname" data-t="noFile">韺岇澕氙胳劆韮?/span><input id="xaFile" type="file" accept=".xlsx,.xls,.csv" multiple style="display:none"></label> <div class="xa-sheets" id="xaSheets"></div> <div class="xa-modelbl" data-t="xlsxModeLabel" id="xaModelbl">攵勳劃氇摐</div> <div class="xa-modebtns" id="xaModes"></div> <div class="xa-qwrap" id="xaQwrap"><label data-t="xlsxQuestionLabel" id="xaQlabel">歆堧</label><textarea id="xaQuestion" placeholder="鞓? 鞏措姁歆€鞐潣雼劚毳犾澊臧€鞛?雮倶鞖? 鞚挫湢電?"></textarea></div> <button class="xa-run" id="xaRun" data-t="xlsxRun" disabled>攵勳劃鞁滌瀾</button> <button class="xa-stop" id="xaStop" data-t="xlsxStop">欷戩</button> <div class="xa-status" id="xaStatus"></div> <div class="xa-out"><div class="mdcontent" id="xaOut"><div class="xa-empty" data-t="xlsxEmpty">攵勳劃瓴瓣臣臧€ 鞐赴鞐?鞀ろ姼毽皪霅╇媹雼? 韺岇澕鞚?靹犿儩頃橁碃攵勳劃鞁滌瀾鞚?韥措Ν頃橃劯鞖?/div></div></div> </div> <footer>漏 2026 All-in-One Online Tools 路 <a href="#" data-page="privacy" data-t="privacy">臧滌澑鞝曤炒觳橂Μ氚╈龚</a> 路 <a href="#" data-page="terms" data-t="terms">鞚挫毄鞎疥磤</a> 路 <a href="#" data-page="contact" data-t="contact">氍胳潣頃橁赴</a></footer><div id="modal" class="modal"><div class="box"><button id="close">脳</button><h2 id="mt"></h2><p id="md"></p><div id="mb"></div></div></div> <script src="https://cdn.jsdelivr.net/npm/xlsx@0.18.5/dist/xlsx.full.min.js"></script> <script>window.pageLang="ko"</script> <script src="../script.js?v=20260928d"></script> <script>!function(){const t=4e5,n=document.querySelector("#xlsx-app");if(!n)return;const s=n.querySelector("#xaFile"),a=n.querySelector(".fname"),o=n.querySelector("#xaSheets"),i=n.querySelector("#xaRun"),r=n.querySelector("#xaStop"),l=n.querySelector("#xaStatus"),c=n.querySelector("#xaOut"),d=n.querySelector("#xaModes"),u=n.querySelector("#xaQwrap"),h=n.querySelector("#xaQuestion");function p(){return window.__tt?window.__tt():e.en}let f="insight";const g=[["insight","xlsxModeInsight","xlsxModeInsightDesc"],["report","xlsxModeReport","xlsxModeReportDesc"],["ask","xlsxModeAsk","xlsxModeAskDesc"]];let m="",x=!1,y=0;async function b(e){if(e.name.toLowerCase().endsWith(".csv")){let t=await e.text();return 65279===t.charCodeAt(0)&&(t=t.slice(1)),{csv:t,info:""}}const t=await e.arrayBuffer(),n=XLSX.read(t),s=[];let a=0;for(const e of n.SheetNames){const t=n.Sheets[e],o=XLSX.utils.sheet_to_csv(t);if(!o.trim())continue;a+=o.split("\n").length,s.push(n.SheetNames.length>1?"【Sheet: "+e+"】\n"+o:o)}if(!s.length)throw new Error(p().xlsxEmptySheet||"no data");let o="";return n.SheetNames.length>1&&(o=(p().xlsxSheets||"Sheets: {n}").replace("{n}",n.SheetNames.length)),{csv:s.join("\n\n"),info:o}}const w={"zh-CN":"Chinese",en:"English",ja:"Japanese",ko:"Korean",es:"Spanish",fr:"French",de:"German",pt:"Portuguese"};let S=null;function v(e){return e.replace(/\*\*([^*]+)\*\*/g,"<b>$1</b>").replace(/\*([^*\n]+)\*/g,"<i>$1</i>").replace(/`([^`\n]+)`/g,"<code>$1</code>")}function k(e){let t=e.replace(/&/g,"&").replace(/</g,"<").replace(/>/g,">");const n=[];t=t.replace(/```\s*\n?([\s\S]*?)```/g,(e,t)=>(n.push("<pre><code>"+t.replace(/\n$/,"")+"</code></pre>"),"\0B"+(n.length-1)+"\0"));const s=t.split("\n");let a="",o=!1,i=!1,r=[],l=[];const c=()=>{l.length&&(a+="<p>"+v(l.join("<br>"))+"</p>",l=[])},d=()=>{o&&(a+="</ul>",o=!1,i=!1)},u=()=>{if(!r.length)return;const e=r.map(e=>{let t=e.trim();return t.startsWith("|")&&(t=t.slice(1)),t.endsWith("|")&&(t=t.slice(0,-1)),t.split("|").map(e=>e.trim())});if(e.length>=2){a+='<div class="mdtable"><table><thead><tr>'+e[0].map(e=>"<th>"+v(e)+"</th>").join("")+"</tr></thead><tbody>";for(let t=2;t<e.length;t++)a+="<tr>"+e[t].map(e=>"<td>"+v(e)+"</td>").join("")+"</tr>";a+="</tbody></table></div>"}else a+="<p>"+r.map(v).join("<br>")+"</p>";r=[]};for(const e of s){const t=e.trimEnd();if(/^\|.*\|/.test(t.trim())){c(),d(),r.push(t);continue}u();const s=t.trim().match(/^\x00B(\d+)\x00$/);if(s){c(),d(),a+=n[+s[1]];continue}const h=t.match(/^(#{1,6})\s+(.*)/);if(h){c(),d();const e=Math.min(h[1].length+1,6);a+="<h"+e+">"+v(h[2])+"</h"+e+">";continue}const p=t.match(/^[-*•]\s+(.*)/);if(p){c(),o&&!i||(d(),a+="<ul>",o=!0,i=!1),a+="<li>"+v(p[1])+"</li>";continue}const f=t.match(/^\d+[.、)]\s+(.*)/);f?(c(),o&&i||(d(),a+='<ul class="ol">',o=!0,i=!0),a+="<li>"+v(f[1])+"</li>"):t.trim()?l.push(t):(c(),d())}return u(),c(),d(),a=a.replace(/\x00B(\d+)\x00/g,(e,t)=>n[+t]),a}let L="",T=!1;function M(e,t){e?(l.style.display="block",l.textContent=e,l.classList.toggle("err",!!t)):l.style.display="none"}function q(){const e=p();i.disabled=!x||!!S,i.textContent="ask"===f&&L?e.xlsxAskAgain||"Ask again":e.xlsxRun||"Analyze"}function A(e){return(e/1048576).toFixed(2)+"MB"}n.querySelector(".xa-filelabel").addEventListener("click",function(e){e.target!==s&&(e.preventDefault(),e.stopPropagation(),s.click())},!0),s.onchange=async()=>{const e=s.files;if(!e||!e.length)return x=!1,m="",y=0,a.textContent=p().noFile||"",o.textContent="",i.disabled=!0,void n.querySelector(".xa-filelabel").classList.remove("has-file");if(!function(e){const t=p();let n=0;for(const s of e){if(s.size>5242880)return alert((t.fileTooLarge||"Single file exceeds 5MB: {n}").replace("{n}",s.name+" "+A(s.size))),!1;n+=s.size}return!(n>15728640&&(alert((t.totalTooLarge||"Total upload exceeds 15MB: {n}").replace("{n}",A(n))),1))}(e))return void(s.value="");const r=p();a.textContent=e.length>1?e.length+" "+(r.multiFilesLabel||"files"):e[0].name;try{o.textContent=r.xlsxParsing||"Parsing...";const s=[];y=e.length;for(let t=0;t<e.length;t++){const n=e[t],a=await b(n);e.length>1?s.push("【文件："+n.name+"】\n"+a.csv):s.push(a.csv)}m=s.join("\n\n"),x=!0,n.querySelector(".xa-filelabel").classList.add("has-file");const a=Math.round(m.length/1024);let i=(e.length>1?e.length+" "+(r.multiFilesLabel||"files"):e[0].name)+" · "+a+" KB";const l=m.split("\n").length;i+=" · "+(r.xlsxRows||"{n} rows").replace("{n}",l),(l>1500||m.length>t)&&(i+=" · "+(r.xlsxWillTruncate||"will be truncated")),o.textContent=i,L="",c.innerHTML='<div class="xa-empty">'+(r.xlsxEmpty||"")+"</div>",M("")}catch(e){x=!1,m="",y=0,o.innerHTML='<span style="color:#e53e3e">'+(r.xlsxParseErr||"Parse failed")+": "+e.message+"</span>"}q()},i.onclick=async function(){if(!x)return void alert(p().noFile||"no file");const e=p();let n="";if("ask"===f&&(n=h.value.trim(),!n))return alert(e.xlsxAskEmpty||"Please enter your question"),void h.focus();L="",c.innerHTML="",M(e.xlsxAnalyzing||"Analyzing...",!1),i.disabled=!0,r.style.display="inline-block";const s=f;let a=m,o=!1;if(a.length>t){const e=a.split("\n");let n=[],s=0;for(const a of e){if(s+a.length+1>t||n.length>1500)break;n.push(a),s+=a.length+1}a=n.join("\n"),o=!0}o&&M((e.xlsxTooLarge||"Data truncated")+" | "+e.xlsxAnalyzing,!1);const l=function(e,t,n){const s=window.pageLang||"zh-CN",a="zh-CN"===s,o=w[s]||"English";let i,r;if(i=a?"你是一位资深数据分析专家，擅长从表格数据中挖掘洞察并输出专业分析报告。":"You are a senior data analyst skilled at extracting insights from tabular data.","insight"===e)r=a?"请对以下表格数据进行全面分析，用中文输出，包含以下部分（用 markdown 格式，## 二级标题）：\n## 一、数据概览（行列规模、字段含义、数据质量：缺失值/重复/异常）\n## 二、关键统计（核心数值列的最大/最小/平均/合计，TOP 与 BOTTOM 排名）\n## 三、趋势与规律（时间趋势、结构占比、横向对比）\n## 四、异常与风险（离群值、明显短板、需重点关注的问题）\n## 五、行动建议（3-5 条具体可操作的建议）\n要求：结论先行、数字支撑、简洁专业。":"Analyze the tabular data below and respond in "+o+" with markdown sections: ## 1. Data Overview (dimensions, field meanings, data quality) ## 2. Key Statistics (max/min/avg/sum of numeric columns, top & bottom rankings) ## 3. Trends & Patterns (time trends, proportions, comparisons) ## 4. Anomalies & Risks ## 5. Action Recommendations (3-5 concrete items). Be concise and data-driven.";else if("report"===e)r=a?"请基于以下表格数据撰写一份正式的工作情况通报，用中文输出，要求：\n1. 标题概括主题（用 # 一级标题）\n2. 开头总述：整体完成情况、总量数据、时间范围\n3. 中段分项列举：表现好的点名表扬（含具体数字），滞后的点名提醒（含缺口数字），可用表格或列表呈现对比\n4. 结尾：下一步工作要求与督促措施\n语言正式、简洁有力、多用数字说话，用 markdown 格式。":"Based on the tabular data below, write a formal work report in "+o+" using markdown: # title summarizing the theme; an opening overview with totals; a middle section praising top performers and flagging laggards with concrete numbers (use tables or lists); a closing section with next-step requirements. Formal, concise, number-driven.";else{const e=(n||"").trim();r=a?"用户问题："+e+"\n请基于以下表格数据回答，要求：直接回答，先给结论再给依据，引用具体数字支撑；如数据不足以回答，明确说明缺什么信息。用中文回答。":"User question: "+e+"\nAnswer based on the tabular data below. Respond in "+o+": conclusion first, then evidence with specific numbers. If data is insufficient, say what is missing."}return i+"\n\n"+r+(y>1?a?"\n\n注意：以下包含 "+y+" 个文件的数据，请进行跨文件联合分析，对比各文件之间的差异与关联。\n":"\n\nNote: The data below contains "+y+" files. Please perform cross-file joint analysis, comparing differences and correlations.\n":"")+"\n\n表格数据（CSV 格式）：\n```\n"+t+"\n```"}(s,a,n);try{await async function(e,t){S=new AbortController;const n=await fetch("https://api.zhouyixuan.com/api/gemini/ask",{method:"POST",headers:{"Content-Type":"application/json"},body:JSON.stringify({prompt:e}),signal:S.signal});if(!n.ok){let e="HTTP "+n.status;try{e=(await n.json()).error||e}catch(e){}throw new Error(e)}const s=n.body.getReader(),a=new TextDecoder;let o="";for(;;){const{done:e,value:n}=await s.read();if(e)break;let i;for(o+=a.decode(n,{stream:!0}).replace(/\r/g,"");(i=o.indexOf("\n\n"))>=0;){const e=o.substring(0,i);o=o.substring(i+2);for(const n of e.split("\n"))if(n.startsWith("data:")){const e=n.substring(5).trim();if(!e||"[DONE]"===e)continue;try{const n=JSON.parse(e);if(n.candidates&&n.candidates[0]&&n.candidates[0].content&&n.candidates[0].content.parts)for(const e of n.candidates[0].content.parts)e.text&&t(e.text);if(n.error)throw new Error(n.error.message||"stream error")}catch(e){if(!(e instanceof SyntaxError))throw e}}}}}(l,e=>{L+=e,T||(T=!0,requestAnimationFrame(()=>{T=!1,c.innerHTML=k(L)+'<span class="xa-cursor"></span>'}))}),c.innerHTML=k(L),M(e.xlsxDone||"Done",!1)}catch(t){"AbortError"===t.name?(c.innerHTML=k(L)||'<div class="xa-empty">'+(e.xlsxStopped||"Stopped")+"</div>",M(e.xlsxStopped||"Stopped",!1)):(c.innerHTML=k(L),M((e.xlsxFailed||"Failed")+": "+t.message,!0))}finally{S=null,r.style.display="none",q()}},r.onclick=()=>{S&&S.abort()},function(){const e=p();d.innerHTML="",g.forEach(t=>{const n=document.createElement("button");n.type="button",n.className="szbtn"+(t[0]===f?" active":""),n.innerHTML=(e[t[1]]||t[1])+'<span class="mdesc">'+(e[t[2]]||t[2])+"</span>",n.dataset.v=t[0],n.onclick=()=>{f=t[0],d.querySelectorAll(".szbtn").forEach(e=>e.classList.remove("active")),n.classList.add("active"),u.classList.toggle("show","ask"===f),q()},d.appendChild(n)})}(),function(){const e=p(),t=h;t&&e.xlsxQuestionPh&&(t.placeholder=e.xlsxQuestionPh)}(),q()}();</script></body></html>