ling516
V2EX  ›  Excel

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

  •  
  •   ling516 · Dec 27, 2021 · 2623 views
    This topic created in 1774 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   ·   2888 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 33ms · UTC 11:01 · PVG 19:01 · LAX 03:01 · JFK 06:01
    ♥ Do have faith in what you're doing.