How to add timestamp to excel file in Python
In this article, we will discuss how to add a timestamp to an excel file using Python.
- datetime: This module helps us to work with dates and times in Python.
pip install datetime
- openpyxl: It is a Python library used for reading and writing Excel files.
pip install openpyxl
- time: This module provides various time-related functions.
Step 1: Create the workbook object and select the active sheet:
Attention geek! Strengthen your foundations with the Python Programming Foundation Course and learn the basics.
To begin with, your interview preparations Enhance your Data Structures concepts with the Python DS Course. And to begin with your Machine Learning Journey, join the Machine Learning - Basic Level Course
wb = Workbook() ws = wb.active
Step 2 (Optional): Write the heading in cell A1.
# Here column=1 represents column A and row=1 represents first row. ws.cell(row=1, column=1).value = "Current Date and Time"
Step 3: Use the following command to get the current DateTime from the system.
time = datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S')
The strftime() function is used to convert date and time objects to their string representation. It takes one or more inputs of formatted code and returns the string representation.
Step 4: Write the DateTime in cell A2.
ws.cell(row=2, column=1).value = time
Step 5: Initiate a sleep of 2 seconds using time.sleep(2)
Step 6: Similarly, get the current datetime again and write it in cell A3. Here you will notice a difference of 2 seconds from the previous DateTime since there was a sleep of 2 seconds in between.
Step 7: Finally, Save the excel workbook with a file name and close the workbook
Below is the full implementation: