小白专用读取Excel数据

0 • zxz • 1年前 • 665次点击

9287568986cad3f1507156107b2dfc2dccb5e3ebf58a5df8b8043bd220f82170104cd438b6b5c29e721f7649a408691ab48da4c98bc2e68cfb24067dd9522aebf90d5e33e662128c5465e07ff8e019bdef1888b22957b8b5262b921024e5454a28e2279b3da0a5cd0d0e9b4f95cb73a731f338b59b7bda5207e883c0284449eeb63905d99bcb01b40ce3e76d114293a4627d43e70db0473ab62f96af9188b40e62626a29d02aee47c4c7f7709658f2e86bb5787edbf3dc7b2831eb46764138df1fbcd2ee2222952150c3dd8df0af4a4629831ccdac5cb8ce34a734bf2ade630b32c1fa4c239d5f89c5f0fdb59da704e6d08ab1409b44ecb35602baf932f07bcee7ec536b34423842448bbf12d86e538665dc30e91a14ee62bd4b412a6809db6e452a6aa93c91838fe8b9ec5e14b80ae1dfbf636ebdea07648fb0ed6813fece5c878b45259299670b989b5101797daaf78d7ef9ba91b6fbdec9ba79c2491acac5d2f752ca460cac176cebf1db98981daebdec2f842733e81700f9b39e9f96a38d1a4e98c7e442a484808f5902b02e4bcc84086a0d06a25d80851de15d91bc219fec362d89a246cf016af6527d0a473501099d27520bfbeafed526d6fb88390881c385d19038edf508eba009bac102e1045be56c302f7a8b08890350db96aca35abf000bcc9469c9d41120bf2fb63caa178820e20bbc2193e1ddabd13b14349cebc9e177b51130b63b84f13df9b8017bdc164c301863a467e177f4e7e737e9394a53bdc413eff3a61f3b4faac03812b406f5b7d149fe37f6885efa9682f11761c85279431cd5fa8111be3d4d2a3a7db0a8b78302fcb13beefdd244560cdd0b9efa297b87c35de350d8ba569f5801e52ee0edcc5fd04d88e98e1f02749705ce282a9f202e048296228d2017b278edd4cb1fd2f21e8b38ec11a8fdbea0682735faa22f9d1adced51a0c22f2b10059555e17f90ad3145e93447984efcf5cc7da6388bb9e7c99d1b833bf70cc5ff39b9ac82fa8e263127b80f17c00803f437f5ee1682afbbcbcc782de01da81c10bbdd31e6bd06d97d88976fa0974ca656ef0a81ada190345224bff9f8850bf2d728e5076afc49bb1896bafdde7d7db026a4a12901cd779f5333314b6c5c56feda3ac4d98832d67ec3ae04176b4a8996e173767eb97e2cf6e5e2b06bf1595901267e4811f379a51040c0261a8c5174d45bcf1069b0b87cfae9bf1ad8efc6e541fc8f6fa5e0f6760c76df75847bb88bc3dba47387c4bf1fd9e6912174be54723155e586fa2e89de5638cb9f99f57f3fed5ae8b9f43d33401eeb1965052972b9a09be6f4b7dd99edd50a4bbbcb05bd63655539554dcf15b9c47d1f6b86419b3fdff866cac9631e819c0f9896b501732826dec99146f1fcf51f0b522bd46676b8e2cd1ae3f02d66ca7e33145a0449e2635720b32240bf441b4bf9618fe0327c074276264b0eda88fdb78e93d0b049be2f76eb621f0d1012b8b2c92cf12391837c94f30f4eb344ddd354e915f2282eb515b1fc5ab7579ed9c77046ff6153d156692e3a740dff2ab74f2460945fbf8b3f1e984cca3715ba9b68702c1468ffface78dce3cad8fdac6bb701d2b3255115ab613352f4e95ba9a3be9521e07fb604449c6eac32e1c40272bc4166725fe33bf70e9b4c93c1940618c2b8b817db461ec796ebe8f58e775cddbb4297323016a23ccaaec144c0a16ae94a04257a077a01f682f66c56713c2931c3c6240b23d2f783618e8f8969c33f102852d81496c9e01d232e787889be71e3de050d33409869ee100fb708ce405031d5577a1f3a4ddcac781cd464fcbed830b630432b016eb5973f197ffec4fa7f4fdad0bd6ca63e8f284d5fe5960e750be9ae0450eb762edab53377a894fcb4efb6c7fc96b602f8d5e65fc4627714b95e1d4befcf3686ade86e5f3fac62b357bf653d33b62f7411d1e963b2ca58e86180f31b96ae90965f75e88f017d42cc6929d97da87a72faa07db895580a4a4add656e81b05304eb5fb9bc8299a1e3725097c8fcd8f9df0c373eece3fa900ce2538cb6f753977f0b945b9de7913fcb29330abfac56939acff5f8f33de724a3f70c0f8d20c86c6e779771b88eb638b10424c166b916c36abe1a8d71e2717b56b7d438bf4fa47f5fb7a988db74b6e68f6ec8a7751dcf3b99dcc90e90f0f4b281a79f9b990d6003661fa46cc59dfddff843e0ef79e7bf8f5244a3debd1e84c9b2b130c0ac807398ae596ca476e7115860fdd9be4b22aa7947351a5158f05dbc6a932087ec64135d66ecf9909a9e32412f1724911552eb90507085fc0edb5f7f7bac0eb0dc7f2dec5c2304895f29ea7831ce312623029ce5a84c6e609f3443c2e31e5e3471eaa6f779566bac3b5f2e81319f93de7ba4a4f8c491cdc068e82050228c819b09d70b998744d1f49569dcc2364d6bceba8bc350f2ecdb85a8c2b07498d608ae8668ab4b7cdfdeb8a1117fad12d7e13534a9f59f4c1ce3c9eb08ba4d527e5c1a8da7f669287122022ac3a49a79cab52c00a8b891dde616667e495fe7856d42fd604b12a63c4d9374a4ebbc0665823f3663bce879fc50764a01011d935bd749d2dbe087814100ac8973c26087e37a9f917c938e21a62599a271e4db0a17b5cdc63f159ea30456f96724da825a1982ef4101f0b0424f60821ca6b82955fe4119a742b057a6de2290d80463cd378893bddec66fcb46d2554547fb5d77b756871f963d89bbb5c4c0a327ee438857fbf43337889b963e1dee8e898a54ffe870ee35c865c45e866b6727da0d69341334740b4c769c65f0f7d7b884915001cc4c560b8b19288a4da4ccf5586f7487063a17f19a74346b2641be327d283303893337f041fcfa44dc3ec92e985a90ea4d3fff53ad8ae03435c229b7f3121817368864edfeb1a9b6815ea4c01531c3aefb3dd5cb88154b03470be41724d1559e4633d8ab1a1a2aefaca6fe12e6752da41e055df52cbbb4c192225a0f3171198888c2dbc72560abc2905eaea976a8a29426a83bfca5f726fb717aae017a9e088fa81fc36d254a3684f91cee8d409d329d0e84bd992dc8107f5f4bacea7a3b1c979d22fd5aa7454c19d8fb1569c0287d3142556fbd348f4488400354d8b1a99d4649165e7c77b1559527e3a1f662c414da9d301f1533a7d4f211c50642ab355634aa7b105046ef9288f3bc9d20f58641896f9b728318b4b4d4adc3f07cc0ef95b47c63a3142e49e50498464cff7b3ebd4516734f3cc225e51a65e709c31e428f3e9d08396078b962c653696caf8605ddbcb63601d9cdff270dd0c523c9626da43724cf2194cfc9b40178362afad2a4554c59e3372bb67e6fc9e5cd0b7e0661dc511625e7a9536084340152ad2e3f35748bcdc2d7725d87453e4065e6a1952c10f1480c78aa639d2d5702711752e2300b79a52a25b0e777600dc633316012f12ed1b3240ca038cf11b520411196ca699338d4a71ab7ea4b18ab380cbbe06de462f73e8047a7eb605e5b8e15e3d3c38dd56d63c5e700bf2fd1f5f514b90ef8be2c9eafb6283ebf8dcadf12c81debbeedc1308a1de44a05b7974215d461595dbcb137a784648f36323a75822db5cbad135d040413f96a6e6962e76c2012b8121af65b6e1f13bc7e1c2630c9139b29f9799b64ef9239fc9740379977c90f9cac42e616efdf26095c0af2c377104a5c89ff7bbea174bd7a1eba2b322f2c8e9bc5cd8cc63755312b6b1506856142598d4a1698ffdeb1dd32096616bee66748f5152d81f99f7c9541c9d9aa785361f8eb4774ada6e2d65e9b8d43057d59d87e4b80048577aa59a37d4e8a3f1c750760cad08396b2a6bd26094262093bad252b7d5fea7c2ea72097b9303622794f37cdb9cf90ee6b539e7dbb20d4568a94a7a0f9c4c947aac3ddab29338ba5fbee0a04594762d5dd75eac70dba46c67a99955f9f8f930682af8763c44a3809ce51cda35d328ff0a94611e17d324894c56d692b658769ae4089d8d418f935906b913808b3ffc8dcf4df159c716108dfe795e784ac764c1f5191d4f035fae35727ff143707b622faf2bb31638b7344916d63499334b02483b1b97c196c004f3972bc547182e2f9a66290d5cd45b9ed662d5e12407a43ea8ebb3f3109f4103cd40fff98f8ec5edd29eb8515d41897f3d1028e3501fd865c0e1d4a5f130e498ee7aa8879f56a64ab598ce320c5972b3ec53c5aed5bf5ea4ad26eb3d5eea4f82945944ca4a71d473d9b269625db7a0f8698a70df7499e8417af40d665c3dc8a0f823e132600c32be771bcb5130629d2f68b0e21080314dc79bdf3e40a6d0dfdd943c2aa9100227d040063cebbd0b8b1446e7fbff1baa30c9229e87551d632afa11c1a73b2e597f45248d71be5e9248ddcc1b45641c50c20efdf4ffa54cf351a21050ba7307d9cc392abe1a042ae012693f6f6041528d0f406a48187cc1897d90d0a84a86635dbb8871c844e3fcbe36c91ee80258665029ca6bb5395b83ecf2666fd8e5aa58a451144486d41370b09af0ba38d8820f91f307ffa2178a313bb248de46ffc903b73f09175fbdc9eaa5555d008333f854507cf258ed5a187d6036c7d2a11a0c639592116f7cd81728958a8395404d938fee9f3f0223744dffa483580501927941a2367d1a400e832cbd6bf37478a60a309ea50cb21b569c37a268d07a73080f41cb6eefb53fbb08246a0856f340e1784bdd71d4353f13377f945ccbd05eb25a68f0d33a73e74a2cb5a356c700ef1f82391af861582edd25347272d043503d68326d218781d7aefc0ca3c7c4dbadfe0134a2dc77afb84c3c032a2eca84f74c36a9ab9e8cbeb7fbe88d600100b2d0a850d6771b76c8877a34d74435eede304eb3a39c5a736c9f1155645c0c7e695f97447b4d570fd0073746bd30e7b281e8d3a26842c42f970303f4f36d00fb8e02a07a0f1e368455653c0f8e6cb0ffd61e5376056c7847306474bbbec685ab9dfd4701b7e49b52640b3736e2c881c41f37889965d9a74cc7e2de885c0e8482e7617b663810d52bd3007a0e612fd5a859e42261d3c404191f4e412862f259172efc651b9aaa9bc462c141a57c86c243f626d5125b355c0f4160af2d0ac43311798ff63e84af81c769405622a0d7d290b408101e592f0691f087a4b039cd869c780ba39ab2fcc79dba90102259f92723a52a2c23271d8bd6326df1a1870c1f0ab3a72c82f0f283c826e898fef03dc5edbc365467a69c342264e349775b035d636376d065825d771b23962e529e7b6009c04153c8a4ed43f330a91be038f704da58b499bc67afe0f08d0ef1457e2ec68b6cb488912e45a97500d1a6edd1eccbdad35ea28f9b7e4713f60b12ce7b2ad8c635aa7b76c116631ab13dfc103ffc87a1d9776ebf156481da5f408051bae14c8251a7941f9af59eb7033e6898ecf93707a53cef6b5b206f17e4eb6b5d709da102cc976dfe8a3a09700f69f748688818bd9fc3161afea65dcc76851a4518fa04ea1b677d358dc11d5fd46ba9e97c1b1b44caac288c99d782d66fc3c86caf2b9214d7332a6a4ceb86026c0c505fbb2dc07ba94e6f6066f73d5922a1f7033d64181581cdd80592e13b58962d7e1d3b9feee4eabcf6e28399724d642ce94810cf12046981d70af8e42d648170bc3e4864d450b0f63ca34b95e9d76812b90bb52d117221b0aa96307332a821a47383f44e9548680ca82a9bbdedd030cde0926e94eac7f23fd46bc861abdbd8e5ceae112e1a60838245d1f20b836a8361a52e83521c33a6e4a238b7bb72e5473ddf1e4e9829314df0a846507c8cbb4c2d60e035051105c422c0f8fc37fedb78cce13f9f32d5dd61df7d143013239141ee3417bd8217a37c26cd9a0e8c0ee73a187034c790dfd56aa47ceb569b96325c4a59aa08384881e6b3abdbfde1ea9ed5479fa75b5e1debc35b335496ca4271907cc8a07e4ced3a91b1833af2ab45a1882327a7dd59a5ef228d477a92fe555790a4a7b307c0d78f446685aaf35928f26ef46f79adad9869b9b50976d394ca50e3fb4bcacc43e8dc7776852d4db8678cac442cb349bd6b63561895dbfdf51fcddf5bcb74457e298bdf0ebc0d611e409dcc650dbb3752be1f06b1099233e8408b7ee29a1f06723e3f83aa168f08f091f31df761ea216355ec5e8d4493d5b27efee8b15641e02677d2b1e6412bb8403bbd21fdb595855e19816718f266d14ec24cda3c5afea8fff54fa83f065d225a25d276c5a14397e852228065efe5db2df461744b287d8235092e6f46a90e73913462382f05f010339659385cc049c0b282e777e39c1c101b2b8c1d100a217993d1012c448c0cc9983b64c532d977ab52b2e9fc33c3180c41119b1717e943471c3612fd3988f83a6b6da1ab1d17e34548a257f78b4c7ea50f56ab416c53ba2f669ee20b09524a9be7463943921ba796c8f009ddfd8bc83dcb5e6454bf6972e3553ed8e0f5a54665aa89625174f13d90428f65c1c6f8a46c21c81c64904fa3d5315f8f91629300b2ce36b6485938754ce18b5a93ed5351507e9a08390a42ad929d9faef5d4bf72b277f06516ce3d67e578ed66cb0b8c2582f8f93a5bb65e24ec44c7b657b846ff07e6185e076b55d2508c730fb85c91fb4fff1234b8c7edcbb8a8f433c55a54c094171f1029d7b0bbccff7b54f99e46fa2c04095790801b61479bc471c9477ed1eda86776993bca92ce69e4ff5034e6196662d3448e0457effc1513524d95a25918c348c2dbe2d43817c6d335c3155b3043d9c6c24707eca908f48dad636739a5ace0f408f57c47ee2484b7d3ddc6342a09bc007b91addc9cdfc1b7015f09d191624185c73a8f5aa6caf314ce350a966fc8c4caddf7ddbca7fc0545d48162e138be1d2b343a7421ae69f761bf9babba1ebfbe969db2884ad32b786553de1aa40692300f3c264461486af0f33325eb3507814d856f756a79e2b8c921dce37302b5b651457dcb1a8f93d99de8ac3b1279bb11a1c34f1e2f5eff2aebdd0c543fc8e9bebb34bb8d7847dbdd5c0a9281827b7e63c9fb0268636f40cc997d6351a4832438c5c5610d856c69e4d3b3b70b0d8872070658a19fb55b663e68afcc1a584d0da7effa2208deb32a2d1251fbfbcd7028885ad896e5df37dc17e42ea24bd744f5474900b1dc50fa62d67678e7a46e8fe1b6775491a78d46873a8ac8e23e8af3616160ce3200cfe2340cf1b398640a99bd15d7c308d4bcff8b97786d71914febbda1fe97a302b68c76181edf3f6d20c415667ae2120efd946a5acc73cc98bc013ac8eb3abcdad39c7aad318b349652c439eaa92e3754532da80c24c19573a731577f24919a55fd72c6300eac35abadf67495eebb81086453223bc13efa44cd60903c178a7dd2bc513192cbee74e7c9e84ddd8011f3884013b336a755f382f286574da975959ecd6c036299b11b2922370eb364d91f84eb43d6878aba6b6d6a06f3ab06277c1819877a05525e5a279e91e77076e0740228f206d4a027d1f8266850e09cd531403ababc837ad3393a57c66411b7b3ca11161ddb8287fbaeef864cbf1c3d8a1d0ce2397e6a2c59d0017409ada4667834ea29bac5e1c4742af7121dd8dab978016d4a6b25d41febe460f88852f7dc5ce4a677e259664585df10a79b3e63ca37f3cd8baec7b34578a3fd42715ad00828820f2fefdf76842df3d85f4750a15fedd26852d4530316d36c66c22c183190127a06723c91523da2241499a049d4f730b3813073e590806472575f227b29fe91640b6dd4f1025aebfd2cae06fafc349d411f48e359a0383e154be1f4c2d4fdb7e7f8ae708e2327bccab112908ab1428dc924f5b23fcb09f40dd46f4bd2c541420c5ccb560fa933696a52d3fe3b41ad6781e431e1c3a23419c0918eee9b42e37a9c5c3f0d0fabd35034bbdaeb98b4264cb3e2a756c7d14c65ca8cf15e4b20b00c50700cd66cfcae569b70c39cf73a3d56f0634f04a67fa2155f6e6af81f5378010d440dec22f952ec7ee641c916ba63139171e72cd32ce05861b0f5d4c67fafc2890440fe5a23a53d425fa65d388ae917444e671510780172b64f089ff073065ed9deb5f0b26c30fefe896eb3f474ce9611b2b0f0bdce4b67a719ad62ca9954d2eade59f800ceeb5bcde7e392b004bfd7334b757d120c2fd0474422447ad9f6625cf6b1dc481b7034f0f1f3f35536451b552be443e7bb19b1d9062d57d5ef78e4bba72c018920a4ada9509b88dd001178616b5eb253b202616d8f4692446267906d389d943f20bd0e07b90847ac54e3dd3e6c43ef6e7cdb0eef78e50b2197df6e9d8e32847dd4bcf70691af94708d218706705b01b2dbdce59a65daf764ae4d1d89f9d0638211965748661c1b71ce480d83a873fdad8376cc17378ebc1750c2b4e09809b56cb177c9aa2c22e3496cfc50a238f5c4ba42a6c9f212349176bb651a6caf162465ffdb31115c8b63f0377c1aab7813cc8bf9d07afc607b6a4bbf2bd0a3f03b0ad9d16bc50f44a25dfc0ab94da2caf7305dd06046bdd006549a50f10131189377c004885ba9be87de602248944e0925b8d8daaf880f726570bcb44be3783042775e7c6039f885e4c52fbe5c4829167f86858dfc88e3668187415b45a96f19466c438d743d7413c04ca07cdaadc6d84ecfe23a5a453ebfaa6b7135f3349e4e80782c465e14fbd9a7c4d9b0e6de2f32947c808deb0695c9d5b2d1b5d9b204fc7e6d861d1e1bb80671467b7f64d56e7bdbe3dac8accde054c1a885e54307be035368ffe2cb15433cb8cbe442d628e64c083b059611715192b125f9ddf9bd32edea8885e162624a1369993c02ae2f1dda433f0a115615fff657c31ef7c449040353aa8eba37be309c90d9691a4ec8edd2c3581e0efd0632803d8813901c10a63e6fbeb938f0bade8aea442d26edf975834241176bbbc5f8e0d16b3edb8f68567e6b3b95af31fe982b5e93c1c64a767ee544cfd5ebda2f96757a04ceb2390bcd17962b29a288dbe947118b72a724d18511c005b5128c088fd15ee973badf87b7ae5aea2b9d1f5f929898a8f9fab2469b2530d5a62d030272811777e3026852ff4e74699132d4b86b6fff49a16a3a669fbf96e3ecfa9920f802e3c1dcf6e2b06c1a078877fc89580e3e34b77c2252aabb87a0a9e38e3fa0d2e07ead080ec33b99e7edcb31f2124c323703104d74bb8490e88e52ea44c70881e884b0db9fdba9b26ee4eaca3183e4a8c00889ebb1f0c2527058867d888689c8b556918d74e5f7e2d4adc5a1beff84641858c4c99a95df1a20b3d106472b961d0a90fa65a0b797b71f319a234e7456bf4922407aa2640c5d9a9c77e4e05cdb6e623f1cec1e7f2a8ff27fa46cbe43162042f9336cbac4fb0ae13644bf5140389e0c400a310f5ff2d20a3af0a2c906f1ef76ff85a174c90456335

