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: automation
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
Python| Current Date and Time in different formats.
In this tutorial, We will learn how to convert the current day and timestamp in
Python | How to Count the frequency of a word in the text file?
In this tutorial, we will learn how to count the frequency of the word in
OpenpyXL || Bar chart
The complexity of data grows with increase in size of data. When the data volume
OpenpyXL || Insertion and deletion of rows and columns.
In this tutorial we will learn how to insert and delete rows and columns from
OpenpyXL || Reading data from Excel file.
In previous tutorial we learn about writing data into excel file using openpyxl now we
OpenpyXL || Writing to an Excel file.
Openpyxl is a python library, which allows us to do multiple operations read, write arithmetic