UUID
UUID（Universally Unique Identifier）是一种广泛使用的标识符，用于在计算机系统中唯一地标识信息。UUID通常由32个十六进制数字组成，通常以5个部分的形式表示，如下所示：
xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx
具体来说，UUID有128位（16字节），其目的是确保在全世界范围内生成的标识符具有唯一性。UUID广泛应用于分布式系统中，尤其是在需要生成唯一标识符的情况下。常见的应用场景包括：
- 数据库主键：用作数据库表的主键，特别是在分布式数据库中，UUID可以避免冲突。
- 分布式系统的标识符：在微服务架构中，各个服务之间可能需要唯一标识符来标识请求、事务或数据。
- 会话标识符：在Web应用中，UUID常用作用户会话的标识符。
在Excel中生成UUID
在Excel中生成UUID可以通过公式来生成伪ID：
- 示例格式：600d65bc-948a-1260-2217-fd8dfeebb1cd
=LOWER(
CONCATENATE(
DEC2HEX(RANDBETWEEN(0,POWER(16,8)),8),
"-",
DEC2HEX(RANDBETWEEN(0,POWER(16,4)),4),
"-",
"4",
DEC2HEX(RANDBETWEEN(0,POWER(16,3)),3),
"-",
DEC2HEX(RANDBETWEEN(8,11)),
DEC2HEX(RANDBETWEEN(0,POWER(16,3)),3),
"-",
DEC2HEX(RANDBETWEEN(0,POWER(16,8)),8),
DEC2HEX(RANDBETWEEN(0,POWER(16,4)),4)
)
)
- 示例格式：600d65bc948a12602217fd8dfeebb1cd
=LOWER(
CONCATENATE(
DEC2HEX(RANDBETWEEN(0,POWER(16,8)),8),
"",
DEC2HEX(RANDBETWEEN(0,POWER(16,4)),4),
"",
"4",
DEC2HEX(RANDBETWEEN(0,POWER(16,3)),3),
"",
DEC2HEX(RANDBETWEEN(8,11)),
DEC2HEX(RANDBETWEEN(0,POWER(16,3)),3),
"",
DEC2HEX(RANDBETWEEN(0,POWER(16,8)),8),
DEC2HEX(RANDBETWEEN(0,POWER(16,4)),4)
)
)
- 示例格式：4E3B14BB-ECF3-7B2E-A5A2-FE6E1A52DE6A
=CONCATENATE(
DEC2HEX(RANDBETWEEN(0,POWER(16,8)),8),
"-",
DEC2HEX(RANDBETWEEN(0,POWER(16,4)),4),
"-",
"4",
DEC2HEX(RANDBETWEEN(0,POWER(16,3)),3),
"-",
DEC2HEX(RANDBETWEEN(8,11)),
DEC2HEX(RANDBETWEEN(0,POWER(16,3)),3),
"-",
DEC2HEX(RANDBETWEEN(0,POWER(16,8)),8),
DEC2HEX(RANDBETWEEN(0,POWER(16,4)),4)
)
- 示例格式: 4E3B14BBECF37B2E-A5A2FE6E1A52DE6A
=CONCATENATE(
DEC2HEX(RANDBETWEEN(0,POWER(16,8)),8),
"",
DEC2HEX(RANDBETWEEN(0,POWER(16,4)),4),
"",
"4",
DEC2HEX(RANDBETWEEN(0,POWER(16,3)),3),
"",
DEC2HEX(RANDBETWEEN(8,11)),
DEC2HEX(RANDBETWEEN(0,POWER(16,3)),3),
"",
DEC2HEX(RANDBETWEEN(0,POWER(16,8)),8),
DEC2HEX(RANDBETWEEN(0,POWER(16,4)),4)
)