运用openpyxl库的方式来导出文件:
#导入处理xlsx文件相关库
import pandas as pd
import copy
from openpyxl import Workbook
from openpyxl.styles import Font
class cash_out_DataAnalysis():
def __init__(self,data_with_fields):
self.data_with_fields=data_with_fields
def cash_out_condition(self):
"""数据内容获取逻辑"""
#导出文件逻辑
def cash_out_adjust(self):
self.cash_out_condition()
path = app_path()
file_path = path + r'\Data_analysis\output.xlsx'
#df = pd.DataFrame(data_with_fields)
#df.to_excel(file_path, index