Python version : Python 3.10 (recommended)
🛈 Note: xlwings is not supported by Python 3.11 at the moment.

Here, you can find the step by step process to use Steel Design Example using MS Excel.

1. Install numpy
2. Install pandas
3. Install xlwings
4. Install xlwings Add-in
5. Add Python Interpreter
6. Run the Script

You can install NumPy with:

pip install numpy

pandas can be installed via pip from PyPI.

🛈 Note:
You must have pip>=19.3 to install from PyPI.

pip install pandas

Python version support : Officially Python 3.8, 3.9, 3.10 and 3.11.

xlwings comes pre-installed with

• Anaconda (Windows and macOS)

• WinPython (Windows only) Make sure not to take the dot version as this only contains Python.

You can also install it with pip:

pip install xlwings

or conda:

conda install xlwings

To install the add-in, use the command line client:

xlwings addin install

🛈 Note:
The ribbon of the add-in is compatible with Excel >= 2007 on Windows and >= 2016 on macOS. On macOS, all UDF related functionality is not available.

🛈 Note:
The add-in is password protected with the password xlwings. For debugging or to add new extensions, you need to unprotect it. Alternatively, you can also install the add-in via xlwings addin install --unprotected.

Add your local python.exe path into interpreter in xlwings tab.

For example : C:\Python310\python.exe

To run the python code press Run main in xlwings ribbon.