Excel file operations in Python

 Below is the code which will demonstrate the Excel file operations in Python

import openpyxl


def getRowCount(path, sheetName):
    workbook = openpyxl.load_workbook(path)
    sheet = workbook[sheetName]
    return sheet.max_row


def getColCount(path, sheetName):
    workbook = openpyxl.load_workbook(path)
    sheet = workbook[sheetName]
    return sheet.max_column


def getCellData(path, sheetName, rowNum, colNum):
    workbook = openpyxl.load_workbook(path)
    sheet = workbook[sheetName]
    return sheet.cell(row=rowNum, column=colNum).value


def setCellData(path, sheetName, rowNum, colNum, data):
    workbook = openpyxl.load_workbook(path)
    sheet = workbook[sheetName]
    sheet.cell(row=rowNum, column=colNum).value = data
    workbook.save(path)


path = "..//excel//testdata.xlsx"
sheetName = "LoginTest"

rows = getRowCount(path, sheetName)
cols = getColCount(path, sheetName)

print(rows, "---", cols)

print(getCellData(path, sheetName, 2, 1))
setCellData(path, sheetName, 1, 4, "DOB")