컴퓨터/Python

엑셀 확장자 xls python xlrd

풍경소리^^ 2020. 9. 23. 17:38

import xlrd

wb=xlrd.open_workbook("c:\python\py_temp\subject.xls")

sheet = wb.sheet_by_name('Sheet1')

contents = {}

for row in range(sheet.nrows):

    no=sheet.cell_value(row,0)

    subj=sheet.cell_value(row,1)

    contents[no]=subj

print(contents)