Homepage
>
PyXLL

Enhanced Lookup — Excel and PyXLL June 2023

I built a couple special lookup functions using PyXLL

and

an interesting helper function

lookup

Continue Reading

Foundation Bearing Pressures using Jupyter and PyXLL (with videos) Mar 2023

khoitsma
Calculus, Engineering, Excel, Jupyter, Plotly, Python, PyXLL, Video
0 Comments

Continue Reading

ACI Rebar Lookup May 2023

khoitsma
ACI, Engineering, Engineering Codes, Excel, Python, PyXLL
0 Comments

I built a rebar lookup using PyXLL
lookup

Continue Reading

PyXLL using Jupyter and PySimpleGUI Interface (with video) Dec 2022

khoitsma
AISC, Excel, Jupyter, PySimpleGUI, Python, PyXLL, Video
0 Comments

This post features:
  the PyXLL add-on
  Jupyter
  the PySimpleGUI graphical interface

Continue Reading

Python — develop, sell, deploy, protect Nov 2022

In 2022, let’s consider the difficulties of development using Python.

Hint: it isn’t the programming.

Continue Reading

Excel — Taming of the Shapes with PyXLL May 2022

Using PyXLL, I have programmed automatic shapes in Excel. That is, I built a function that draws an arbitrary shape in a user spreadsheet: the shape is defined by a range of coordinates; as the coordinates are edited, a new shape can be drawn.

Continue Reading