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

Python — develop, sell, deploy, protect Nov 2022

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

Hint: it isn’t the programming.

Two Point Lift with Rotation Aug 2022

Two point lifts with rotation sometimes defy simple intuition.
I present several features in my Excel spreadsheet.

Lift Sequence from horizontal to vertical

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.

Adding tools to Excel Jan 2022

In a short video, I show how to modify the Excel ribbon

Excel Functions Nov 2021

New functions in Excel 2019

Excel Dropdown with NO worksheet data list — redux Aug 2021

I decided to delete this post … There are limits to the number of items that will show in a data validation drop down list: The list can show up to show 32,767 items from a list on the worksheet. If you type the items into the data validation dialog box (a delimited list), the […]

Transform Axes Jun 2021

In structural engineering, we must constantly deal with axes transformations. Mostly we have right handed coordinates (RHC), but sometimes left handed coordinates (LHC).