{ "info": { "author": "zhangtao103239", "author_email": "zhangtao103239@163.com", "bugtrack_url": null, "classifiers": [ "License :: OSI Approved :: MIT License", "Operating System :: OS Independent", "Programming Language :: Python :: 3" ], "description": "# merged_excel_tools\n\u8bfb\u53d6\u5408\u5e76\u5355\u5143\u683c\u7684\u5de5\u5177\u7c7b\n\n\u8fd9\u662f\u7528\u6765\u8bfb\u53d6\u7279\u5b9a\u683c\u5f0f(\u5408\u5e76\u5355\u5143\u683c)\u7684Excel\u8868\u683c\u7684\u5de5\u5177\u7c7b\uff0c\u683c\u5f0f\u5982\u4e0b\n![table.png](https://s1.ax1x.com/2018/08/13/Pg8gH0.png)\n\n## install\n\u4f7f\u7528pip\n```python\npip install merged_excel_tools\n```\n## \u4f7f\u7528\u65b9\u6cd5\n```python\nfrom merged_excel_tools import merged_excel\nme = merged_excel(\"example.xlsx\")\nranges=me.getMergedList()\nfor range in ranges:\n # \u8fd9\u662f\u5408\u5e76\u5355\u5143\u683c\u7684\u9996\n start = range.min_row\n # \u8fd9\u662f\u5408\u5e76\u5355\u5143\u683c\u7684\u5c3e\n end = range.max_row\n #\u8fd9\u662fA\u533a\u57df\u7684\u5408\u5e76\u5355\u5143\u683c\u7684\u503c\n As = me.getValue(\"A\",start)\n```\n\n### \u6ce8\u610f\n\u4f7f\u7528openpyxl\u6765\u8bfb\u53d6excel\u8868\u683c\n\n\n", "description_content_type": "text/markdown", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/zhangtao103239/read_merged_tools", "keywords": "", "license": "", "maintainer": "", "maintainer_email": "", "name": "merged-excel-tools", "package_url": "https://pypi.org/project/merged-excel-tools/", "platform": "", "project_url": "https://pypi.org/project/merged-excel-tools/", "project_urls": { "Homepage": "https://github.com/zhangtao103239/read_merged_tools" }, "release_url": "https://pypi.org/project/merged-excel-tools/1.4/", "requires_dist": [ "openpyxl" ], "requires_python": "", "summary": "merged cells excel tools", "version": "1.4" }, "last_serial": 4187421, "releases": { "1.0": [ { "comment_text": "", "digests": { "md5": "b4c957fa046fbb95b65b6dffc6ede050", "sha256": "c45ef55c4e6fef3cc8b8cbbfa52d93118b8939b051f351cd2f482246afd332a0" }, "downloads": -1, "filename": "merged_excel_tools-1.0-py3-none-any.whl", "has_sig": false, "md5_digest": "b4c957fa046fbb95b65b6dffc6ede050", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 2041, "upload_time": "2018-08-13T11:16:23", "url": "https://files.pythonhosted.org/packages/a3/d2/db3a8a975bd15dc71dd1c70fd79b2b720a4a5a26463b19d69705b2ff7e9b/merged_excel_tools-1.0-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "e6c42da68dc10d1f3c66edf048fe221f", "sha256": "c37503c140af4a1c22afc5e7a3d0ecdf1bada5458763c724e0de0d66a717adc4" }, "downloads": -1, "filename": "merged_excel_tools-1.0.tar.gz", "has_sig": false, "md5_digest": "e6c42da68dc10d1f3c66edf048fe221f", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 1683, "upload_time": "2018-08-13T11:16:25", "url": "https://files.pythonhosted.org/packages/54/f4/ce0a0b13ce526eccaa6579a2d34e709c16c714c0ecfee2ac82319b7417bd/merged_excel_tools-1.0.tar.gz" } ], "1.1": [ { "comment_text": "", "digests": { "md5": "aceb05dab4f0378ced0933994e472029", "sha256": "ab0be2159e7cf0ab76ece6dc91f2d08ceb93249f271c6866e4d6888c1c829007" }, "downloads": -1, "filename": "merged_excel_tools-1.1-py3-none-any.whl", "has_sig": false, "md5_digest": "aceb05dab4f0378ced0933994e472029", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 2057, "upload_time": "2018-08-13T11:21:13", "url": "https://files.pythonhosted.org/packages/32/df/9639cd7059594f1a31ec8a13fa77652b6a47434d198d07fd300f7b5b5ed1/merged_excel_tools-1.1-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "97715a9c2c874359288f7cb7a841c843", "sha256": "b2da03a1b9df5134e2ea294d82a5260fb252c11f8de0973bbc70d5e7a1bde448" }, "downloads": -1, "filename": "merged_excel_tools-1.1.tar.gz", "has_sig": false, "md5_digest": "97715a9c2c874359288f7cb7a841c843", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 1686, "upload_time": "2018-08-13T11:21:15", "url": "https://files.pythonhosted.org/packages/ad/86/f7f2994acd5b4630297a0bb1177de93fe70103e1efaee846957563d62c01/merged_excel_tools-1.1.tar.gz" } ], "1.2": [ { "comment_text": "", "digests": { "md5": "946f0253d0bef0514003a40b72f78fb2", "sha256": "6bd9fa1629c2e6f8e4acc762cec7e974fd20819ed2c6c587b88705e7c11befe0" }, "downloads": -1, "filename": "merged_excel_tools-1.2-py3-none-any.whl", "has_sig": false, "md5_digest": "946f0253d0bef0514003a40b72f78fb2", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 2162, "upload_time": "2018-08-13T11:33:37", "url": "https://files.pythonhosted.org/packages/20/51/2d441f0b50655da2e572b56243ff7c2f08a65c64e70589dd6b716e25eb2f/merged_excel_tools-1.2-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "2429d9829525ae948f2db4bf16cdfba3", "sha256": "7a66a06599a9d07c123ae475e9b230f7b5b9872d813e8018469a30dba630c3d3" }, "downloads": -1, "filename": "merged_excel_tools-1.2.tar.gz", "has_sig": false, "md5_digest": "2429d9829525ae948f2db4bf16cdfba3", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 1819, "upload_time": "2018-08-13T11:33:39", "url": "https://files.pythonhosted.org/packages/4a/0b/43cdd405f9e84169582b95addcccfca911c1a5ce541893b7cb1db2d21ed8/merged_excel_tools-1.2.tar.gz" } ], "1.3": [ { "comment_text": "", "digests": { "md5": "083bbcf15104411b3bce6d749db2c14b", "sha256": "24e101bd74de710d3f8ec75f1f1e8cddb225373b75aa0090a79f3231fa76f31f" }, "downloads": -1, "filename": "merged_excel_tools-1.3-py3-none-any.whl", "has_sig": false, "md5_digest": "083bbcf15104411b3bce6d749db2c14b", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 2157, "upload_time": "2018-08-13T11:47:32", "url": "https://files.pythonhosted.org/packages/ed/b6/e5cbfe61863ed90f550d2769633437fc473993a5cf2e70c0918d60144bfa/merged_excel_tools-1.3-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "739c746af93ec4dc6f9dde98f011f6cf", "sha256": "0f53ba5f7e3b8e711cc665615edd84a9d757e3c2d5cd6f763e7272486fb38e4a" }, "downloads": -1, "filename": "merged_excel_tools-1.3.tar.gz", "has_sig": false, "md5_digest": "739c746af93ec4dc6f9dde98f011f6cf", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 1804, "upload_time": "2018-08-13T11:47:34", "url": "https://files.pythonhosted.org/packages/22/40/9fda73a60f0c6e1f40821871b57bcf1c68af97e3fdbc9883c728ce1e0b4d/merged_excel_tools-1.3.tar.gz" } ], "1.4": [ { "comment_text": "", "digests": { "md5": "4ebd0126f436abba842405840f0e07e4", "sha256": "d37785cc93605f56d058920e78ef7eda9673793d58eefec6fd09e88c35e9ed66" }, "downloads": -1, "filename": "merged_excel_tools-1.4-py3-none-any.whl", "has_sig": false, "md5_digest": "4ebd0126f436abba842405840f0e07e4", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 2101, "upload_time": "2018-08-20T07:42:03", "url": "https://files.pythonhosted.org/packages/1d/22/0784e3d7a48fc3763d61b86f29d57a439de12ec7bb7a4c271490eb9ea6d6/merged_excel_tools-1.4-py3-none-any.whl" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "4ebd0126f436abba842405840f0e07e4", "sha256": "d37785cc93605f56d058920e78ef7eda9673793d58eefec6fd09e88c35e9ed66" }, "downloads": -1, "filename": "merged_excel_tools-1.4-py3-none-any.whl", "has_sig": false, "md5_digest": "4ebd0126f436abba842405840f0e07e4", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 2101, "upload_time": "2018-08-20T07:42:03", "url": "https://files.pythonhosted.org/packages/1d/22/0784e3d7a48fc3763d61b86f29d57a439de12ec7bb7a4c271490eb9ea6d6/merged_excel_tools-1.4-py3-none-any.whl" } ] }