Saving big data frame from pandas in client code

[stucork]

1. create a BytesIO object
2. convert the dataframe to an excel file or csv where the first argument is the BytesIO object
3. create a BlobMedia object from the BytesIO object, calling its getvalue() method

An example with excel file

Download excel file

How about something like this: import io import pandas as pd @anvil.server.callable def export_to_excel(data, columns): df = pd.DataFrame(data, columns=columns) content = io.BytesIO() df.to_excel(content, index=False) content.seek(0, 0) return BlobMedia(content=content.read(), content_type="application/vnd.ms-excel") and on the client side, you might have this in a click hander for a download button: def download_button_click(self, **event_args): result = anvil.serve…

With csv file

    content = io.BytesIO()
    df.to_csv(content)
    blob = anvil.BlobMedia(content_type='text/csv', content=content.getvalue())
    return blob