I've tried to 'reverse engineer' some of our excel sheets, and it's difficult to get the model to stop scolding me for using so many =INDIRECT statements.
Agents still can't automate Excel
11–20 of 20 posts
Re: Agents still can't automate Excel
#12False.
Re: Agents still can't automate Excel
#13My agents can deal with Excel all right. What’s the story?
The story is that the writer is Orcaset, which is trying to sell you their own analysis tools.
Yup. Their benchmark appears to consist of giving an agent XLSX files that use advanced Excel features, but no copy of Excel, and expecting the agents to interpret the spreadsheet the same way Excel would. So the agents try LibreOffice instead, and if that doesn't work, they try to write Python scripts. But the behavior of the Python doesn't match the behavior of Excel.
To put it politely, this seems like a self-inflicted problem. If you really want your agents to interpret advanced Excel features exactly the way Excel would, have you considered maybe giving your agents Excel?
Re: Agents still can't automate Excel
#14> Orcaset takes an entirely different approach to financial modeling. It builds financial models in pure Python code rather than attempting to interpret xlsx files. Model calculations are fully traceable, deterministic, and programmatically accessible by agents. Additionally, since Orcaset isn't limited to a spreadsheet's two-dimensional grid of A1:B2 cells, it can leverage software best practices like type checks to guard against invalid models.
Note that this is just an ad for Orcaset. But more interesting, if you look at Orcaset, they say its product is "Financial Models as Code". So instead of using Excel, you use Python. Reasonable and most serious models are in code. But I still can't figure out what Orcaset adds. It looks like the worst of both worlds. You have this cell concept, but it doesn't relate to an actual workbook so it's not transparent. And then you have the magic formulas and decorators that you have to learn.
@PeriodSeries.define("Revenue", accrual(YF.cmonthly))
def revenue():
for k in Period.seq(date(2026, 1, 1), relativedelta(months=1)):
def cell(p: Period = k):
prior = yield from get_at(revenue, p.shift(-relativedelta(months=1)))
return prior * 1.10 if not isna(prior) else 100.0
yield k, factory
profit = (revenue + costs).named("Profit")
Re: Agents still can't automate Excel
#15flag because submarine article.
Re: Agents still can't automate Excel
#16I once tried using Gemini directly in Google Sheets to make a graph. I never managed to get it to do exactly what I wanted; after wasting way too much time on it I was able to fix the problem in a matter of seconds. It's fascinating because it is quite different from the situation in coding agents where they are in general really quick to read code and find issues/fixes.
Tried Gemini in Google sheets today and it was horrible. I simply asked it to apply a nice visual formatting (bold, header filling, currency signs etc) but it made everything look ugly despite working for 4-5 mins.
Re: Agents still can't automate Excel
#17I once tried using Gemini directly in Google Sheets to make a graph. I never managed to get it to do exactly what I wanted; after wasting way too much time on it I was able to fix the problem in a matter of seconds. It's fascinating because it is quite different from the situation in coding agents where they are in general really quick to read code and find issues/fixes.
Yeah, it seems like such an easy value add (especially since they gate it on gemini subs) to make Gemini do a great job in the google productivity apps, but they are generally pretty awful.
Claude with MCP access to the google workplace APIs consistently does a better job with any manipulation of google docs
Re: Agents still can't automate Excel
#18I once tried using Gemini directly in Google Sheets to make a graph. I never managed to get it to do exactly what I wanted; after wasting way too much time on it I was able to fix the problem in a matter of seconds. It's fascinating because it is quite different from the situation in coding agents where they are in general really quick to read code and find issues/fixes.
Yeah I don't know what's holding it back in the browser, doing stuff to sheets is fine from antigravity.
Re: Agents still can't automate Excel
#19> Orcaset takes an entirely different approach to financial modeling. It builds financial models in pure Python code rather than attempting to interpret xlsx files. Model calculations are fully traceable, deterministic, and programmatically accessible by agents. Additionally, since Orcaset isn't limited to a spreadsheet's two-dimensional grid of A1:B2 cells, it can leverage software best practices like type checks to…
Thanks for reading the article! Responding to what orcaset adds, it lets users define line items than can be composed fluently and safely with strong type annotations. It also adds dependency tracing, memoization, and an iterative solver for cyclic dependencies.
Working on better documentation, the compositional form is probably easier to understand than then decorator. `Cell` might be a bad name as well. It doesn't map 1:1 to a spreadsheet cell, it just lifts a value into a wrapped object that the effect handler can work with.
Re: Agents still can't automate Excel
#20[flagged]