![]() You can ignore following 3 connections,if you connect only from local computerĬ.NotebookApp.allow_remote_access = True #if you like to set to access from other computerĬ.NotebookApp.ip = '0.0.0.0' #allow all ip address to connect to this instanceĬ.NotebookApp.iopub_data_rate_limit = 32000000 #it might be good to change to a high number, if you will pass out large amount of data. In the url in Excel, if it is not token, it will cause page forward to ask password, the excel will not workĬ.NotebookApp.allow_origin = '*' #allow any origin to access your server. Remember the file pathĪnd change following values: c.NotebookApp.token = 'ABCD' #now, it has to use token mode. If the file alraady there, please do not override. Please follow config jupyter server or use command jupyter notebook -generate-config Then run jupyter serverextension enable -py jupyterexcel Excel formula will generate a web api url and through winhttp to get json result. This Jupyter Excel web api can be connected with Excel addin which call this web api. If you think it works, you can modify the url in the sheet to your jupyter page and save it as "Addin" file. ![]() You can call Jupyter from Excel Formula or Ribbon CallBack Functionsīefore install, please download JupyterExcelTesting.xlsm to try its formula function and excel ribbon. This is a python package to make Jupyter.ipynb file a web api with json result.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |