Since xlwings runs in every Python environment, you can use your preferred way of debugging. When running xlwings through Excel, there are a few tricks that make it easier to switch back and forth between Excel (for testing) and Python (for development and debugging).
To begin with, Excel will show any Python errors (but not warnings) in a Message Box:
On Mac, if the
import of a module/package fails before xlwings is imported, the popup will not be shown and the StatusBar
will not be reset. However, the error will still be logged in the log file.
Consider the following code structure of your Python source code:
import os from xlwings import Workbook, Range def my_macro(): wb = Workbook.caller() Range('A1').value = 1 if __name__ == '__main__': # To run from Python, not needed when called from Excel. # Expects the Excel file next to this source file, adjust accordingly. path = os.path.abspath(os.path.join(os.path.dirname(__file__), 'myfile.xlsm')) Workbook.set_mock_caller(path) my_macro()
my_macro() can now easily be run from Python for debugging and from Excel for testing without having to change the
Sub my_macro() RunPython ("import my_module; my_module.my_macro()") End Sub