Answers for "Python getting content from xl range"

Python getting content from xl range

from openpyxl import load_workbook

wb = load_workbook(r"C:\Users\l470\Downloads\Telegram Desktop\translated\1446186995.xlsx")
ws = wb.active

need_trans = ws['C14':'C174']
for cell_tuple in need_trans:
    for cell in cell_tuple:
        print(cell.value)