{ "info": { "author": "zencore", "author_email": "dobetter@zencore.cn", "bugtrack_url": null, "classifiers": [ "Development Status :: 5 - Production/Stable", "Intended Audience :: Developers", "License :: OSI Approved :: MIT License", "Programming Language :: Python :: 3", "Programming Language :: Python :: 3 :: Only", "Topic :: Software Development :: Libraries :: Python Modules" ], "description": "# xlsx-split\n\nCreate new file for every row in excel sheet, with support of header and footer replication. \n\n## Install\n\n pip install xlsx-split\n\n## Installed Commands\n\n- xlsx-split\n\n## Command Helps\n\n```\n E:\\xlsx-split>xlsx-split --help\n Usage: xlsx-split [OPTIONS] WORKBOOK\n\n Options:\n -h, --header TEXT Header row number list.\n -f, --footer TEXT Footer row number list.\n -c, --cols TEXT Column number list.\n -r, --rows TEXT Content row number list.\n -t, --test TEXT Conditions that a good row must matchs. Format\n like COL_LETTER:REGEX, e.g. A:\\d+ means the\n value of A column must be an Integer.\n -s, --sheet TEXT Sheet name. Default to Current Active Sheet\n -w, --workspace TEXT Where new files saved. Default to\n \"{FILENAME_ROOT}\"\n -p, --filename-pattern TEXT Default to\n \"{FILENAME_ROOT}-{ROW}.{FILENAME_EXT}\"\n --help Show this message and exit.\n```\n\n## Notice\n\n- header/footer/rows obeys ROWS-RULE.\n- cols obeys COLS-RULE.\n- test obeys TEST-RULE\u3002\n- filename-pattern obeys FILENAME-RULE\u3002\n\n### ROWS-RULE\n\n- 1 == [1]\n- 1,2,3 == [1,2,3]\n- 1-3 == [1,2,3]\n- 1-3,5 == [1,2,3,5]\n- 3- == [3,4,5,6....] # From the third row to the sheet.max_rows\n\n### COLS-RULE\n\n- A == [1]\n- A,B,C == [1,2,3]\n- A-C == [1,2,3]\n- A-C,E == [1,2,3,5]\n- C- == [3,4,5,6....] # From column C to the sheet.max_cols\n\n### TEST-RULE\n\n- Can provide multiple tests.\n- The final result is the result of LOGIC AND of all tests result.\n- Test format: Column:TestRegex, e.g. A:\\d+ means the Column A must contain digits.\n\n\n### FILENAME-RULE\n\n- filename-pattern is a python string format template.\n- Available variables\n - FILEPATH Source file's full path, e.g. c:\\a\\b.xlsx\n - DIRNAME Source file's direct folder path, e.g. c:\\a\n - FILENAME Source file's filename, e.g. b.xlsx\n - FILENAME_ROOT Source file's filename without ext, e.g. b\n - FILENAME_EXT Source file's file ext, e.g. .xlsx\n - ROW Index of current row\uff0c\u59821,2,3...\n - A..Z,AA... The value of the cell [ROW, COLUMN]. A or Z or ZZ is the column.\n\n## Releases\n\n### 0.1.2\n\n- Fix parse_rows & parse_cols problem.\n- Document changes.\n\n### 0.1.1\n\n- Document changes.\n\n### 0.1.0\n\n- First release", "description_content_type": "text/markdown", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "", "keywords": "xlsx-split", "license": "MIT", "maintainer": "", "maintainer_email": "", "name": "xlsx-split", "package_url": "https://pypi.org/project/xlsx-split/", "platform": "", "project_url": "https://pypi.org/project/xlsx-split/", "project_urls": null, "release_url": "https://pypi.org/project/xlsx-split/0.1.2/", "requires_dist": null, "requires_python": "", "summary": "Create new file for every row in excel sheet, with support of header and footer replication.", "version": "0.1.2" }, "last_serial": 5838940, "releases": { "0.1.0": [ { "comment_text": "", "digests": { "md5": "3aa393a011e260690254bb2f5b8fb7f5", "sha256": "027a67036fbe89e60b8a6946f4d5c307b90f5c58f28cf3e78a7794de4c49bd29" }, "downloads": -1, "filename": "xlsx_split-0.1.0-py3-none-any.whl", "has_sig": false, "md5_digest": "3aa393a011e260690254bb2f5b8fb7f5", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 5001, "upload_time": "2019-06-18T03:18:28", "url": "https://files.pythonhosted.org/packages/23/11/9f4f214c1e50dd03eb5f7ef0935a488d2c4b32206d6b38e5d8e79c767db9/xlsx_split-0.1.0-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "faad9ee60dc53ceda920ad4ecb989918", "sha256": "bf6218f9e91e1c33929fbba84f48f5703ae45d3030725c9941d41099d25abe9d" }, "downloads": -1, "filename": "xlsx-split-0.1.0.tar.gz", "has_sig": false, "md5_digest": "faad9ee60dc53ceda920ad4ecb989918", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3846, "upload_time": "2019-06-18T03:21:29", "url": "https://files.pythonhosted.org/packages/2e/c2/e291c5f7362edee7e22c9d263759482d2d641fbef45ddb2794c753cd1e76/xlsx-split-0.1.0.tar.gz" } ], "0.1.1": [ { "comment_text": "", "digests": { "md5": "f5c2b69d4c0e99d634936307df05f309", "sha256": "3a044943a493ada1bf4a84c3e607e65a0f2def657f1abff2dfdd450ca8fe3512" }, "downloads": -1, "filename": "xlsx_split-0.1.1-py3-none-any.whl", "has_sig": false, "md5_digest": "f5c2b69d4c0e99d634936307df05f309", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 5009, "upload_time": "2019-06-18T03:31:07", "url": "https://files.pythonhosted.org/packages/0b/77/a5fb810946fd85e1cde085424e191d5e28389fdef0764b3ca8f9fbc8fcdc/xlsx_split-0.1.1-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "b9472861f3c5c725702da59c8bf6c16f", "sha256": "463272d744e6a92beb5905d861f028b5205877d573da1f74657581ae1c77f93f" }, "downloads": -1, "filename": "xlsx-split-0.1.1.tar.gz", "has_sig": false, "md5_digest": "b9472861f3c5c725702da59c8bf6c16f", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3858, "upload_time": "2019-06-18T03:31:09", "url": "https://files.pythonhosted.org/packages/9c/e4/feb0c946bb7d1ef6e5de2c3791ebb1bf16ccae0bbe7f3546c30934d61563/xlsx-split-0.1.1.tar.gz" } ], "0.1.2": [ { "comment_text": "", "digests": { "md5": "ed891af8bdfddb6c5d9325e68354b3c2", "sha256": "83380f58997ff4f9e6ffa204dbc21a99b9d00049bb27b2e4ec874a8c810e2479" }, "downloads": -1, "filename": "xlsx-split-0.1.2.tar.gz", "has_sig": false, "md5_digest": "ed891af8bdfddb6c5d9325e68354b3c2", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3910, "upload_time": "2019-09-17T01:27:54", "url": "https://files.pythonhosted.org/packages/2a/1a/38760f784ed169f22ce7c1092b231414e5b2242be49d2300aff9b9630b99/xlsx-split-0.1.2.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "ed891af8bdfddb6c5d9325e68354b3c2", "sha256": "83380f58997ff4f9e6ffa204dbc21a99b9d00049bb27b2e4ec874a8c810e2479" }, "downloads": -1, "filename": "xlsx-split-0.1.2.tar.gz", "has_sig": false, "md5_digest": "ed891af8bdfddb6c5d9325e68354b3c2", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3910, "upload_time": "2019-09-17T01:27:54", "url": "https://files.pythonhosted.org/packages/2a/1a/38760f784ed169f22ce7c1092b231414e5b2242be49d2300aff9b9630b99/xlsx-split-0.1.2.tar.gz" } ] }