search

xlwings / xlwings-officejs-quickstart

8 stars 6 forks source link

Can't fetch from local Flask server #5

Open ReinforcedKnowledge opened 3 months ago

ReinforcedKnowledge commented 3 months ago

Hi!

Thanks a lot for the work that you have done on this project. I tried to run your repo to get a feeling of how this works but it seems Office still can't connect to the connect to the Flask server running on https://localhost:5000.

I have verified the certificates generated by mkcert using curl and reading them with openssl and my browser does show that the https://localhost:5000 is secure. But, I can't seem to fetch anything from it using the Office.js API. I even ran it inside the Script Lab API and any request to the localhost doesn't go through.

I was wondering if you had any information regarding this issue.

Below are the information regarding my environment:

Ubuntu 23.10 Python 3.11.6 Libraries are installed from your requirements file Browser: Brave 1.65.133 Chromium: 124.0.6367.208 (Official Build) (64-bit)

Thank you!

fzumstein commented 3 months ago

Does it have to be flask? I am in process of building an out-of-the box "official" xlwings Server: https://github.com/xlwings/xlwings-server maybe you want to give it a try? It's even setup to run on GitHub codespaces

ReinforcedKnowledge commented 3 months ago

No it doesn't have to be Flask. As long as I have a Python backend it's good! I just went with Flask because I'm familiar with it. Do you think this issue might be tied to some specifics of Flask? I can try the others, or even use Nginx as a reverse proxy. I'll do that and come back to you. This might be of help to others 😄

I'll check out the link xlwings server as well, thank you!

fzumstein commented 3 months ago

I mean, it’ll work with all the web frameworks, but it’s easiest for me to support an official implementation. So let me know if you can’t get xlwings-server to run.