The PyXLL/Jupyter interface would be drab without custom menus and graphical feedback.
I built an Excel dropdown function — that requires no worksheet reference!
The dropdown built into Excel requires a range of data to populate the dropdown list. This might be an appropriate situation if the spreadsheet is a one-off. In my work, the dropdown list would more appropriately be generated in my PyXLL program.
I built a short video demonstrating how to use dynamic arrays and conditional formatting to create a selection dependent menu.
Though I built this spreadsheet menu using Excel on a desktop machine, the spreadsheet file also works on an iPad ( ! ) and on an iPhone ( !! ).
Microsoft 365 is required.
The video shows the LCD Display connected to the Raspberry Pi. Easy setup Easy programming
I built this app and am running this app on my iPad. Credit to: mikaelho / pythonista – gestures tdamdouni / Pythonista Pythonista / slider / SliderWithLabel_danrcook.py The video shows an app with 8 inputs — 2 integer, 4 float, 2 boolean. Numeric input is tedious — at best; slider input is easier and offers positive feedback. In this […]
Very nice app for iPhone and iPad
I decided to try out Jupyter using Microsoft Azure (currently a free trial). I’ve invested a couple of days on this project including learning new notebook extensions and Interact widgets. And so far, so good. Pros Easy to use Well-documented Relatively trouble-free Cons Could have faster response times