writer = pd.ExcelWriter('/home/leo/Desktop/项目测试/922904.xlsx', engine='openpyxl') new_data.to_excel(writer, index=False, sheet_name="Sheet1") # 设置表格样式 workbook = writer.book worksheet = writer.sheets['Sheet1'] # 边框线 border_set = Border(left=Side(border_style='thin', color='000000'), right=Side(border_style='thin', color='000000'), top=Side(border_style='thin', color='000000'), bottom=Side(border_style='thin', color='000000')) rows = worksheet.max_row columns = worksheet.max_column for row in range(1, rows+1): for column in range(1, columns+1): worksheet.cell(row=row, column=column).border=border_set writer.save()
如果需要其他样式参考openpyxl的样式设置即可。