自定义指令

共 3 条评论

zxz [楼主] 1年前

0

读取Excel文件指定工作表、行和列的数据，支持灵活的中文输入口，支持多行多列区间选择，并自动处理各种异常和空数据。

2. 输入参数说明

Excel路径
Excel文件的完整路径（支持本地或网络路径）。
工作表_索引
工作表编号或名称。
- 输入1代表第一个工作表，2代表第二个，以此类推。
- 也可以直接输入工作表名称。
列_索引
需要读取的列，可以用多种方式指定：
- 单列：如
```
A
```
  、
```
1
```
  、
```
-1
```
  （最后一列）
- 多列：用“-”分隔，如
```
A-B-F
```
  或
```
1-2-6
```
  ，代表多列
行_索引
需要读取的行，可以用多种方式指定：
- 单行：如
```
1
```
  、
```
-1
```
  （最后一行）
- 多行：用“-”分隔，如
```
2-3-4
```
  ，代表多行

3. 输出格式说明

单个单元格
如果只选中一个单元格（如A1），函数返回该单元格的内容（字符串），如：
```
Insert
"张三"
```
单行或单列
如果只选中一行或一列（如A列、2行），函数返回一维列表，剔除空单元格，如：
```
Insert
["张三", "李四", "王五"]
```
多行多列
如果选中多行多列（如A-B-F列和2-3-4行），函数返回二维列表，每个元素是一行，剔除空单元格和空行，如：
```
Insert
[
    ["张三", "男", "北京"],
    ["李四", "女", "上海"],
    ["王五", "男", "广州"]
]
```
多列单行或多行单列
如果选中多列单行（如A-B-F列，第2行），返回一维列表，如：
```
Insert
["张三", "男", "北京"]
```
如果选中多行单列（如A列，2-3-4行），返回一维列表，如：
```
Insert
["张三", "李四", "王五"]
```
无数据或异常情况
如果指定的工作表、行、列或单元格没有数据，会返回明确的中文错误提示，如：
```
Insert
"没有这个工作表：2"
"A列没有数据"
"第3行没有数据"
"A3单元格没有数据"
```

4. 示例用法


python
Insert
# 读取第1个工作表A1单元格
读取Excel数据("D:\\test.xlsx", 工作表_索引=1, 列_索引="A", 行_索引="1")
# 输出示例："张三"

# 读取第1个工作表A、B、F三列的所有数据
读取Excel数据("D:\\test.xlsx", 工作表_索引=1, 列_索引="A-B-F")
# 输出示例：二维列表

# 读取第1个工作表第2、3、4行的所有数据
读取Excel数据("D:\\test.xlsx", 工作表_索引=1, 行_索引="2-3-4")
# 输出示例：二维列表

# 读取第1个工作表A、B、F列，第2行的数据（A2、B2、F2合并为一维列表）
读取Excel数据("D:\\test.xlsx", 工作表_索引=1, 列_索引="A-B-F", 行_索引="2")
# 输出示例：["张三", "男", "北京"]

canyang 1年前

0

66666

canyang 1年前

0

大佬请教下如果读取从第4行开始到最后一行的内容需要怎么表达

添加一条新评论

登录后可以发表评论去登录