python cant connect to xlwings. “Error: Error Kind: ModuleNotFoundError Error Details: Traceback (most recent call last): File “Imports and Definitions”, line 2, in import xlwings as xw ModuleNotFoundError: No module named 'xlwings”
TL;DR You cannot use xlwings with Anaconda Code or Python in Excel.
xlwings is designed to execute outside of Excel and interface with Excel via COM or XLL interfaces. It assumes it has full visibility of the Excel .xlsx file and can read or write to any cell or sheet or even create a new workbook.
Anaconda Code and Python in Excel both operate within Excel. Excel is controlling Python, not the other way around. The Python runtime gets code, executes the code, and returns a value. It doesn’t know anything about Excel or the Excel file.
Based on the error, it appears you are using Anaconda Code and you are running into another issue, namely that you must install libraries you want to import.
This requires going to the Environments tab, clicking Edit, then using the “+ Add” dropdown to add packages (from pyodide, pypi, PyScript Apps, or wheels via URL). Once the environment is saved and updated, you can import the libraries.