streamlit 导出为Excel

最新推荐文章于 2024-06-19 13:17:09 发布

繁梦溪

最新推荐文章于 2024-06-19 13:17:09 发布

阅读量387

点赞数 1

文章标签： python 前端 Streamlit

本文链接：https://blog.csdn.net/fg24151110876/article/details/136322468

版权

这段代码展示了如何使用pandas、io、pyxlsb库将数据转换为Excel，并附带下载功能。它定义了一个函数`to_excel`，用于设置格式并下载Excel文件。

摘要由CSDN通过智能技术生成

import pandas as pd
from io import BytesIO
from pyxlsb import open_workbook as open_xlsb
import streamlit as st

def to_excel(df):
    output = BytesIO()
    writer = pd.ExcelWriter(output, engine='xlsxwriter')
    df.to_excel(writer, index=False, sheet_name='Sheet1')
    workbook = writer.book
    worksheet = writer.sheets['Sheet1']
    format1 = workbook.add_format({'num_format': '0.00'}) 
    worksheet.set_column('A:A', None, format1)  
    writer._save()# writer.save() 版本问题使用：_save()
    processed_data = output.getvalue()
    return processed_data
df_xlsx = to_excel(df)
st.download_button(label='📥 Download Current Result',
                                data=df_xlsx ,
                                file_name= 'df_test.xlsx')