当前时间： 2026-05-31 23:23:53
分类：办公文件
评论(0)
【问题解决】excel一维表转二维表真好用! 好久没上来了，最近小编在开发公司产品，天天在加班
今天在写代码时，需要将数据库中的基因集放到python脚本里，300多个，有点麻烦。没想到excel还是很贴心的，瞬间就能搞定，棒棒哒。
而数据原始下载文件中，这些基因是单列的，总共307个……WRAPROWS和WRAPCOLS都是可以的，前者是按行完成，后者按列完成。 excel中对这两个函数的描述为：将一维数组按行/列转化为二维数组。 在小编的表格中，这307个基因在B2:B308中，想着做成“30行x11列”的矩阵表，因此，在I2空单元格中，写入：=WRAPROWS(B2:B308,11,"")，回车即可。 同理，如果对B2:B308有按列分布要求的，就可以写成：=WRAPCOLS(B2:B308,30,"")，回车即可。最后面的""，是避免出现空单元格，否则会显示“#N/A”，会很丑……在用记事本等文本文档，将转化好的矩阵表复制进去后，批量替换，即可得到想要的格式了~
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-06-11 23:56:33 HTTP/1.1 GET : https://www.yeyulingfeng.com/a/619216.html
- 运行时间 : 0.198801s [ 吞吐率：5.03req/s ] 内存消耗：4,570.71kb 文件加载：145
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=a87592afc61e75e6455331ac71e05ce1
- CONNECT:[ UseTime:0.000844s ] mysql:host=127.0.0.1;port=3306;dbname=wenku;charset=utf8mb4
- SHOW FULL COLUMNS FROM `fenlei` [ RunTime:0.001334s ]
- SELECT * FROM `fenlei` WHERE `fid` = 0 [ RunTime:0.000605s ]
- SELECT * FROM `fenlei` WHERE `fid` = 63 [ RunTime:0.000573s ]
- SHOW FULL COLUMNS FROM `set` [ RunTime:0.001211s ]
- SELECT * FROM `set` [ RunTime:0.000560s ]
- SHOW FULL COLUMNS FROM `article` [ RunTime:0.001352s ]
- SELECT * FROM `article` WHERE `id` = 619216 LIMIT 1 [ RunTime:0.001152s ]
- UPDATE `article` SET `lasttime` = 1781193393 WHERE `id` = 619216 [ RunTime:0.001422s ]
- SELECT * FROM `fenlei` WHERE `id` = 64 LIMIT 1 [ RunTime:0.000575s ]
- SELECT * FROM `article` WHERE `id` < 619216 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000975s ]
- SELECT * FROM `article` WHERE `id` > 619216 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000994s ]
- SELECT * FROM `article` WHERE `id` < 619216 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.001489s ]
- SELECT * FROM `article` WHERE `id` < 619216 ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.001487s ]
- SELECT * FROM `article` WHERE `id` < 619216 ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.001359s ]
0.201103s
夜雨聆风
