How to install Spyder on Windows without Windows installer for using it with Jupyter notebooks

[ChrisDAT20]

Description of your problem

I want to edit/run Jupyter Notebooks with Spyder. Python environments exist with all needed packages (besides Spyder packages).
When running Spyder in an activated virtual environment, required and already installed packages in the virtual environment are not available.
How can I install spyder and spyder-notebook in order to be able to use Jupyter notebooks?
I do not want to install additional stuff into the environment, as with other tools this is not necessary as well.

What steps will reproduce the problem?

1. Checkout/create some Python project with all needed packages
2. Install Spyder
3. Activate virtual environment
4. Install spyder-kernels using pip
5. Start Spyder
6. Open and run Jupyter notebook

What is the expected output? What do you see instead?

Python can not find requirement packages, e.g. Plotly, Numpy, PySim
The notebook should be run without errors (as it does e.g. in JupyterLab, IntelliJ, VScode in the same virtual environment)

Please provide any additional information below (stack trace, screenshots, a gif, etc)

Versions and main components

• Spyder Version: 5.5.5
• Python Version: 3.9.13
• Qt Version: 5.15.2
• PyQt Version: 5.15.11
• Jupyter Notebook Version: 6.4.12
• Operating system: Windows 10

Dependencies

Mandatory:

atomicwrites >=1.2.0 : 1.4.1 (OK)
chardet >=2.0.0 : 5.2.0 (OK)
cloudpickle >=0.5.0 : 3.0.0 (OK)
cookiecutter >=1.6.0 : 2.6.0 (OK)
diff_match_patch >=20181111 : 20230430 (OK)
intervaltree >=3.0.2 : 3.1.0 (OK)
IPython >=8.13.0,<9.0.0,!=8.17.1 : 8.18.1 (OK)
jedi >=0.17.2,<0.20.0 : 0.19.1 (OK)
jellyfish >=0.7 : 1.0.4 (OK)
jsonschema >=3.2.0 : 4.23.0 (OK)
keyring >=17.0.0 : 25.2.1 (OK)
nbconvert >=4.0 : 7.16.4 (OK)
numpydoc >=0.6.0 : 1.7.0 (OK)
paramiko >=2.4.0 : 3.4.0 (OK)
parso >=0.7.0,<0.9.0 : 0.8.4 (OK)
pexpect >=4.4.0 : 4.9.0 (OK)
pickleshare >=0.4 : 0.7.5 (OK)
psutil >=5.3 : 6.0.0 (OK)
pygments >=2.0 : 2.18.0 (OK)
pylint >=3.1,<4 : 3.2.6 (OK)
pylint_venv >=3.0.2 : 3.0.3 (OK)
pyls_spyder >=0.4.0 : 0.4.0 (OK)
pylsp >=1.11.0,<1.12.0 : 1.11.0 (OK)
pylsp_black >=2.0.0,<3.0.0 : 2.0.0 (OK)
qdarkstyle >=3.2.0,<3.3.0 : 3.2.3 (OK)
qstylizer >=0.2.2 : 0.2.3 (OK)
qtawesome >=1.3.1,<1.4.0 : 1.3.1 (OK)
qtconsole >=5.5.1,<5.6.0 : 5.5.2 (OK)
qtpy >=2.1.0 : 2.4.1 (OK)
rtree >=0.9.7 : 1.3.0 (OK)
setuptools >=49.6.0 : 58.1.0 (OK)
sphinx >=0.6.6 : 7.4.7 (OK)
spyder_kernels >=2.5.2,<2.6.0 : 2.5.2 (OK)
textdistance >=4.2.0 : 4.6.2 (OK)
three_merge >=0.1.1 : 0.1.1 (OK)
watchdog >=0.10.3 : 4.0.1 (OK)
zmq >=24.0.0 : 26.0.3 (OK)

Optional:

cython >=0.21 : None (NOK)
matplotlib >=3.0.0 : None (NOK)
numpy >=1.7 : None (NOK)
pandas >=1.1.1 : None (NOK)
scipy >=0.17.0 : None (NOK)
sympy >=0.7.3 : None (NOK)

Spyder plugins:

spyder_notebook.notebookplugin 0.5.1 : 0.5.1 (OK)
spyder_terminal.terminalplugin 1.2.2 : 1.2.2 (OK)

[ccordoba12]

Hey @ChrisDAT20, thanks for reporting. How did you install Spyder?

[ChrisDAT20]

I used the Spyder-IDE Windows installer, although it is written on the website that notebooks wont work with the standalone installer. Afterwards I activated the existing virtual environment, installed spyder-kernels using pip into the virtual environment.
Then ran Spyder from that environment, opened a notebook and running it raised the issue that packages from the venv are not found by Spyder/the notebook.