Much Better Dropdowns Jan 2025

~~~

I built a set of functions demonstrating dynamic filtering and sorting using Excel and PyXLL. The functions determine whether a value is within a numeric interval (closed, open, or any combination).

A video illustrates the performance.

One million filters

PyXLL PySide2 CTP ActiveX Sep 2024

UPDATE

I built a full PySide2 menu that allows the selection and presentation of AISC steel properties and the calculation of ASCE wind loads.

Filter a Pandas Dataframe using PyXLL (with video) Jul 2023

khoitsma
AISC, Concept, Engineering, Excel, Python, PyXLL, Video
0 Comments

The function uses only three parameters: the criteria range, the reverse sort toggle, and the upper limit on rows of results.

Note that conditional formatting is applied using the PyXLL formatter option.

lookup

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

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

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

Category: Video

Much Better Dropdowns Jan 2025

Interval Filter using PyXLL Oct 2024

PyXLL PySide2 CTP ActiveX Sep 2024

Filter a Pandas Dataframe using PyXLL (with video) Jul 2023

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

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

QuickLinks

Recent Posts

Archives