Excel Reader #spreadsheet #python

excel_reader

import os

import xlrd

ROOT_PATH = r"C:\Users\t-midu\PycharmProjects\Scenario"
RESOURCE_PATH = os.path.join(ROOT_PATH, "resource")
file_path = os.path.join(RESOURCE_PATH, "sentence_class.xls")

data = xlrd.open_workbook(file_path)

table = data.sheet_by_name('label')

nrows = table.nrows

for line in range(15, nrows):
    print(table.row_values(line))