是的,Excel会用尽表名。正如Jules所指出的(并且可以通过在Excel中尝试长名称进行确认),Excel表名限制为255个字符(截至撰写本文时-我正在使用Excel 2010)。因此,可用的表名数量是有限的。
然而,可能性的数量非常高。它不完全是每个字母和数字的组合,直到255个字符的字符串,因为某些组合是不允许的,例如可能还是单元格引用的名称(表名“T100”不允许,因为它也可以表示单元格T100)。
假设您继续从“Table1”命名表到“TableN”:
您的最大表名将是
Table9999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999
如果您每秒添加1000亿个表,则可以添加表格
1,157,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407,407
天。
根据悉尼天文台的说法,在你用完所有的表格名称之前,地球将被太阳吞噬。
随意检查我的计算 - 如果我犯了错误,请纠正:
9,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999,999
/ (100,000,000,000 * 60 * 60 * 24)