{ "info": { "author": "malongge thomas", "author_email": "794589200@qq.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 5 - Production/Stable", "Intended Audience :: Developers", "License :: OSI Approved :: MIT License", "Programming Language :: Python :: 2", "Programming Language :: Python :: 2.6", "Programming Language :: Python :: 2.7", "Programming Language :: Python :: 3", "Programming Language :: Python :: 3.3", "Programming Language :: Python :: 3.4", "Programming Language :: Python :: 3.5", "Topic :: Software Development :: Build Tools" ], "description": ".. image:: https://travis-ci.org/malongge/exceltojson.svg?branch=master\r\n :target: https://travis-ci.org/malongge/exceltojson\r\n\r\n\u4e2d\u6587\u5e2e\u52a9\u6587\u6863\r\n=======================\r\n\r\n-h | --help\uff1a \u5e2e\u52a9\u6587\u6863\r\n\r\n-S | --notShowRow: \u9ed8\u8ba4\u8868\u5355\u4e2d\u7684\u884c\u53f7\u5c06\u4f5c\u4e3ajson\u6587\u4ef6\u4e2d\u5185\u5bb9\u7684\u5173\u952e\u5b57\uff0c\r\n\u5982\u679c\u4f7f\u7528\u4e86\u8fd9\u4e2a\u9009\u9879\uff0c\u90a3\u4e48json\u6587\u4ef6\u4e2d\u7684\u5185\u5bb9\u5c06\u4fdd\u5b58\u7684\u662f\u5305\u542b\u8868\u5355\u4e2d\u884c\u5185\u5bb9\u4e00\u4e2a\u5217\u8868\r\n\r\n-s | --sourcePath: \u8981\u8f6c\u6362\u6210json\u6587\u4ef6\u7684excel\u6587\u4ef6\u6240\u5728\u7684\u8def\u5f84\r\n\r\n-o | --outDir: \u751f\u6210\u7684json\u6587\u4ef6\u6240\u5b58\u653e\u7684\u76ee\u5f55\r\n\r\n-P | --noPatchAlias: \u4f7f\u7528\u4e86\u5934\u90e8\u522b\u540d\u7684\u8bdd(-a, --alias)\uff0c\u9ed8\u8ba4\u6bcf\u4e2a\u8868\u5355\u7684\u5934\u90e8\u90fd\u4f1a\u4f5c\u4e3a\u6bcf\u884c\u7684\u5355\u5143\u683c\u7684\u5173\u952e\u5b57\uff0c\r\n\u6709\u522b\u540d\u7684\u5934\u90e8\u4f1a\u4ee5\u522b\u540d\u4f5c\u4e3a\u5173\u952e\u5b57\uff0c\u5982\u679c\u4f7f\u7528\u4e86\u8fd9\u4e2a\u9009\u9879\u6ca1\u6709\u522b\u540d\u7684\u8868\u5355\u4f1a\u88ab\u5ffd\u60a0\uff0c\u5c06\u4e0d\u4f1a\u8f6c\u6362\u5904\u7406\r\n\r\n-M | --noMergeCell: \u5f53\u8868\u5355\u4e2d\u5b58\u5728\u7a7a\u7684\u5355\u5143\u683c\u65f6\uff0c\u9ed8\u8ba4\u662f\u6309\u7167\u53d8\u5f97\u7684\u5408\u5e76\u5355\u5143\u683c\u65b9\u5f0f\u5904\u7406\uff0c\u4ee5\u524d\u9762\u884c\u5355\u5143\u683c\u7684\u5185\u5bb9\u4f5c\r\n\u4e3a\u7a7a\u5355\u5143\u683c\u7684\u5185\u5bb9\uff0c\u5982\u679c\u4f7f\u7528\u4e86\u8fd9\u4e2a\u9009\u9879\uff0c\u7a7a\u5355\u5143\u683c\u4e0d\u505a\u7279\u6b8a\u5904\u7406\uff0c\u5c06\u4f1a\u53d8\u6210\u4e00\u4e2a\u7a7a\u7684\u5b57\u7b26\u4e32\r\n\r\n-r | --rowMax: \u8fd9\u4e2a\u9009\u9879\u7684\u9ed8\u8ba4\u503c\u662f1000\uff0c\u5b83\u662f\u4e00\u4e2a\u6574\u5f62\u6570\u503c\uff0c\u5b83\u4e3b\u8981\u7684\u4f5c\u7528\u662f\u9650\u5236json\u6587\u4ef6\u7684\u5927\u5c0f\uff0c\u4f8b\u5982\u6709\u4e00\u4e2a\u5305\u542b\u4e0a\u767e\u4e07\u7684\u884c\u7684\u8868\u5355\uff0c\u5f53\u8f6c\u6362\u6210\u4e00\u4e2ajson\u6587\u4ef6\u65f6\uff0c\u8fd9\u4e2ajson\u6587\u4ef6\u5c06\u4f1a\u975e\u5e38\u5927\uff0c\u4f7f\u7528\u8fd9\u4e2a\u53c2\u6570\u53ef\u4ee5\u5c06\u8fd9\u4e2a\u8868\u5355\uff0c\u5207\u5272\u6210\u4e00\u4e9b\u5c0f\u7684json\u6587\u4ef6\uff0c\u5982\u679c\u4f60\u4f7f\u7528\u9ed8\u8ba4\u503c\u7684\u8bdd\uff0c\u6bcf\u4e2ajson\u6587\u4ef6\u5c06\u5305\u542b1000\u884c\u7684\u5185\u5bb9, \u8fd9\u4e2a\u53c2\u6570\u6700\u5927\u53d6\u503c\u4e3a1000000\uff0c\u56e0\u6b64\u4f60\u4e0d\u80fd\u53d6\u6bd4\u8fd9\u4e2a\u66f4\u5927\u7684\u503c.\r\n\r\n-i | --index: \u8868\u5355\u7d22\u5f15\u503c\u5217\u8868\uff0c\u5b83\u5e94\u8be5\u662f\u4e00\u4e2a\u5305\u542b\u9017\u53f7\u5206\u9694\u7b26\u7684\u5b57\u7b26\u4e32\uff0c\u6bcf\u4e2a\u5206\u5272\u7684\u503c\u90fd\u5e94\u8be5\u662f\u4e00\u4e2a\u6574\u578b\u6570\u503c\uff0c\u4f8b\u5982(-i 0,1,2)\r\n\r\n-n | --names: \u8868\u5355\u540d\u5b57\u5217\u8868\uff0c\u5b83\u5e94\u8be5\u662f\u4e00\u4e2a\u5305\u542b\u9017\u53f7\u5206\u9694\u7b26\u7684\u5b57\u7b26\u4e32\uff0c\u4f8b\u5982(-n name1,name2,name3)\r\n\r\n-a | --alias: \u5934\u90e8\u522b\u540d\u5217\u8868\uff0c\u5b83\u5e94\u8be5\u662f\u4e00\u4e2a\u5305\u542b\u5206\u53f7\u5206\u9694\u7b26\u7684\u5b57\u7b26\u4e32\uff0c\u6bcf\u4e2a\u5206\u9694\u7684\u503c\u5e94\u8be5\u662f\u5305\u542b\u9017\u53f7\u5206\u9694\u7b26\u7684\u5b57\u7b26\u4e32\uff0c\r\n\u9017\u53f7\u5206\u9694\u7b26\u5206\u9694\u7684\u503c\u5e94\u8be5\u662f\u5305\u542b\u5192\u53f7\u5206\u9694\u7b26\u7684\u4e24\u90e8\u5206\uff0c\r\n\u4f8b\u5982(-a header1:alias1,header2:alias2;otherHeader:otherAlias)\r\n\r\n\u6ce8: (-a, --alias) \u5fc5\u987b\u4e0e (-i, --index) \u6216\u8005 (-n, --names) \u6210\u5bf9\u51fa\u73b0, \u4f8b\u5982 (-a header1:alias1,header2:alias2;otherHeader:otherAlias -i 0,1) \u539f\u56e0\u5982\u4e0b, \u5206\u53f7\u5206\u9694\u7684\u522b\u540d\u90e8\u5206\u5305\u542b\u4e24\u4e2a\u503c(\"header1:alias1,header2:alias2\" \"header2:alias2;otherHeader:otherAlias\")\r\n)\uff0c\u56e0\u6b64\u5bf9\u4e8e\u8868\u5355\u4e0b\u6807\u4e5f\u5e94\u8be5\u4e3a\u9017\u53f7\u5206\u9694\u7684\u4e24\u4e2a\u503c(\"0\" \"1\")\r\n\r\n\r\nenglish help\r\n====================\r\n\r\n-h | --help: get help document\r\n\r\n\r\nexample\r\n======================\r\n\r\n>excel2json -s \"D:\\exceltojson\\data\\test_exc el_process.xlsx\" -o \"D:\\output\"\r\n>dir D:\\output\r\n::\r\n\r\n d:\\out \u7684\u76ee\u5f55\r\n 2016/06/27 16:52