Azure Functions本地调试依赖模块找不到问题及解决方法

在VS Code中创建本地Azure Functions应用后，初始本地调试可正常运行；但在requirements.txt中添加如pandas等库并完成安装后，调试时会抛出ModuleNotFoundError，提示找不到对应模块。即使通过以下代码检测到虚拟环境已激活且库已安装，问题仍存在：

import sys
import os

def get_virtual_env_path():
    if hasattr(sys, 'real_prefix') or (hasattr(sys, 'base_prefix') and sys.base_prefix != sys.prefix):
        # Virtual environment is likely active
        return sys.prefix
    elif 'VIRTUAL_ENV' in os.environ:
        # Check if VIRTUAL_ENV environment variable is set
        return os.environ['VIRTUAL_ENV']
    else:
        return None

# Example usage
virtual_env_path = get_virtual_env_path()

if virtual_env_path:
    print(f"The path to the active virtual environment is: {virtual_env_path}")
else:
    print("No virtual environment is currently active.")

报错信息示例：

Worker failed to load function: 'HttpTrigger1' with functionId: '62b41d74-8a9b-46b9-a6db-9ccabee3c906'. [2024-02-01T16:26:42.644Z] Result: Failure Exception: ModuleNotFoundError: No module named 'pandas'. Please check the requirements.txt file for the missing module. For more info, please refer the troubleshooting guide: https://aka.ms/functions-modulenotfound Stack:   File "C:\Program Files\Microsoft\Azure Functions Core Tools\workers\python\3.9/WINDOWS/X64\azure_functions_worker\dispatcher.py", line 387, in _handle__function_load_request     func = loader.load_function(   File "C:\Program Files\Microsoft\Azure Functions Core Tools\workers\python\3.9/WINDOWS/X64\azure_functions_worker\utils\wrappers.py", line 48, in call     raise extend_exception_message(e, message)   File "C:\Program Files\Microsoft\Azure Functions Core Tools\workers\python\3.9/WINDOWS/X64\azure_functions_worker\utils\wrappers.py", line 44, in call     return func(*args, **kwargs)   File "C:\Program Files\Microsoft\Azure Functions Core Tools\workers\python\3.9/WINDOWS/X64\azure_functions_worker\loader.py", line 194, in load_function     mod = importlib.import_module(fullmodname)   File "C:\Program Files\WindowsApps\PythonSoftwareFoundation.Python.3.9_3.9.3568.0_x64__qbz5n2kfra8p0\lib\importlib\__init__.py", line 127, in import_module     return _bootstrap._gcd_import(name[level:], package, level)   File "C:\Users\User\Documents\Projects\project_test\test\HttpTrigger1\__init__.py", line 4, in <module>     import pandas as pd

经排查，问题根源为Azure Functions启动时的内置环境依赖与本地.env文件存在冲突，可通过以下步骤解决：

• 删除VS Code缓存并卸载VS Code
• 彻底删除Azure Functions Core Tools缓存及相关VS Code扩展（卸载时未自动清理的残留文件）
• 卸载Python
• 清理电脑中的空文件夹或损坏文件夹
• 重新安装所有组件后问题即可解决

内容的提问来源于stack exchange，提问作者mohamed laroussi metoui