TE
科技回声
首页24小时热榜最新最佳问答展示工作
GitHubTwitter
首页

科技回声

基于 Next.js 构建的科技新闻平台,提供全球科技新闻和讨论内容。

GitHubTwitter

首页

首页最新最佳问答展示工作

资源链接

HackerNews API原版 HackerNewsNext.js

© 2025 科技回声. 版权所有。

Python in Excel – Available Now

73 点作者 masteruvpuppetz8 个月前

13 条评论

vanous8 个月前
It doesn&#x27;t run locally, but rather uses Azure cloud.<p>For local python in a spreadsheet, LibrePythonista allows running IPython code in a LibreOffice spreadsheet<p><a href="https:&#x2F;&#x2F;news.ycombinator.com&#x2F;item?id=41443012">https:&#x2F;&#x2F;news.ycombinator.com&#x2F;item?id=41443012</a>
dijit8 个月前
Does this still run in Azure? I can’t imaging wanting to use such a system with that caveat.
评论 #41560140 未加载
评论 #41559943 未加载
benterix8 个月前
See here for some insights:<p><a href="https:&#x2F;&#x2F;news.ycombinator.com&#x2F;item?id=40656125">https:&#x2F;&#x2F;news.ycombinator.com&#x2F;item?id=40656125</a>
curiousgal8 个月前
They had a chance to charge banks and other financial institutions even more money by letting them run their own local python installations but they missed it.
评论 #41562265 未加载
qsort8 个月前
As someone who&#x27;s not Excel-pilled, how does this work? Is it an alternative language to Excel&#x27;s own formula language or an add-on like VBA?
评论 #41560279 未加载
评论 #41560452 未加载
yawnxyz8 个月前
I&#x27;ve been stuffing JS and API calls into Google Sheets cells and for small use cases its great!<p>When you get very complicated flows, of one cell pointed to another cell, it becomes a massive mess. It&#x27;s hard to debug and there&#x27;s no way to &quot;linearize&quot; the flow into something more legible, and even harder to log everything. I hope Python in Excel figures out how to get over those hurdles
bubblesnort8 个月前
IIRC, Python had a win32 binding over 20 years ago and MS-Office 2000 onwards was scriptable via DCOM.<p>So with a little bit of effort this has already been a thing for 2 decades.<p>Not entirely sure how you move from plain win32 to DCOM, and it&#x27;s probably a bit more difficult than WSH, but it should be doable.
Mister_Snuggles8 个月前
&gt; Python code used by Excel runs on the Microsoft Cloud with enterprise-level security as a compliant Microsoft 365 connected experience, just like OneDrive. The Python code runs in its own hypervisor isolated container using Azure Container Instances and secure, source-built packages from Anaconda through a secure software supply chain. Python in Excel keeps your data private by preventing the Python code from knowing who you are, and opening workbooks from the internet in further isolation within their own separate containers. Data from your workbooks can only be sent via the built-in xl() Python function, and the output of the Python code can only be returned as the result of the =PY() Excel function. The containers stay online as long as the workbook is open or until a timeout occurs. Your data does not persist in the Microsoft Cloud.<p>This is disappointing. A much easier way to &#x27;keep your data private&#x27; would be to run it locally. Surely a bundled Python interpreter run inside a sandbox that prevents network access would be just as secure, and cheaper for Microsoft since they don&#x27;t have to run any Azure resources to support it.
评论 #41561106 未加载
karlschlosshax8 个月前
I&#x27;ve wanted this for years. I think the best use cases are going to be really boring.<p>If you&#x27;ve ever written a spreadsheet of meaningful complexity, you&#x27;ve probably been forced into a disastrous mess of nested IF statements (or helper columns).<p>Python is soooo much easier to read than the built-in formulas.<p>I&#x27;m excited to try this out!
评论 #41560849 未加载
CodeTheInternet8 个月前
What is the benefit of running Python in Excel vs using Pandas for example?
solarkraft8 个月前
It seems crazy to strongly link your spreadsheets to the cloud.
ok1234568 个月前
This is a mistake. Python tooling is a sandpit. Complicated Excel spreadsheets are another sandpit. Additionally, you can&#x27;t evaluate your spreadsheet formulas if you don&#x27;t have Azure access, and now you have to worry about the &quot;cloud&quot; permissions and storage.
pjmlp8 个月前
&gt; Python code used by Excel runs on the Microsoft Cloud ....<p>Nope, not only there is the security issue, regardless of what is promised, good luck editing those Excel files in flights, or train travels.