Excel生成UUID

最新推荐文章于 2024-02-20 13:16:19 发布

潇湘梦

最新推荐文章于 2024-02-20 13:16:19 发布

阅读量423

点赞数

CC 4.0 BY-SA版权

文章标签： excel 数据库

本文链接：https://blog.youkuaiyun.com/iteye_9328/article/details/132663032

博客指出数据库表导入数据时需要一个ID号，使用Excel导入时会用到。同时给出了uuid格式的示例，如600d65bc - 948a - 1260 - 2217 - fd8dfeebb1cd等。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

需求：
数据库表导入数据的时候需要一个ID号，用excle导入的时候需要用到

uuid格式
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)))

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))