ling516
V2EX  ›  Excel

excel 一个单元格能存多少字节的数据呢

  •  
  •   ling516 · Dec 27, 2021 · 2629 views
    This topic created in 1776 days ago, the information mentioned may be changed or developed.
    3 replies  •  2021-12-27 10:29:26 +08:00
    wangkun025
    wangkun025
    Dec 27, 2021
    1
    帮你 google 了 excel cell max character limit
    结论是 32,767 characters
    ggmood
    ggmood
    Dec 27, 2021 via iPhone
    2
    @wangkun025 #1 这么说,粘贴一张图片占用的不是单元格的空间。excel 数据存储分层?
    jifengg
    jifengg
    Dec 27, 2021
    3
    @ggmood 找个 xlsx 的文件,后缀改成.zip ,解包,如果有图片,就能在 media 目录里看到了,文字的话是在 string.xml 里的。单元格存的是图片路径和文字引用。
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   1212 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 28ms · UTC 17:43 · PVG 01:43 · LAX 09:43 · JFK 12:43
    ♥ Do have faith in what you're doing.