Import Error through xlwings

xlwings / xlwings

xlwings is a Python library that makes it easy to call Python from Excel and vice versa. It works with Excel on Windows and macOS as well as with Google Sheets and Excel on the web.

https://www.xlwings.org

Other

2.94k stars 497 forks source link

Import Error through xlwings #968

Closed akashsharma03 closed 5 years ago

akashsharma03 commented 5 years ago

Windows 7 Python 3.6, Office 2013, Xlwings 0.11.8


# Your traceback here
RunPython Cannot Import a module that is inside a folder in the same directory as the workbook.
It can import one module but not some.
All the modules can be imported through the python interpreter in command line.
VBA code:
RunPython ("from dqm_scripts import excel_metadata;excel_metadata.get_sheet_names('" & SheetName & "','" & sRange & "','" & sOutputSheet & "','" & sOutputRange & "')")

fzumstein commented 5 years ago

Please upload a zip file with a sample to be able to replicate the issue.