夜雨聆风 > > 办公文件 > 处理上百个excel数据,以前做3天,现在2分钟
当前时间： 1970-01-01 08:00:00
分类：办公文件
评论(0)
处理上百个excel数据,以前做3天,现在2分钟1、打开你的常用代码工具、kiro、cursor、codex都可以3、对话框里输入自己想要的匹配规则和要求，让它给你处理5、最后让他根据这个可行性的规则，直接给你做一个小工具，后续只要是类似的这种需求，就能直接调用工具进行处理了所以以前需要好几个人好几天的工作量，就这么1s解决了。这里会持续分享我的副业探索、程序员成长、女性成长和生活思考。
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-05-12 19:58:18 HTTP/1.1 GET : https://www.yeyulingfeng.com/a/614255.html
- 运行时间 : 0.372929s [ 吞吐率：2.68req/s ] 内存消耗：4,584.48kb 文件加载：145
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=76ef1f8297534e671c9c21d24ea75fae
- CONNECT:[ UseTime:0.001009s ] mysql:host=127.0.0.1;port=3306;dbname=wenku;charset=utf8mb4
- SHOW FULL COLUMNS FROM `fenlei` [ RunTime:0.001823s ]
- SELECT * FROM `fenlei` WHERE `fid` = 0 [ RunTime:0.002842s ]
- SELECT * FROM `fenlei` WHERE `fid` = 63 [ RunTime:0.000776s ]
- SHOW FULL COLUMNS FROM `set` [ RunTime:0.002508s ]
- SELECT * FROM `set` [ RunTime:0.031705s ]
- SHOW FULL COLUMNS FROM `article` [ RunTime:0.001717s ]
- SELECT * FROM `article` WHERE `id` = 614255 LIMIT 1 [ RunTime:0.017994s ]
- UPDATE `article` SET `lasttime` = 1778587099 WHERE `id` = 614255 [ RunTime:0.005201s ]
- SELECT * FROM `fenlei` WHERE `id` = 64 LIMIT 1 [ RunTime:0.000732s ]
- SELECT * FROM `article` WHERE `id` < 614255 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.008603s ]
- SELECT * FROM `article` WHERE `id` > 614255 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.019059s ]
- SELECT * FROM `article` WHERE `id` < 614255 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.020654s ]
- SELECT * FROM `article` WHERE `id` < 614255 ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.018801s ]
- SELECT * FROM `article` WHERE `id` < 614255 ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.018234s ]
0.379698s
夜雨聆风
