In order to maintain colour formatting, I turned an Excel spreadsheet into a DataFrame using StyleFrame. A few columns are already buried by default when I return to an Excel spreadsheet after converting this DataFrame.
This is my code:
import pandas as pd
from StyleFrame import StyleFrame, Styler, utils
sf = StyleFrame.read_excel("aaaa\\aaaa\\cdddd .xlsx",sheet_name = 2, read_style=True, header = None)
ew = StyleFrame.ExcelWriter('aaaa\\abbbbbb2.xlsx')
sf.to_excel(excel_writer = ew, header = False, index = False).save()
How do I make sure these columns are not hidden when opening the spreadsheet in Excel?