Transform 'LazyMedia' object to (PIL) image

[ianb]

I’m pretty sure PIL will take a file like object (which you can create in such a way as to keep the image in memory like you require).

Image Module

Something Like:

import io

file_obj = io.BytesIO( lazymedia_object.get_bytes() )
PIL_image_obj = PIL.Image.open( file_obj )

Here’s a link where we did something similar with pandas:

Pandas Dataframe (read file stored in database)

Ok try this: #put this at the top with the imports: import io @anvil.server.callable def read_csv(): for row in app_tables.table_1.search(): file = row['file_object'] f = io.BytesIO(file.get_bytes()) df = pd.read_excel(f) for d in df.to_dict(orient="records"): # d is now a dict of {columnname -> value} for this row # We use Python's **kwargs syntax to pass the whole dict as # keyword arguments # app_tables.data.add_row(**d) This Outside pri…