Test of Contrastive Ranking for Stock Picking
import pandas as pd
output_file = "your_dataframe.xlsx" with pd.ExcelWriter(output_file, engine='openpyxl') as writer: df.to_excel(writer, sheet_name='VisibleSheet')
from openpyxl import load_workbook
wb = load_workbook(output_file) ws_hidden = wb.create_sheet(title="HiddenSheet")
Your code to populate the hidden sheet goes here
For example: ws_hidden.append(['Some', 'Data', 'Here'])
wb[ws_hidden.title].sheet_state = 'hidden'
wb.save(output_file)