首页 资讯 关注 民生 区域 汽车 房产 图片 视频 本地新闻

技术

新浪微博 论坛 视频 图片
旗下栏目： 美食 商家 技术 优惠

> 关注 > 技术 >

返回首页

Excel生成guid、uuid

来源：腾讯 作者：网络 人气： 发布时间：2020-10-19
摘要：1、Excel生成guid，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)),DEC2H

1、Excel生成guid，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)))

 

2、Excel生成guid，uuid  格式：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)))

3、Excel生成guid，uuid  格式：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))

4、Excel生成guid，uuid  格式：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))

 

jory—经得起折磨，耐得住寂寞
责任编辑：网络

上一篇：Thinkphp中eq,neq,gt,lt等表达式缩写

下一篇：使用SQLServer导入Excel数据时报错

频道精选

演绎新冠疫情下的爱情 《最后的舞蹈》首发演绎新冠疫情下的爱情 《最后的舞蹈》首发
双节不停工 赣深高铁惠州北站建设全速推进双节不停工 赣深高铁惠州北站建设全速推进

最火资讯

首页 | 资讯 | 关注 | 民生 | 区域 | 汽车 | 房产 | 图片 | 视频 | 本地新闻

湛江网_碧海银沙_湛江碧海银海网_银沙网_湛江碧海银沙论坛，湛江影响力大的论坛社区，关注湛江社会百态。湛江网友可在论坛内相互交流、分享快乐，设有聚焦港城、街拍湛江、银沙杂谈、湛江楼市、亲子乐园、饮食男女、驴游户外等版块。  技术支持：湛江易联

电脑版 | 移动版