Output of function is given as text value

[Johanvdberg]

Hallo

running the example I get the output of the sum function is

  {'text/plain': '19.0'} 

the value is is correct but cannot convert the result to a number. When the example notebook is used the result is correct but when a local notebook is used I get the error.

[luozhijian]

Is it should be {"text/plain": "19.0"}? double quote instead of single quote.
If this case, you can use json.loads('{"text/plain": "19.0"}' )['text/plain']) to get the result.

I am sometimes thinking remove "text/plain", and return only 19.0. With "text/plain", it also make the parsing in Excel VBA difficult. If remove "text/plain", I cannot return an error message string if there is an exception in the function. Please let me know if you have good suggestions.

I am not sure what it means "When the example notebook is used the result is correct but when a local notebook is used I get the error"

[Johanvdberg]

The part " When the example... " part was not correct I just tested gain, and yes double quotes.

The Excel VBA function FromJupyter can do the conversion to 19.0 or an alternatively a new function that call FromJupyter and do the conversion.

[luozhijian]

Yes. Thanks and good to know it works.

[Johanvdberg]

I don't know VBA how can I parse {"text/plain": "19.0"} to give 19.0?

[luozhijian]

Can you let me know which language do you use to call? I can change {"text/plain": "19.0"} to string "19.0", but it cannot be double 19.0 because it is a web call, it can return string.

[Johanvdberg]

Currently I am using, Python, Excel and Jupyter.

The idea Python/Jupyter to get data from Excel and save results in Excel, where the data is further processed in Excel. My difficulty is on the side of Excel to transform {"text/plain": "19.0"} to a form I can do arithmetic operations on.

[luozhijian]

Have you try https://www.xlwings.org/ xlwings. In xlwings, it can call python directly in same computer. I used it and like it. The only disadvantage is that it takes sometimes to start the python in first action, after that, it works great.