{ "info": { "author": "Wensheng Wang", "author_email": "wenshengwang@gmail.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 3 - Alpha", "Intended Audience :: Developers", "License :: OSI Approved :: MIT License", "Operating System :: OS Independent", "Programming Language :: Python", "Topic :: Office/Business :: Financial :: Spreadsheet", "Topic :: Software Development :: Libraries :: Python Modules" ], "description": "ooxml: Python interface for working with OOXML files such as xlsx, docx, pptx.\n\nFor now only reading xlsx works.\n\nHere's how to use it to read xlsx file:\n\n>>> from ooxml.spreadsheet import Spreadsheet\n>>> workbook=Spreadsheet('book1.xlsx') #read in book1.xlsx\n>>> workbook.sheet_names \n['Sheet1', 'Sheet3', 'Sheet2']\n>>> sheet1 = workbook.sheet(1) #index start from 1, not 0\n>>> row1 = sheet1.row(1) #you can get a row\n>>> row1\n\n>>> row1.cell(1).value #access a cell value in a row\n'1'\n>>> sheet1.cell(2,1).value #access by sheet.cell(x,y), x is row, y is column\n'2'\n>>> sheet2 = workbook.sheet('Sheet2') #use name instead of index to get a sheet\n>>> cell = sheet2.cell(5,5)\n>>> sheet2.save_csv('my.csv') #save content to csv\n\nWriting xlsx, reading/writing docx, pptx will be added later.", "description_content_type": null, "docs_url": null, "download_url": "UNKNOWN", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://bitbucket.org/wensheng/pyooxml", "keywords": "word excel powerpoint ooxml", "license": "MIT", "maintainer": null, "maintainer_email": null, "name": "ooxml", "package_url": "https://pypi.org/project/ooxml/", "platform": "Platform Independent", "project_url": "https://pypi.org/project/ooxml/", "project_urls": { "Download": "UNKNOWN", "Homepage": "https://bitbucket.org/wensheng/pyooxml" }, "release_url": "https://pypi.org/project/ooxml/0.2.1/", "requires_dist": null, "requires_python": null, "summary": "Python interface for working with OOXML files such as docx, xlsx.", "version": "0.2.1" }, "last_serial": 795746, "releases": { "0.1": [ { "comment_text": "", "digests": { "md5": "de2ff0c7748a98c4b7ca9b31b2a8a724", "sha256": "22c8a5c6cdd855bdcdd8f73da4df1d4249447b000554b4ccc835ecaaf9874b9d" }, "downloads": -1, "filename": "ooxml-0.1-py2.6.egg", "has_sig": false, "md5_digest": "de2ff0c7748a98c4b7ca9b31b2a8a724", "packagetype": "bdist_egg", "python_version": "2.6", "requires_python": null, "size": 8257, "upload_time": "2011-02-26T01:07:27", "url": "https://files.pythonhosted.org/packages/af/45/79404854852ca7a7f490cc22503949600a3f87de1c413d0a0a37e155a969/ooxml-0.1-py2.6.egg" }, { "comment_text": "", "digests": { "md5": "f6666ec76dbd593d2559a83abfeeacde", "sha256": "ccd67f3404df6f558c8e48180a06af9384a60552ebaaff22c6349ef5291b85f5" }, "downloads": -1, "filename": "ooxml-0.1.tar.gz", "has_sig": false, "md5_digest": "f6666ec76dbd593d2559a83abfeeacde", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3323, "upload_time": "2011-02-26T01:07:26", "url": "https://files.pythonhosted.org/packages/8b/ed/3b69c2ca2e71bf4bcc8eb90f06eb54817f5db8ae3e457d9978333b026f92/ooxml-0.1.tar.gz" } ], "0.2": [ { "comment_text": "", "digests": { "md5": "90c94346b17dd4f9ea1c5ee6a2bc26e3", "sha256": "4ec0ee1836dbe1093ec49013c4adc9dd3da141c918f367501a37d79249b8636c" }, "downloads": -1, "filename": "ooxml-0.2-py2.6.egg", "has_sig": false, "md5_digest": "90c94346b17dd4f9ea1c5ee6a2bc26e3", "packagetype": "bdist_egg", "python_version": "2.6", "requires_python": null, "size": 16349, "upload_time": "2011-03-01T02:24:49", "url": "https://files.pythonhosted.org/packages/2c/52/2e368892405921e6acc0252b065dc05eb46d21a2fa998fb9b9ec457b5be6/ooxml-0.2-py2.6.egg" }, { "comment_text": "", "digests": { "md5": "5cc145a3183030bb4cf9ec9040ae915b", "sha256": "52cebf27541ef6ae893bc7ddf7eb739b147afe529387fdcf37c90e270c1b184c" }, "downloads": -1, "filename": "ooxml-0.2.tar.gz", "has_sig": false, "md5_digest": "5cc145a3183030bb4cf9ec9040ae915b", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4411, "upload_time": "2011-03-01T02:24:49", "url": "https://files.pythonhosted.org/packages/09/63/7057778cf798c9857c35af6a9e14cac1614eba522cd570f0e6154aa8011d/ooxml-0.2.tar.gz" } ], "0.2.1": [ { "comment_text": "", "digests": { "md5": "ed9dd9e219d3b86063ab359f1ff18bbe", "sha256": "7a8a7406c2b3a63ce1933ac6e64bacec73eebc1eb9c3890402302d4c38ebaf38" }, "downloads": -1, "filename": "ooxml-0.2.1-py2.6.egg", "has_sig": false, "md5_digest": "ed9dd9e219d3b86063ab359f1ff18bbe", "packagetype": "bdist_egg", "python_version": "2.6", "requires_python": null, "size": 15183, "upload_time": "2011-03-05T07:14:54", "url": "https://files.pythonhosted.org/packages/77/4c/0528be17be71872a9e38ce0b63ca74ca73d14a2d5b8b8c7ea0c1ba8c3951/ooxml-0.2.1-py2.6.egg" }, { "comment_text": "", "digests": { "md5": "4595dded94704f5392a45613ecffdf92", "sha256": "09d5c075fc67eec5a95be15f9bbda24ab6106dc48a5856a35b9ed7866e78b0f0" }, "downloads": -1, "filename": "ooxml-0.2.1.tar.gz", "has_sig": false, "md5_digest": "4595dded94704f5392a45613ecffdf92", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4347, "upload_time": "2011-03-05T07:14:53", "url": "https://files.pythonhosted.org/packages/b5/7c/9ed5fa5831548dcd866055d8faa2036b019e51551a2d3ce28f68a9c63969/ooxml-0.2.1.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "ed9dd9e219d3b86063ab359f1ff18bbe", "sha256": "7a8a7406c2b3a63ce1933ac6e64bacec73eebc1eb9c3890402302d4c38ebaf38" }, "downloads": -1, "filename": "ooxml-0.2.1-py2.6.egg", "has_sig": false, "md5_digest": "ed9dd9e219d3b86063ab359f1ff18bbe", "packagetype": "bdist_egg", "python_version": "2.6", "requires_python": null, "size": 15183, "upload_time": "2011-03-05T07:14:54", "url": "https://files.pythonhosted.org/packages/77/4c/0528be17be71872a9e38ce0b63ca74ca73d14a2d5b8b8c7ea0c1ba8c3951/ooxml-0.2.1-py2.6.egg" }, { "comment_text": "", "digests": { "md5": "4595dded94704f5392a45613ecffdf92", "sha256": "09d5c075fc67eec5a95be15f9bbda24ab6106dc48a5856a35b9ed7866e78b0f0" }, "downloads": -1, "filename": "ooxml-0.2.1.tar.gz", "has_sig": false, "md5_digest": "4595dded94704f5392a45613ecffdf92", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4347, "upload_time": "2011-03-05T07:14:53", "url": "https://files.pythonhosted.org/packages/b5/7c/9ed5fa5831548dcd866055d8faa2036b019e51551a2d3ce28f68a9c63969/ooxml-0.2.1.tar.gz" } ] }