By default, The Developer tab is not visible in the excel menu bar we have to enable it. We can easily add by selecting the developer check box from the Customize ribbon option. Please follow the below steps to enable the Developer tab in excel.
Tag: automate_excel_file
Openpyxl || Freezing excel row and column with python.
Freezing a pane(row/column) using excel application is easy. We can freeze a row/column using excel
Openpyxl || Merge/Unmerge excel cells and assign value to unmerged cells.
In this tutorial, we will learn how to merge/unmerge cells in an excel file and