Is there a function to unhide columns in excel through python

Question

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 openpyxl
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?

Answer 1

Excel file :

df.to_excel('demofile.xlsx',index=False)

import openpyxl

py = openpyxl.load_workbook('demofile.xlsx')
exlsheet = py.get_sheet_by_name('yoursheetName')

Checking Column

for col in exlsheet.columns:
  if not col[2].value:
    exlsheet.column_dimensions[col[2].column].hidden = True

Save your file

py.save('modifiedfile.xlsx')