# coding=utf8

from openpyxl import load_workbook
import datetime

wb = load_workbook('data/topic.xlsx')
print(wb.worksheets)
ws = wb['topics']
# print(ws['B1'].value)
test_data = []
for x in range(2, len(tuple(ws.rows))+1):
    testcase_data = []
    for y in range(2, 7):
        testcase_data.append(ws.cell(row=x,column=y).value)
        print(ws.cell(row=x, column=y).value)
    test_data.append(testcase_data)
print(test_data)