컴퓨터/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)