python으로 Excel(엑셀) 데이터 다루기

python으로 Excel(엑셀) 데이터 다루기

 

import xlrd

fname = "./hello.xlsx"
xl_workbook = xlrd.open_workbook(fname)

print(xl_workbook)

sheet_names = xl_workbook.sheet_names()
print('Sheet Names', sheet_names)

xl_sheet = xl_workbook.sheet_by_index(0)
print ('Sheet name: %s' % xl_sheet.name)

row = xl_sheet.row(0)  # 1st row
print(row)

from xlrd.sheet import ctype_text

print('(Column #) type:value')
for idx, cell_obj in enumerate(row):
    cell_type_str = ctype_text.get(cell_obj.ctype, 'unknown type')
    print('(%s) %s %s' % (idx, cell_type_str, cell_obj.value))​

xlrd라는 라이브러리를 사용하면 됩니다.

 

end.