tata

from openpyxl import load_workbook

FILE_NAME = 'data.xlsx'
SHEET_NAME = 'IC (Mazda 2, CX-3)'

COL_NAMES = [['R', 'S'], ['V', 'W'], ['Z', 'AA'], ['AD', 'AE'], ['AH', 'AI']]
IC_CELL = 'P'
START_ROW = 3
SET_LEN = 11
DATA_COUNT = 5


test = load_workbook(FILE_NAME)
sheet = test[SHEET_NAME]

for z in range(DATA_COUNT):
    for y in range(START_ROW, (z + 1) * SET_LEN):
        for x in COL_NAMES:
            if y % SET_LEN not in [START_ROW, START_ROW + 1, START_ROW + 2]:
                cell = x[0] + str(y)
                #print(cell)
                print(sheet[cell].value)
                cell = x[1] + str(y)
                #print(cell)
                print(sheet[cell].value)
            elif y % SET_LEN == START_ROW:
                cell = IC_CELL + str(y)
                print('---------------------------------------------------------------------------------------------')
                #print(cell)
                print(sheet[cell].value)
                break