excel生成uuid

最新推荐文章于 2024-06-01 21:27:40 发布
最新推荐文章于 2024-06-01 21:27:40 发布
阅读量383 收藏
点赞数 2
分类专栏： 软件应用 文章标签： excel java 前端
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/zhaofuqiangmycomm/article/details/139009385
版权

  • Excel 生成 guid，uuid 格式：600d65bc-948a-1260-2217-fd8dfeebb1cd:
=CONCATENATE(IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),"-",IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),"-",IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),"-",IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),"-",IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)))

 

  • Excel 生成 guid、uuid，格式：6dc1d369295a3bfa9a8f4a98b3320bee:
=CONCATENATE(IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)))

 在excel中下拉即可

你好龙卷风！！！
关注
  • 2
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Excel中UUID
gyh7790的博客
07-07 1601
=CONCATENATE(IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2
Excel生成Guid（UUID）常用格式
CircleSeven的博客
01-13 3717
一、名词解释 维基百科：通用唯一识别码（英语：Universally Unique Identifier，缩写：UUID）是用于计算机体系中以识别信息数目的一个128位标识符，还有相关的术语：全局唯一标识符（GUID）。 根据标准方法生成，不依赖中央机构的注册和分配，UUID具有唯一性，这与其他大多数编号方案不同。重复UUID码概率接近零，可以忽略不计。 UUID的标准型式包含32个16进制数字，以连字号分为五段，形式为 8-4-4-4-12 的32个字符。示例： 550e8400-e29b-41d4-a7
Excel生成UUID
sushiyi651的博客
05-31 1590
1、Excel生成UUID格式：600d65bc-948a-1260-2217-fd8dfeebb1cd。2、Excel生成UUID格式：BC65D2D39CE5E291E053E5500A120FC0。
【mysql、excel生成uuid格式总结】
m0_46459413的博客
02-16 2269
2、Excel生成去除横杠uuid 格式（获取小写的32位随机ID：）：600d65bc948a12602217fd8dfeebb1cs。1、Excel生成uuid 格式：600d65bc-948a-1260-2217-fd8dfeebb1cs。1、生成 有 - 的格式： 56b48f51-add0-11ed-9963-fa173e8e8ca0。2、生成不含 - 的格式：8ada3ef8add011ed9963fa173e8e8ca0。5、生成8位的随机ID。
excel生成uuid的函数
weixin_42455301的博客
09-01 2835
excel生成uuid的函数 =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
mysql、excel生成uuid格式总结
一起码代码
04-22 4523
Mysql 1、生成 有 - 的格式： e3d7387a-c1df-11ec-ac0a-525400625d29 select UUID() as uuid 2.生成不含 - 的格式：1dd13e56c1e011ecac0a525400625d29 select replace(uuid(),"-","") as uuid; 3.insert 使用 INSERT INTO t_table (`id`,`name`) VALUES (REPLACE(UUID(),"-",""),'张三'); Ex
excel生成不重复随机值
06-13
利用excel函数生成不重复随机值，初级excel用户使用
java编写根据模板导出excel
09-13
根据excel模板动态导出数据库数据 package text; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; import java.util.UUID; import javax.servlet....
基于模板的代码生成器LKGenerator1.1.0_x86
02-25
本功能可以根据步骤2中选择的表进行excel文档的生成。 8.清空Beans代码目录。 本功能可以清空生成代码的文件夹，主要为了增强用户体验，让使用者方便打开Beans文件夹并对代码进行修改。 9.打开Beans代码目录 本...
基于模板的代码生成器LKGenerator1.1.0_x64
02-25
本功能可以根据步骤2中选择的表进行excel文档的生成。 8.清空Beans代码目录。 本功能可以清空生成代码的文件夹，主要为了增强用户体验，让使用者方便打开Beans文件夹并对代码进行修改。 9.打开Beans代码目录 本...
java代码生成器源码-wdo-code:wdo-code是Java语言实现的快速开发工具；包含基于POI实现的导入导出excel文件扩展工具
05-19
UUID主键生成扩展工具。 poi-document-extend主要功能 自定义模板导出excel文件。 支持xml配置导入导出excel映射关系。 扩展导入数据回调函数支持批量查询等 版权声明 iBase4J使用 协议. 加入QQ群[216310267] 交流...
帆软10jar包升级
zhaofuqiangmycomm的博客
10-13 2153
1、jeesite.properties数据库连接地址 2、log4j.properties 3、datasource.xml 4、授权文件更换为未授权的 5、lib中tools.jar更换为linux下JDK8的tools.jar 6、如果不用帆软10.0 ①删除WEB-INF/lib下fine-*-10.0.jar ②删除WEB-INF/lib下tools.jar (省去步骤5) ③删除WEB-INF/lib下netty-all-4.1.17.Final.jar ④删除WEB-INF/
网页端app绑定企业微信
zhaofuqiangmycomm的博客
01-24 693
1.设置可信域名 2.创建应用 3.创建自定义菜单 下面就可以愉快的对接企业微信了，我别的博客有对接接企业微信的具体接口对接步骤，欢迎阅读 对接企业微信1：获取企业微信的所有用户_zhaofuqiangmycomm的博客-CSDN博客 对接企业微信2：推送应用消息给用户_zhaofuqiangmycomm的博客-CSDN博客 对接企业微信3：网页授权登录_zhaofuqiangmycomm的博客-CSDN博客_redirect uri需使用应用可信域名对接企业微信4：接收..
navicat联数据库 SSH登陆故障:expected key exchange group packet form server
zhaofuqiangmycomm的博客
01-31 543
etc/ssh/sshd_config 最后面加条配置 然后重启sshd服务。方法二：升级navicat到15这个版本自动支持。方法一：修改ssh配置。
CSDN查找自己的关注 （2020年1月10记）
zhaofuqiangmycomm的博客
01-10 492
以下是查看关注的用户和粉丝链接：关注的用户和粉丝链接：http://my.csdn.net/my/follow 刚刚在CSDN个人账号里找了半天都没找到自己关注的人 对CSDN账号管理感到很迷，很不人性化的设置，找一个自己关注的用户以及关注的自己的粉丝都找不到… 我还算是老用户了从大学接触一直用到现在8年了，期间忘了密码又重新注册了一个，这次真的没法说了，csdn你让我伤心 有其他的方法欢迎评论交流！ ...
mysql数据库分表后 报表的存储过程怎调用
zhaofuqiangmycomm的博客
01-19 429
一、使用数据库中间件 使用像 Mycat 之类的数据库中间件，报表里的简单 SQL 基本都能延续使用（像 Mycat 支持 SQL92 标准），但对复杂 SQL（嵌套查询和多表 JOIN）就比较麻烦，要考虑全局表等设置。而报表业务里复杂查询会很多，有些还伴随过程和逻辑判断，这时用数据库中间件就有点吃力了。 这里列一下报表场景下使用数据库中间件的缺点：< 缺点 > 1. 复杂计算支持不足，且无存储过程替代方案； 2. 多样性数据源支持不足，如报表数据来源还有文件或 NoSQL 时； 3.
用r语言处理 Excel数据当中的缺失值方法
最新发布
qq_43596960的博客
06-01 948
以下是使用 R 编程语言处理 Excel 缺失数据的一些常见方法示例代码：（无需循环）
EasyExcel
qq_52102677的博客
05-30 481
字符串2 2024/5/31 21:16 2.56。字符串3 2024/6/1 21:16 3.56。字符串4 2024/6/2 21:16 4.56。字符串5 2024/6/3 21:16 5.56。字符串6 2024/6/4 21:16 6.56。字符串7 2024/6/5 21:16 7.56。字符串8 2024/6/6 21:16 8.56。
EXCEL生成uuid
09-02
在Excel中生成UUID的方法有以下几种: 1. 生成带有横杠的格式：使用以下公式：=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＊＊＊DEC2HEX(RANDBETWEEN(0,POWER(16,8)),8),DEC2HEX(RANDBETWEEN(0,POWER(16,4)),4))) 2. 生成去除横杠的格式：使用以下公式：=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. 直接生成带有横杠的格式：使用以下公式：=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. 直接生成去除横杠的格式：使用以下公式：=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)) <span class="em">1</span><span class="em">2</span><span class="em">3</span> #### 引用[.reference_title] - *1* [mysql、excel生成uuid格式总结](https://blog.csdn.net/weixin_43423864/article/details/124338402)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"] - *2* *3* [Excel生成Guid（UUID）常用格式](https://blog.csdn.net/CircleSeven/article/details/112561008)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"] [ .reference_list ]

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值