Importing from Excel

[meredydd]

If you want more sample code, here’s an example I posted the other week, which uses the Uplink to import an Excel sheet into a data table:

Importing existing data into Data Table

Hi Chris, Anvil can return a lot from a server function, but custom classes like Pandas data frame rows will fox it. If you want to return data like this, I’d suggest turning it into a dict (Pandas’s to_dict() method will help you here). In fact, if you’re using the uplink, you don’t even need to return this data from a server function - you can add it to the data table directly! You can call add_row() on a data table from Uplink code, same as server code. Something like this, perhaps: impor…