{ "info": { "author": "Jim Luo", "author_email": "luozhijian@gmail.com", "bugtrack_url": null, "classifiers": [ "License :: OSI Approved :: MIT License", "Operating System :: OS Independent", "Programming Language :: Python :: 2" ], "description": "# jupyterexcel Package\n\nThis is a package to make Jupyter.ipynb file a web api with json result. You can call Jupyter from Excel Formula or Ribbon CallBack Functions\nSourceCode in [JupyterExcel](https://github.com/luozhijian/jupyterexcel)\n\nThis Jupyter Excel web api can be connected with Excel addin which call this web api. Excel formula will generate a web api url and through winhttp to get json result.\n\n## Installation \n\n pip install jupyterexcel\n\nthen run \n\n jupyter serverextension enable --py jupyterexcel\n\n## Server setting\n\nPlease config [jupyter server](https://jupyter-notebook.readthedocs.io/en/stable/public_server.html) like the following:\n```\nc.NotebookApp.token = 'ABCD' #it is good to use token mode for web api call to pass through\nc.NotebookApp.allow_remote_access = True #if you like to set to access from other computer\n```\n## Example\nThe following screenshot shows the sample notebook file with a function sum. You can download TestingJupyter.ipynb or create your own. The following is an instance I hosted in google cloud platform, you can open and add a function of yours.\n'''\nhttp://34.73.64.35:8888/Excel/TestingJupyter.ipynb?token=ABCD&functionname=sum&1=11&2=8&3=6\nhttp://34.73.64.35:8888/notebooks/TestingJupyter.ipynb\n'''\n\n![NotebookExample](NotebookExample.png)\n\nThe following screenshot shows how excel Formula works. \n![Jupyter Excel](ExcelFormulaScreen.png)\n\nThe following screenshot Shows how Ribbon Call Back function works\n![Jupyter Ribbon CallBack](ExcelRibbonScreen.png)\n\n\n## Future Development Plan\n1. Make Excel client side more easier to use, such as generate Excel formula proxy\n2. Able to support R, Julia ....\n\n## Reference \nread some code from [appmode](https://github.com/oschuett/appmode)\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/luozhijian/jupyterexcel", "keywords": "", "license": "", "maintainer": "", "maintainer_email": "", "name": "jupyterexcel", "package_url": "https://pypi.org/project/jupyterexcel/", "platform": "", "project_url": "https://pypi.org/project/jupyterexcel/", "project_urls": { "Homepage": "https://github.com/luozhijian/jupyterexcel" }, "release_url": "https://pypi.org/project/jupyterexcel/0.0.8/", "requires_dist": null, "requires_python": "", "summary": "A Jupyter extensions to make notebooks web api for Excel to call using UDF forumla or Ribbon Callback. Jupyter Excel, Python Excel", "version": "0.0.8" }, "last_serial": 5510959, "releases": { "0.0.1": [ { "comment_text": "", "digests": { "md5": "526e372c79351ce6c254ef290c564755", "sha256": "d78f2efd25fc6d8b5eeed0d0053c7e7b76c9ab111255da2e3d0ba00742638a5f" }, "downloads": -1, "filename": "jupyterexcel-0.0.1-py3-none-any.whl", "has_sig": false, "md5_digest": "526e372c79351ce6c254ef290c564755", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 16659, "upload_time": "2019-05-30T08:25:42", "url": "https://files.pythonhosted.org/packages/c3/38/43c54cb2db24bfb7c1338057070f2d246fa250a7b1721944219929c397a4/jupyterexcel-0.0.1-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "a2dde3e7fb63264514067dd42b296f7d", "sha256": "c5e83510663323b249dc630e44f5b6a2c855f91793d217c999f4e476f49f798e" }, "downloads": -1, "filename": "jupyterexcel-0.0.1.tar.gz", "has_sig": false, "md5_digest": "a2dde3e7fb63264514067dd42b296f7d", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3697, "upload_time": "2019-05-30T08:25:44", "url": "https://files.pythonhosted.org/packages/53/4e/0f3a2eefb0e7e1a12d805a2de61cfc9796d6efd37b944d02f4e5cf06a0a3/jupyterexcel-0.0.1.tar.gz" } ], "0.0.2": [ { "comment_text": "", "digests": { "md5": "9e076a72d33c025bf52fa27f1f744c52", "sha256": "b3f6b5c7d0a3992381fd868d226bbe88dbec3b261843e6d5024513e49473a705" }, "downloads": -1, "filename": "jupyterexcel-0.0.2-py3-none-any.whl", "has_sig": false, "md5_digest": "9e076a72d33c025bf52fa27f1f744c52", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 5178, "upload_time": "2019-06-02T06:12:19", "url": "https://files.pythonhosted.org/packages/d6/c5/48707c3dd5f3599f98480aab5d738b4bc74e94835a5dcde8c739f357ad00/jupyterexcel-0.0.2-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "d62261318bdd05c1f1e3a51e61edc31f", "sha256": "fc17cfb99940cdb389177bd038596b87ed2e19dbbc13981a47a6571b32be852b" }, "downloads": -1, "filename": "jupyterexcel-0.0.2.tar.gz", "has_sig": false, "md5_digest": "d62261318bdd05c1f1e3a51e61edc31f", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3907, "upload_time": "2019-06-02T06:12:20", "url": "https://files.pythonhosted.org/packages/f6/35/fc8e05e401ccb8c48e709963bc8f926f0b8a78ee8c42f014ba6cf9c8d245/jupyterexcel-0.0.2.tar.gz" } ], "0.0.3": [ { "comment_text": "", "digests": { "md5": "bd144293a7f0b9e974f7f8f25177285c", "sha256": "b9b03c91a0e84b6bb11e962722efddf30a4b3208ca361ff27d1e86d4bd46f753" }, "downloads": -1, "filename": "jupyterexcel-0.0.3-py3-none-any.whl", "has_sig": false, "md5_digest": "bd144293a7f0b9e974f7f8f25177285c", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 5280, "upload_time": "2019-06-04T06:05:36", "url": "https://files.pythonhosted.org/packages/26/14/3b5d8e0c63e15446dcc040358a2812712c440b7a095108f6dc26b90b071f/jupyterexcel-0.0.3-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "4e9fa78fe0af42e6d1588b3f30e1043e", "sha256": "8e3223f7885e16f973e47e5187cf83fc70d9bfa11165ee8355c131ddadb27eda" }, "downloads": -1, "filename": "jupyterexcel-0.0.3.tar.gz", "has_sig": false, "md5_digest": "4e9fa78fe0af42e6d1588b3f30e1043e", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4016, "upload_time": "2019-06-04T06:05:37", "url": "https://files.pythonhosted.org/packages/d2/1f/bd616d5a4a362eeeeb188595b14113fd8608a588c929eb9d5b8ffeb9523d/jupyterexcel-0.0.3.tar.gz" } ], "0.0.5": [ { "comment_text": "", "digests": { "md5": "39bf9f71bb72a42a001d93f80b530229", "sha256": "a335e5fb8a44eee89e02ec9721fa7922c44d14f0f322645997a96f4776f9045d" }, "downloads": -1, "filename": "jupyterexcel-0.0.5-py3-none-any.whl", "has_sig": false, "md5_digest": "39bf9f71bb72a42a001d93f80b530229", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 5329, "upload_time": "2019-06-17T06:11:00", "url": "https://files.pythonhosted.org/packages/9f/7a/09efc78a7fb18d25553bfe3da8cd76ef0fb7bdf77d0d1492d2936a0e8bc5/jupyterexcel-0.0.5-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "12729bf0cc686b11105d9151dc18e562", "sha256": "d9f66789f85fce0e2f2ecb9ec0b7cd4b715bb06d2030d0714d389b57ab482537" }, "downloads": -1, "filename": "jupyterexcel-0.0.5.tar.gz", "has_sig": false, "md5_digest": "12729bf0cc686b11105d9151dc18e562", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4063, "upload_time": "2019-06-17T06:11:02", "url": "https://files.pythonhosted.org/packages/aa/4a/5ad9cd626d77e9eddaf10b5f514e626517b5bd20fb7a12c9fe2ebceec022/jupyterexcel-0.0.5.tar.gz" } ], "0.0.6": [ { "comment_text": "", "digests": { "md5": "52cc419aff712b2cde0fdde00f9de8e5", "sha256": "c5e7a010170408ee4f3832af102a06106581737bde0a588c4b3460696edacfd5" }, "downloads": -1, "filename": "jupyterexcel-0.0.6-py3-none-any.whl", "has_sig": false, "md5_digest": "52cc419aff712b2cde0fdde00f9de8e5", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 6410, "upload_time": "2019-07-07T08:56:00", "url": "https://files.pythonhosted.org/packages/0c/a8/96590626d1d257e1d65e3af98a2dac29ed64993728209f679c95d7ac46c8/jupyterexcel-0.0.6-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "8b64bd47fbe20e87e48ce40d4e254a5f", "sha256": "bd532c790be88f60ccfc536dfa22edac623ac75c62ba4ec3b8b8c555f731c22c" }, "downloads": -1, "filename": "jupyterexcel-0.0.6.tar.gz", "has_sig": false, "md5_digest": "8b64bd47fbe20e87e48ce40d4e254a5f", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4882, "upload_time": "2019-07-07T08:56:01", "url": "https://files.pythonhosted.org/packages/34/7e/90565f8d20ff3514900b9eb3d8d6376ec1184d1a8c2a90ed2aef0ea4e480/jupyterexcel-0.0.6.tar.gz" } ], "0.0.7": [ { "comment_text": "", "digests": { "md5": "b940f59187afad0ef03108bc7f58bcd2", "sha256": "c7742afe7b03c237f2d70e981aac1844d68a648490115ce00177904f3f4e4cfc" }, "downloads": -1, "filename": "jupyterexcel-0.0.7-py3-none-any.whl", "has_sig": false, "md5_digest": "b940f59187afad0ef03108bc7f58bcd2", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 6437, "upload_time": "2019-07-07T09:17:03", "url": "https://files.pythonhosted.org/packages/30/f5/dd580ab1ff60db4e820bad4048b3ea3d79ecf536caebdf3f1e0e7e012e72/jupyterexcel-0.0.7-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "073f2c27f391d93e382f924cc8818701", "sha256": "7be138cddefa159a222caf3042b904d48a488a0b2cf487b9af018cd09a462b98" }, "downloads": -1, "filename": "jupyterexcel-0.0.7.tar.gz", "has_sig": false, "md5_digest": "073f2c27f391d93e382f924cc8818701", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4901, "upload_time": "2019-07-07T09:17:05", "url": "https://files.pythonhosted.org/packages/27/bc/25c89ff5131a172c7f249f6445d5aade75faca5d3a074e838bef220f15a2/jupyterexcel-0.0.7.tar.gz" } ], "0.0.8": [ { "comment_text": "", "digests": { "md5": "69f7fba85b08b798757809ac50254b74", "sha256": "7a9b9594535a52776787f52ffc7396b03eab89a18fbf86ae59c62e9735a47080" }, "downloads": -1, "filename": "jupyterexcel-0.0.8-py3-none-any.whl", "has_sig": false, "md5_digest": "69f7fba85b08b798757809ac50254b74", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 6664, "upload_time": "2019-07-10T09:20:12", "url": "https://files.pythonhosted.org/packages/82/26/ba03ba42363f2a406bf9be0c3197e9a470d314212e007aaf32f2b21b6b27/jupyterexcel-0.0.8-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "562ba0db2e1afe2ffc9fa27cfc396f0d", "sha256": "f6b1e412cfe8c43b8187b728176c88f05ba89351396805d840756f70cbf9ff77" }, "downloads": -1, "filename": "jupyterexcel-0.0.8.tar.gz", "has_sig": false, "md5_digest": "562ba0db2e1afe2ffc9fa27cfc396f0d", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5121, "upload_time": "2019-07-10T09:20:15", "url": "https://files.pythonhosted.org/packages/45/91/3a8a1b900ba3b668bf6db070008c084c25e433a5b3434ec872f1258485c3/jupyterexcel-0.0.8.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "69f7fba85b08b798757809ac50254b74", "sha256": "7a9b9594535a52776787f52ffc7396b03eab89a18fbf86ae59c62e9735a47080" }, "downloads": -1, "filename": "jupyterexcel-0.0.8-py3-none-any.whl", "has_sig": false, "md5_digest": "69f7fba85b08b798757809ac50254b74", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 6664, "upload_time": "2019-07-10T09:20:12", "url": "https://files.pythonhosted.org/packages/82/26/ba03ba42363f2a406bf9be0c3197e9a470d314212e007aaf32f2b21b6b27/jupyterexcel-0.0.8-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "562ba0db2e1afe2ffc9fa27cfc396f0d", "sha256": "f6b1e412cfe8c43b8187b728176c88f05ba89351396805d840756f70cbf9ff77" }, "downloads": -1, "filename": "jupyterexcel-0.0.8.tar.gz", "has_sig": false, "md5_digest": "562ba0db2e1afe2ffc9fa27cfc396f0d", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5121, "upload_time": "2019-07-10T09:20:15", "url": "https://files.pythonhosted.org/packages/45/91/3a8a1b900ba3b668bf6db070008c084c25e433a5b3434ec872f1258485c3/jupyterexcel-0.0.8.tar.gz" } ] }