Thanks for your answer @stucork
I’m doing my data manipulation with pandas. But the problem is that i need to download that information in a excel file, in the client side. Currently i can download a .csv file as a BlobMedia file. First a get all the data, then transform to a .csv file and then BlobMedia file. Because i can’t use a excel file as a BlobMedia object, i can’t download it.
Code example:
In server code
@anvil.server.callable
def exportToExcel(data, columns):
df1 = pd.DataFrame(data, columns=columns)
csv_media = anvil.BlobMedia(‘text/plain’, df_as_csv.encode(), name=f’Report {today}.csv’)
Then i return that csv_media to the client code and download it using:
csv_media_file= anvil.server.call(‘exportToExcel’) # exportToExcel is my server code function
anvil.media.download(csv_media_file)
I want to do the same BUT with a excel format. Where each value has it’s own column and not all values are in the same column