Hi Alex,
Great to have you with us! As you kindly organised your points, I’ll respond to each in order:
- Small help button which shows text when clicked
The easiest way to do this is to have a Link or Button that opens an alert when clicked.
Here’s an example app (click to make a copy and open it in the Anvil editor). It has a Link component that has no URL, but its click event pops open an alert box with help:
- Listbox allowing to present data and modify data, if needed
The standard way of presenting and modifying data in Anvil is to use a LinearPanel and add a series of Forms to it. Our To-Do List tutorial will show you how to do this.
- Animated forms/panels (e.g. closing or opening slowly)
This one is definitely a feature request! Can I ask what you want to use it for?
- Excel file upload/download, specifically for reading/writing the data. In Python, I was using Openpyxl but I don’t think there’s actually a way to use Openpyxl with the current FileUploader component (did not try yet).
I’ve got good news for you! You can use Openpyxl in Anvil server modules. You just need to pass the Media object you get from the FileLoader into a server module, then write it to a temporary file and use it from there. Here’s a forum post with some example code (it’s using pandas rather than openpyxl, but it’s the same mechanism):
And if you just want to do a one-time import using the Anvil Uplink, here’s some example code for doing just that:
I hope all this helps!