行业动态
techcommunity.microsoft.com ·
@Hacker News
Excel 支持在单个单元格中存放多个值
微软 Excel 官方博客宣布，在 Windows 和 Mac Beta 频道推出 lists、单元格内数组（arrays in cells）和嵌套数组，使单个单元格可容纳多个值，改变 Excel 40 年来一格一值的模型。Hacker News 讨论中有人质疑该功能增加维度后表格可理解性下降，也有人指出类似能力此前已可通过变通方式实现。
AI推荐理由 微软官方博客宣布 Excel 在 Windows 和 Mac Beta 频道引入 lists、单元格内数组和嵌套数组，允许单格存放多值，这是对 40 年单值单元格模型的具体功能变更；但正文仅为公告片段，HN 评论质疑其呈现方式与类型松散带来的可维护性问题，实际可用性和稳定性尚未验证。
62
正文
Domain: techcommunity.microsoft.com
Points: 21 | Comments: 8
## Post Text
Related: [https://techcommunity.microsoft.com/blog/microsoft365insider...](https://techcommunity.microsoft.com/blog/microsoft365insiderblog/put-multiple-values-in-one-cell-with-lists-and-arrays-in-excel/4559395)
[Top Comments]
- Hah, AI-written summary? (Using Buzzfeed's 1-sentence-per-paragraph-for-fifth-grade-reading-skills style). The author is "msexcel, Bronze Contributor", and if I click the username I get a "Cannot find current user" (1).
Anyway, adding an extra dimension on a 2-dimensional spreadsheet (rows, columns, and now depth)? Good luck with that.
(1) OK it breaks for all usernames, I guess because it's Microslop...
- Is [https://techcommunity.microsoft.com/blog/microsoft365insider...](https://techcommunity.microsoft.com/blog/microsoft365insiderblog/put-multiple-values-in-one-cell-with-lists-and-arrays-in-excel/4559395) better? We could swap the URLs.
- You already had sheets in the workbook for depth
- > Throughout Excel's 40-year history, you've only been able to put one value per cell. In this announcement, we're excited to share how that's changing with the release of lists, arrays in cells, and nested arrays, initially to Microsoft Excel for Windows and Mac Beta Channels.
This seems like something I'd expect to already exist in Excel, but the way it's being presented makes it sound like they want to murder Excel.
Would anyone be shocked to find out that I've been smuggling JSON in spreadsheets for a long long time and regret nothing?
- About time! Should have done this from the start instead of spill. That and being able to index into the multiple values in a cell.
- But can I use multiple slurp juices on a single cell?
- Weird, because I remember a job where we had arrays in Excel cells back in 2008.
- Users might see it as a good thing to have yet another feature, but this sort of type-softness is why Excel is bad. In general having every feature of a bad thing, you need constraints to design things, to have idioms.
Making everything flexible is what allows you to make spaghetti that nobody understands.