{ "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 .\r\n 2016/06/27 16:52 ..\r\n 2016/06/27 16:52 96 sheet-0.json\r\n 2016/06/27 16:52 91 sheet-1.json\r\n 2016/06/27 16:52 638 sheet-2.json\r\n 3 \u4e2a\u6587\u4ef6 825 \u5b57\u8282\r\n 2 \u4e2a\u76ee\u5f55 370,679,599,104 \u53ef\u7528\u5b57\u8282\r\n \r\n \r\nsheet-0.json:\r\n::\r\n\r\n {\"2\": {\"\\u5934\\u90e8\": \"\\u5185\\u5bb92\", \"header1\": \"\\u5185\\u5bb91\", \"header2\": \"\\u5185\\u5bb93\"}}\r\n \r\n\r\n>excel2json -s \"D:\\exceltojson\\data\\test_excel_process.xlsx\" -o \"D:\\out\" -i 0 -a \u5934\u90e8:header4\r\n\r\nsheet-0.json:\r\n::\r\n\r\n {\"2\": {\"header1\": \"\\u5185\\u5bb91\", \"header4\": \"\\u5185\\u5bb92\", \"header2\": \"\\u5185\\u5bb93\"}}", "description_content_type": null, "docs_url": null, "download_url": "UNKNOWN", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/malongge/exceltojson", "keywords": "transform excel to json files", "license": "MIT", "maintainer": null, "maintainer_email": null, "name": "excelt2json", "package_url": "https://pypi.org/project/excelt2json/", "platform": "UNKNOWN", "project_url": "https://pypi.org/project/excelt2json/", "project_urls": { "Download": "UNKNOWN", "Homepage": "https://github.com/malongge/exceltojson" }, "release_url": "https://pypi.org/project/excelt2json/1.0.1/", "requires_dist": null, "requires_python": null, "summary": "transform excel file to json files", "version": "1.0.1" }, "last_serial": 3559470, "releases": { "1.0.0": [ { "comment_text": "", "digests": { "md5": "76a419cd250ce999decdab272b469724", "sha256": "93fe4d9b7253f25048041933d48a016a83f0be747947b3dfb59ccc4070d23708" }, "downloads": -1, "filename": "excelt2json-1.0.0-py3.5.egg", "has_sig": false, "md5_digest": "76a419cd250ce999decdab272b469724", "packagetype": "bdist_egg", "python_version": "3.5", "requires_python": null, "size": 17674, "upload_time": "2018-02-07T07:09:14", "url": "https://files.pythonhosted.org/packages/7e/f4/46b0eb4565a6693e9be74b94621ec6927d7b8fe05d37fa19ab3cb4bced61/excelt2json-1.0.0-py3.5.egg" }, { "comment_text": "", "digests": { "md5": "1a667241b4ebe4e60b25c323c3284096", "sha256": "df2bdc649883e55e38bf5457d268acabf3eb1dd53e98f5c9e687a063d4e2fdc5" }, "downloads": -1, "filename": "excelt2json-1.0.0.zip", "has_sig": false, "md5_digest": "1a667241b4ebe4e60b25c323c3284096", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 15870, "upload_time": "2016-11-16T10:23:49", "url": "https://files.pythonhosted.org/packages/a8/b2/0f82daa8d833876c1f8cfcd61974e5ce9ebb4dc1c4c5bb533f86aafc988d/excelt2json-1.0.0.zip" } ], "1.0.1": [ { "comment_text": "", "digests": { "md5": "657bc6c558a7b8a99d188de222d95c14", "sha256": "059f97ef7f414c0b0b8cd3d72d4ccee12ee2e93b0ceab83ce3ad1ebe82a531d5" }, "downloads": -1, "filename": "excelt2json-1.0.1.zip", "has_sig": false, "md5_digest": "657bc6c558a7b8a99d188de222d95c14", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 15860, "upload_time": "2016-11-16T10:43:44", "url": "https://files.pythonhosted.org/packages/12/15/1a27928d64f746a028b9fccaba3f14fb050878225d821f681f0456d38116/excelt2json-1.0.1.zip" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "657bc6c558a7b8a99d188de222d95c14", "sha256": "059f97ef7f414c0b0b8cd3d72d4ccee12ee2e93b0ceab83ce3ad1ebe82a531d5" }, "downloads": -1, "filename": "excelt2json-1.0.1.zip", "has_sig": false, "md5_digest": "657bc6c558a7b8a99d188de222d95c14", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 15860, "upload_time": "2016-11-16T10:43:44", "url": "https://files.pythonhosted.org/packages/12/15/1a27928d64f746a028b9fccaba3f14fb050878225d821f681f0456d38116/excelt2json-1.0.1.zip" } ] }