{ "info": { "author": "Narayan Natarajan", "author_email": "venkman69@yahoo.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 4 - Beta" ], "description": "WikiToExcel\r\n-----------\r\n\r\n\r\nUse is trivial as shown below::\r\n\r\n from wikitoexcel import wikiToExcel\r\n w2e = wikiToExcel(infile=\"./wikitbl.txt\")\r\n # print the html representation of wiki markup\r\n print w2e.getHTML()\r\n # save excel file to out.xlsx\r\n w2e.saveExcel(fileName=\"out.xlsx\")\r\n\r\nOptions are::\r\n\r\n wikiToExcel(wikiContent=, infile=)\r\n\r\nFeatures\r\n--------\r\n\r\nwikitoexcel can capture:\r\n\r\n- Font styling: bold, underline, strikethrough\r\n- Cell styling: foreground color, background color\r\n- Supports merged cells\r\n- Sheet name is captured as caption of the wiki table\r\n- Multiline cell contents are styled with 'wrap' in excel\r\n- span and div elements are converted to their inner text representation\r\n- HyperLinks are addressed in a way that the hyperlink and display text are presented side by side. This facilitates round-trip between exceltowiki and wikitoexcel. Such as:\r\n http://yahoo.com Yahoo!\r\n- Support for saving intermediate html representation\r\n\r\nwikitoexcel currently cannot capture anything more complex than the above list. \r\nFeatures such as a font styling within a paragraph is not captured.\r\n\r\nNotes\r\n-----\r\nIf implementing this as a web.py call: \r\n\r\n- You can construct a simple HTML form post with a textarea (below assumes textarea name is 'wikitoexcel')\r\n- Add the following class\r\n\r\n.. code-block:: python\r\n\r\n class wikitoexcel():\r\n\t\tdef POST(self):\r\n\t\t\tformdata=web.input()\r\n\t\t\tw2e=wikiToExcel(wikiContent= formdata['wikitoexcel'])\r\n\t\t\tsbuf= StringIO.StringIO()\r\n\t\t\tw2e.saveExcel(fileObj=sbuf)\r\n\t\t\tweb.header('Content-type','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet')\r\n\t\t\treturn sbuf.getvalue()\r\n\r\nRelease Notes: 0.1.7\r\n--------------------\r\nMinor update to handling empty cells or with  . And some cleanup\r\n\r\nRelease Notes: 0.1.6\r\n--------------------\r\n\r\nBug found and fixed for creating a worksheet.\r\n\r\nRelease Notes: 0.1.5\r\n--------------------\r\n\r\nClean up of setup.py and minor changes\r\n\r\nRelease Notes: 0.1.4\r\n--------------------\r\n\r\n* Added option to output in inline format using double pipe separator notation vs line by line format.\r\n* Set the package level variable: wikitoexcel.INLINE_FMT=True (default)\r\n* To allow multiline text, a BR tag is replaced for each return character\r\n\r\nRelease Notes: 0.1.3\r\n--------------------\r\nAdded license file\r\nRewrote parser to retain wikimarkup within cells. This allows an excel user to passthrough wiki markup.\r\n\r\n\r\nRelease Notes: 0.1.2\r\n--------------------\r\nPackaging was not following best practice of examples within the package.\r\n\r\nRelease Notes: 0.1.1\r\n--------------------\r\nInitial Release", "description_content_type": null, "docs_url": null, "download_url": "https://github.com/venkman69/WikiToExcel", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "", "keywords": "wiki excel convert markup table", "license": "", "maintainer": "", "maintainer_email": "", "name": "wikitoexcel", "package_url": "https://pypi.org/project/wikitoexcel/", "platform": "", "project_url": "https://pypi.org/project/wikitoexcel/", "project_urls": { "Download": "https://github.com/venkman69/WikiToExcel" }, "release_url": "https://pypi.org/project/wikitoexcel/0.1.7/", "requires_dist": null, "requires_python": null, "summary": "Convert wiki table markup to excel", "version": "0.1.7" }, "last_serial": 2005107, "releases": { "0.1.0": [ { "comment_text": "", "digests": { "md5": "fa29cad45923bffeca3666aafdd690f4", "sha256": "cba252b53aad67906cf294d0aa2ededae24b0e996e6697b65d9d78f97de5a432" }, "downloads": -1, "filename": "wikitoexcel-0.1.0.tar.gz", "has_sig": false, "md5_digest": "fa29cad45923bffeca3666aafdd690f4", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3779, "upload_time": "2015-08-27T23:21:16", "url": "https://files.pythonhosted.org/packages/cb/4a/12ad9257d75b8947cf0dffd417b888d11b7f3ace86759fdb21acf20b4280/wikitoexcel-0.1.0.tar.gz" } ], "0.1.1": [ { "comment_text": "", "digests": { "md5": "0c7571d21ffca392501cf41f4ad9aaa0", "sha256": "c90814d7be677d477d9a6d869b14700542ee80fd04232bcdf718e5a1de2fa18a" }, "downloads": -1, "filename": "wikitoexcel-0.1.1.tar.gz", "has_sig": false, "md5_digest": "0c7571d21ffca392501cf41f4ad9aaa0", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5019, "upload_time": "2015-08-27T23:28:02", "url": "https://files.pythonhosted.org/packages/1d/02/8790fff9b1a4c394f0f67192d83f99db875c0ec9cb35e7c41e02f3f39e77/wikitoexcel-0.1.1.tar.gz" } ], "0.1.2": [ { "comment_text": "", "digests": { "md5": "cd506849357166716d02e345eea41575", "sha256": "e47c2fed06374947c8f1df5b5fc2b14a0cc4c80148b8e78a7c8cb6c9eb483bcd" }, "downloads": -1, "filename": "wikitoexcel-0.1.2.tar.gz", "has_sig": false, "md5_digest": "cd506849357166716d02e345eea41575", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5043, "upload_time": "2015-08-29T00:31:09", "url": "https://files.pythonhosted.org/packages/6a/8b/8492c3d924ffdc27c57b5ad1756df6b16ee6b20783d58f10e17d6fda67f5/wikitoexcel-0.1.2.tar.gz" } ], "0.1.3": [ { "comment_text": "", "digests": { "md5": "3f1e35c33d1d2e8fd0825fa294f7f164", "sha256": "e88b6b93c8688cd52a69fac7901812a9c034b6a6c25c5b8906ed1562f9393dda" }, "downloads": -1, "filename": "wikitoexcel-0.1.3.tar.gz", "has_sig": false, "md5_digest": "3f1e35c33d1d2e8fd0825fa294f7f164", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 10008, "upload_time": "2015-09-03T03:47:34", "url": "https://files.pythonhosted.org/packages/ce/e7/b7be257fc6e12c85f9fee532ec7724f534a8b46c2fd6f7861e2db15305e1/wikitoexcel-0.1.3.tar.gz" } ], "0.1.4": [ { "comment_text": "", "digests": { "md5": "4a30900ccea27351a992d40097f15a2b", "sha256": "714eee698b3fd14c967e2736326b2b101f5bb64476622bec43879882bcc9eb45" }, "downloads": -1, "filename": "wikitoexcel-0.1.4.tar.gz", "has_sig": false, "md5_digest": "4a30900ccea27351a992d40097f15a2b", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 7089, "upload_time": "2015-09-09T13:10:03", "url": "https://files.pythonhosted.org/packages/68/a2/60379c01331f4d25b4e3e5d0659c59ebc8cd2a289a9aeb076d57b8fc9c5f/wikitoexcel-0.1.4.tar.gz" } ], "0.1.5": [ { "comment_text": "", "digests": { "md5": "5a536a51c25b746f3b5286b44fb7e31d", "sha256": "accd9fd7ab101f31eb8f65991e9d9e9db27dbf015af0c57c4f694ee7f3870577" }, "downloads": -1, "filename": "wikitoexcel-0.1.5.tar.gz", "has_sig": false, "md5_digest": "5a536a51c25b746f3b5286b44fb7e31d", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6620, "upload_time": "2015-09-09T14:12:06", "url": "https://files.pythonhosted.org/packages/c2/ed/1d7d4fa656c9708d12df57dfeb57fb13157d03a7aed534e9a97f21dc5d94/wikitoexcel-0.1.5.tar.gz" } ], "0.1.6": [ { "comment_text": "", "digests": { "md5": "46145ea62414fb2e380a0e8969c82943", "sha256": "0766f7139a2b4b877b803779cf1f1737db9fe62429c682b2f9638e4d62d76eb3" }, "downloads": -1, "filename": "wikitoexcel-0.1.6.tar.gz", "has_sig": false, "md5_digest": "46145ea62414fb2e380a0e8969c82943", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6681, "upload_time": "2015-11-24T01:35:15", "url": "https://files.pythonhosted.org/packages/37/14/2fe9e9323b2d09d712304bed0a88627a7de81b071129a0511d4564f284a8/wikitoexcel-0.1.6.tar.gz" } ], "0.1.7": [ { "comment_text": "", "digests": { "md5": "5275d8e015d98136ea4d9e46a34f0557", "sha256": "d987d008734a567f0d6fbc25fc384f1099fc87bc905d08698b89d5b9b35312e2" }, "downloads": -1, "filename": "wikitoexcel-0.1.7.tar.gz", "has_sig": false, "md5_digest": "5275d8e015d98136ea4d9e46a34f0557", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6664, "upload_time": "2016-02-05T13:26:54", "url": "https://files.pythonhosted.org/packages/4d/8d/fa222dfeac78f498d67a399925f7b2f0845be253179896285f976e198db9/wikitoexcel-0.1.7.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "5275d8e015d98136ea4d9e46a34f0557", "sha256": "d987d008734a567f0d6fbc25fc384f1099fc87bc905d08698b89d5b9b35312e2" }, "downloads": -1, "filename": "wikitoexcel-0.1.7.tar.gz", "has_sig": false, "md5_digest": "5275d8e015d98136ea4d9e46a34f0557", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6664, "upload_time": "2016-02-05T13:26:54", "url": "https://files.pythonhosted.org/packages/4d/8d/fa222dfeac78f498d67a399925f7b2f0845be253179896285f976e198db9/wikitoexcel-0.1.7.tar.gz" } ] }