在excel中生成GUID 

=CONCATENATE(LOWER(DEC2HEX(RANDBETWEEN(0,4294967295),8)),"-",LOWER(DEC2HEX(RANDBETWEEN(0,65535),4)),"-",LOWER(DEC2HEX(RANDBETWEEN(16384,20479),4)),"-",LOWER(DEC2HEX(RANDBETWEEN(32768,49151),4)),"-",LOWER(DEC2HEX(RANDBETWEEN(0,65535),4)),"-",LOWER(DEC2HEX(RANDBETWEEN(0,4294967295),8)))

 

posted @ 2017-02-18 08:55  ralflql  阅读(1526)  评论(0)  编辑  收藏  举报