{ "info": { "author": "Narayan Natarajan", "author_email": "venkman69@yahoo.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 4 - Beta" ], "description": "ExcelToWiki\r\n-----------\r\n\r\n\r\nUse is trivial as shown below::\r\n\r\n from exceltowiki import exceltowiki \r\n import exceltowiki\r\n\r\n e2w = excelToWiki(\"./test.xlsx\",[\"Sheet1\"],\"blue\",\"yellow\")\r\n print e2w.sheetnames\r\n print e2w.getSheet(\"Sheet1\")\r\n print e2w.getWorkbook()\r\n e2w = excelToWiki(\"./test.xlsx\") \r\n # print sheet names in the excel workbook \r\n print e2w.sheetnames \r\n # print wiki text for sheet named Sheet1 \r\n print e2w.getSheet(\"Sheet1\") \r\n # print wiki text for entire workbook \r\n print e2w.getWorkbook() \r\n\r\nOptions are:: \r\n\r\n exceltowiki(excelworkbook, [list of sheet names to process], caption foreground color, caption background color, preserve col widths) \r\n\r\nWhere caption is set from the sheet name (no way to currently modify this). \r\n\r\nFeatures \r\n-------- \r\n\r\nexceltowiki can capture: \r\n\r\n- Font styling: bold, underline, strikethrough \r\n- Cell styling: foreground color, background color \r\n- Sheet features: merged cells are captured, sheet name is captured as caption to the wiki table \r\n\r\n\r\nexceltowiki currently cannot capture anything more complex than the above list. Features such as 'format as table', conditional formatting, and other advanced items are not inspected or captured. For these, only the data value in the cells will be captured. \r\n\r\nRelease Notes: 0.1.19\r\n--------------------- \r\nAdded a better handler for date format detection and conversion. This is still very hacky but it works. \r\nMS date format to datetime strftime is never going to be straight forward until there is a method to \r\nobtain the resulting formatted string by itself.\r\n\r\nRelease Notes: 0.1.18\r\n--------------------- \r\nInline double-pipe separator had a bug where a newline in the cell requires the wiki table to use a single pipe character.\r\n\r\nRelease Notes: 0.1.17\r\n--------------------- \r\nFor better presentation of empty cells in wiki the cell contents are replaced with ' ' this retains any spacing/sizing related nature of the table which would otherwise collapse.\r\n\r\nRelease Notes: 0.1.16\r\n--------------------- \r\nWiki text within a cell was not being formatted via wiki because of being inlined. Slight update to fix this.\r\nThe 'INLINE_FMT' flag is now deprecated.\r\n\r\n\r\nRelease Notes: 0.1.15\r\n--------------------- \r\nAdded preserve_width option\r\nUpdate to latest openpyxl - note that newer openpyxl broke something in colwidth with 0.1.14\r\n\r\nRelease Notes: 0.1.14\r\n--------------------- \r\n\r\nMinor update\r\n\r\n\r\nRelease Notes: 0.1.13\r\n--------------------- \r\n\r\nAdded a version from git tag\r\nHandling numeric, date and percent values a bit better\r\n\r\nRelease Notes: 0.1.12\r\n--------------------- \r\n\r\nCleanup release\r\n\r\n\r\nRelease Notes: 0.1.11 \r\n--------------------- \r\nAdded support for inline format with double-pipe notation.\r\nRemoved unneeded imports.\r\nMinor fixes to value retrieval\r\n\r\nRelease Notes: 0.1.10 \r\n--------------------- \r\n\r\nPackaging was not following best practice of examples within the package. \r\nBug fix: Unicode was not correctly handled. \r\n\r\nRelease Notes: 0.1.9 \r\n-------------------- \r\n\r\nMinor font issues fixed. Italics and font-name were being ignored. \r\nSome other minor items fixed. \r\n\r\nRelease Notes: 0.1.8 \r\n-------------------- \r\n\r\nAdded support for hyperlinks: \r\n\r\n- Unfortunately openpyxl does not yet support reading hyperlinks. \r\n- The way to enter hyperlinks is to place the hyperlink and wiki display text in a cell, such as: \"http://yahoo.com Yahoo!\" \r\n- Any cell containing \"http\" will be wrapped within []s. \r\n\r\nBugs: \r\n----- \r\n\r\n- Caption was missing, added it back. \r\n- Caption style was incorrectly set. fixed. \r\n- unneeded parameter headerRow removed. \r\n- unneeded cellToWiki method removed \r\n\r\n\r\nRelease Notes: 0.1.7 \r\n-------------------- \r\nCleaner output of wiki text. \r\n- Common cell styles across the row are boiled up to row style. \r\n- Common row style items are boiled up to table. \r\n\r\n\r\nRelease Notes: 0.1.6 \r\n-------------------- \r\nMinor: black was being ignored for bg color as well. Instead of only the fg color \r\n\r\nRelease Notes: 0.1.5 \r\n-------------------- \r\n\r\n* Added border as default. \r\n* Removed font color from markup when color is black", "description_content_type": null, "docs_url": null, "download_url": "https://github.com/venkman69/ExcelToWiki", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "", "keywords": "excel wiki convert xlsx markup table", "license": "", "maintainer": "", "maintainer_email": "", "name": "exceltowiki", "package_url": "https://pypi.org/project/exceltowiki/", "platform": "", "project_url": "https://pypi.org/project/exceltowiki/", "project_urls": { "Download": "https://github.com/venkman69/ExcelToWiki" }, "release_url": "https://pypi.org/project/exceltowiki/0.1.19/", "requires_dist": null, "requires_python": null, "summary": "Convert Excel to Wiki while maintaining formatting", "version": "0.1.19" }, "last_serial": 2114103, "releases": { "0.1.1": [ { "comment_text": "", "digests": { "md5": "7b8b4dee509bebc7650911da2fc5ed84", "sha256": "a5c69b68bc48b7b97a2e38333791eef397074d9a856aceb5450916b92d9ba8d5" }, "downloads": -1, "filename": "exceltowiki-0.1.1.tar.gz", "has_sig": false, "md5_digest": "7b8b4dee509bebc7650911da2fc5ed84", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 34231, "upload_time": "2015-07-29T13:40:51", "url": "https://files.pythonhosted.org/packages/1d/aa/c3fadc7211b29d3250995e327bd6cb9e7332469c941d94dd9fe03f518dd0/exceltowiki-0.1.1.tar.gz" }, { "comment_text": "", "digests": { "md5": "f6c693d50dcb1c0534333d825220322e", "sha256": "6dbd48c77a64ac91ff444312a50649300e9b39ede9e9feadb53da53d6b7369a9" }, "downloads": -1, "filename": "exceltowiki-0.1.2.tar.gz", "has_sig": false, "md5_digest": "f6c693d50dcb1c0534333d825220322e", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 34456, "upload_time": "2015-07-29T18:29:29", "url": "https://files.pythonhosted.org/packages/3f/74/209efb88229748dc85c356614fe5ef67e107cd36d2d986fe5e05dc5c2d75/exceltowiki-0.1.2.tar.gz" } ], "0.1.10": [ { "comment_text": "", "digests": { "md5": "a17a490c98a3f09110c4d9ef585beef9", "sha256": "1aaf565183be2606af17252dc95f8d081f0fdf1236771658bff7975510e8e1b5" }, "downloads": -1, "filename": "exceltowiki-0.1.10.tar.gz", "has_sig": false, "md5_digest": "a17a490c98a3f09110c4d9ef585beef9", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 13871, "upload_time": "2015-08-29T00:32:52", "url": "https://files.pythonhosted.org/packages/cf/20/4d9e1d1b97006d1b08d67ff9bdab3fe533f44b017965b401ae56daa6ff72/exceltowiki-0.1.10.tar.gz" } ], "0.1.11": [ { "comment_text": "", "digests": { "md5": "e035d94fe5b132ad1c424802742d06c4", "sha256": "97be32bfed673907898a41fe6ac88fe1a1a786d5fa8b6e07faf1eabcd48ba46c" }, "downloads": -1, "filename": "exceltowiki-0.1.11.tar.gz", "has_sig": false, "md5_digest": "e035d94fe5b132ad1c424802742d06c4", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 13932, "upload_time": "2015-09-03T03:53:01", "url": "https://files.pythonhosted.org/packages/a5/fe/3719fb292e5ba1dd4c4485fe6f852d44c6c7073571eb3ee0c57853747669/exceltowiki-0.1.11.tar.gz" } ], "0.1.12": [], "0.1.13": [ { "comment_text": "", "digests": { "md5": "c207e5a5b793530f6e925facd90be8d0", "sha256": "27bb4b71a68e786ba14b866ad8c19d5397cbccbe63a3aa118d61d972e71c8914" }, "downloads": -1, "filename": "exceltowiki-0.1.13a.tar.gz", "has_sig": false, "md5_digest": "c207e5a5b793530f6e925facd90be8d0", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 16858, "upload_time": "2015-11-10T16:30:09", "url": "https://files.pythonhosted.org/packages/23/0f/e8f2590404940dc65de120e87810396edebf63c9eaeafd1f09dd728806b6/exceltowiki-0.1.13a.tar.gz" } ], "0.1.13b": [ { "comment_text": "screwedup upload versions.. ver is still 0.1.13", "digests": { "md5": "3068ebd87f7ed2aeba106b2e90cfe7f8", "sha256": "bdecfabcb17550ec0062ef7ff268a029cac6c5ef9b426e8f2747ce87d27208fc" }, "downloads": -1, "filename": "exceltowiki-0.1.13b.tar.gz", "has_sig": false, "md5_digest": "3068ebd87f7ed2aeba106b2e90cfe7f8", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 16857, "upload_time": "2015-11-10T16:35:43", "url": "https://files.pythonhosted.org/packages/36/59/21be7da6ff2e7f4f219c3ef53814b860d85a0c0726ffb32913523c82c7e3/exceltowiki-0.1.13b.tar.gz" } ], "0.1.14": [ { "comment_text": "", "digests": { "md5": "ace4c2539d6d4795d65ca9a00cbdfa04", "sha256": "42a1b13578c4a7e95c3ae3634f34a727e87cc24fed1d17766273b5a22759bd76" }, "downloads": -1, "filename": "exceltowiki-0.1.14.tar.gz", "has_sig": false, "md5_digest": "ace4c2539d6d4795d65ca9a00cbdfa04", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 16858, "upload_time": "2015-11-10T16:38:10", "url": "https://files.pythonhosted.org/packages/9a/a5/059fd5865c842ad73cbaee3c09b312184030867047c73b7081431102d2ba/exceltowiki-0.1.14.tar.gz" } ], "0.1.15": [ { "comment_text": "", "digests": { "md5": "28092cc3be8aa00ed8943df11a545b7f", "sha256": "8620a67dd89bfc5896653355210e9954837e350d4228a449aedadddc1a37cec9" }, "downloads": -1, "filename": "exceltowiki-0.1.15.tar.gz", "has_sig": false, "md5_digest": "28092cc3be8aa00ed8943df11a545b7f", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 16996, "upload_time": "2015-11-10T17:05:50", "url": "https://files.pythonhosted.org/packages/d3/fc/a3898c2cae25ba5a83eda9f1c656d5e132172d1691112098a828b70f9541/exceltowiki-0.1.15.tar.gz" } ], "0.1.16": [ { "comment_text": "", "digests": { "md5": "6e5fcce4b4d073959019d6b86da25477", "sha256": "a9cc66ca358544468d67674047c9af6956782d05745b4debff6dcae7b970185b" }, "downloads": -1, "filename": "exceltowiki-0.1.16.tar.gz", "has_sig": false, "md5_digest": "6e5fcce4b4d073959019d6b86da25477", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 17055, "upload_time": "2016-02-05T03:32:50", "url": "https://files.pythonhosted.org/packages/74/04/00170b5c14d3bbfde5d49e368751164aea4e28cbcb33e71f8dfc723c409e/exceltowiki-0.1.16.tar.gz" } ], "0.1.17": [ { "comment_text": "", "digests": { "md5": "8dd8e4eac8e2e5d5e11cb85421d0091d", "sha256": "e9f80f61475e68b80f644b3e2731e04bb4524dcc2af8828a54172d0467782c56" }, "downloads": -1, "filename": "exceltowiki-0.1.17.tar.gz", "has_sig": false, "md5_digest": "8dd8e4eac8e2e5d5e11cb85421d0091d", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 17176, "upload_time": "2016-02-18T02:00:52", "url": "https://files.pythonhosted.org/packages/3c/00/982bd380ea1558e1d13f769a7d742b101f323c16872443492ddacc745b8d/exceltowiki-0.1.17.tar.gz" } ], "0.1.18": [ { "comment_text": "", "digests": { "md5": "053d8bdcd708154e8d7f5baf1dc8c833", "sha256": "ab3864d2f5b6db71fc2284d557a6bb7597acf0708cef327b21765b5e40a89499" }, "downloads": -1, "filename": "exceltowiki-0.1.18.tar.gz", "has_sig": false, "md5_digest": "053d8bdcd708154e8d7f5baf1dc8c833", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 17331, "upload_time": "2016-04-28T02:11:53", "url": "https://files.pythonhosted.org/packages/c2/0b/51f3a323084fc3706fe673aa8d9c3126884b60649b53bb7174c61e533ef2/exceltowiki-0.1.18.tar.gz" } ], "0.1.19": [ { "comment_text": "", "digests": { "md5": "31b740cfd11dcc9fe2fd54c21efabd02", "sha256": "1761f544f29bfc9bd251f124dfad040e660b923a0b2485859af67f269f7169c5" }, "downloads": -1, "filename": "exceltowiki-0.1.19.tar.gz", "has_sig": false, "md5_digest": "31b740cfd11dcc9fe2fd54c21efabd02", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 17866, "upload_time": "2016-05-13T12:36:59", "url": "https://files.pythonhosted.org/packages/a3/84/f4312d6732fdc32c9c642c2fd4875d8e6c34d8a320774810160fc88dc4c4/exceltowiki-0.1.19.tar.gz" } ], "0.1.3": [ { "comment_text": "", "digests": { "md5": "e1f8e75cd8f73a3b3f772e27a03bec49", "sha256": "1776672c5626b74c7be9380f7ab1ed3dee5c83a31f316c45a1e6e0146ad52e5e" }, "downloads": -1, "filename": "exceltowiki-0.1.3.tar.gz", "has_sig": false, "md5_digest": "e1f8e75cd8f73a3b3f772e27a03bec49", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 34460, "upload_time": "2015-07-29T18:35:00", "url": "https://files.pythonhosted.org/packages/46/c1/8b43fdb1806e1ad7a1ac84d00a073295a65780a7d9b504e6a9438e662e62/exceltowiki-0.1.3.tar.gz" } ], "0.1.4": [ { "comment_text": "", "digests": { "md5": "a754f3ccc8afacaa06c7d2135d7be304", "sha256": "c1bd006fece40fe348e385ca44c1dbcb948e5522843120f4f5a06cc9533f2db3" }, "downloads": -1, "filename": "exceltowiki-0.1.4.tar.gz", "has_sig": false, "md5_digest": "a754f3ccc8afacaa06c7d2135d7be304", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 34579, "upload_time": "2015-07-29T21:50:20", "url": "https://files.pythonhosted.org/packages/0a/74/89c9271800a34d65dac7c321393b2fc0f6b480ede48839af590f03ed5882/exceltowiki-0.1.4.tar.gz" } ], "0.1.5": [ { "comment_text": "", "digests": { "md5": "4fd8ceffd52bfd6b5b5f2a2078fd0ce4", "sha256": "96089594e74f7c883ebee420f662838110f391c66d3d699848d99dce0371053c" }, "downloads": -1, "filename": "exceltowiki-0.1.5.tar.gz", "has_sig": false, "md5_digest": "4fd8ceffd52bfd6b5b5f2a2078fd0ce4", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 34679, "upload_time": "2015-07-31T03:14:29", "url": "https://files.pythonhosted.org/packages/42/45/ce5f9cf22f4fb8059684e8fbddd1e2bdc819c5f9d30e3e9b3d271d0e71d1/exceltowiki-0.1.5.tar.gz" } ], "0.1.6": [ { "comment_text": "", "digests": { "md5": "a0e9258169bb654817b3f2ac3d5aa94d", "sha256": "4b9fbdfc9ba68b0da232745a73a4af5ce382ebebd0eb0bb2a0a21b4f1a72611f" }, "downloads": -1, "filename": "exceltowiki-0.1.6.tar.gz", "has_sig": false, "md5_digest": "a0e9258169bb654817b3f2ac3d5aa94d", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 34681, "upload_time": "2015-07-31T17:32:06", "url": "https://files.pythonhosted.org/packages/d7/28/4283f2adf41d648da0eaf202dca5cc7b3bc0b94559086e903d86e5f19e6c/exceltowiki-0.1.6.tar.gz" } ], "0.1.7": [ { "comment_text": "", "digests": { "md5": "a36ac1f4453cb74a4446698df0be58cf", "sha256": "09cff9a723547597a5234ff8d16e76211bc32038e13b1becec9c8c34da522908" }, "downloads": -1, "filename": "exceltowiki-0.1.7.tar.gz", "has_sig": false, "md5_digest": "a36ac1f4453cb74a4446698df0be58cf", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 38294, "upload_time": "2015-08-11T02:45:49", "url": "https://files.pythonhosted.org/packages/25/42/3412e6caf58894ecbdb89d8a0af8201498e86cfb2d186504da1a540c227b/exceltowiki-0.1.7.tar.gz" } ], "0.1.9": [ { "comment_text": "", "digests": { "md5": "b8571e796dd1fd192ae0248825890c31", "sha256": "754de4c7959072bf53aee35aefa8dd434060f77728a3ad3c9a0ee49c5bdb8aa1" }, "downloads": -1, "filename": "exceltowiki-0.1.9.tar.gz", "has_sig": false, "md5_digest": "b8571e796dd1fd192ae0248825890c31", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 13801, "upload_time": "2015-08-27T23:39:19", "url": "https://files.pythonhosted.org/packages/7e/1f/fca133400f51dcca15995c769857c2d1c8c789467ef35204175ba0371fe4/exceltowiki-0.1.9.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "31b740cfd11dcc9fe2fd54c21efabd02", "sha256": "1761f544f29bfc9bd251f124dfad040e660b923a0b2485859af67f269f7169c5" }, "downloads": -1, "filename": "exceltowiki-0.1.19.tar.gz", "has_sig": false, "md5_digest": "31b740cfd11dcc9fe2fd54c21efabd02", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 17866, "upload_time": "2016-05-13T12:36:59", "url": "https://files.pythonhosted.org/packages/a3/84/f4312d6732fdc32c9c642c2fd4875d8e6c34d8a320774810160fc88dc4c4/exceltowiki-0.1.19.tar.gz" } ] }