파이썬기초85 : 엑셀파일 읽기와 쓰기

# coding:utf-8

#설치를 먼저 진행

# pip install xlrd

# pip install xlwt

import xlrd

workbook = xlrd.open_workbook('c:\\work\\example.xls')

worksheet = workbook.sheet_by_index(0)

nrows = worksheet.nrows

row_val = []

for row_num in range(nrows):

    row_val.append(worksheet.row_values(row_num))

for item in row_val:

    print(item)

#------------------------------------------------------

import xlwt

workbook = xlwt.Workbook(encoding="utf-8")

workbook.default_style.font.height = 20*11

worksheet = workbook.add_sheet(u'시트0')

font_style=xlwt.easyxf('font:height 280;')

worksheet.row(0).set_style(font_style)

worksheet.write_merge(0,1,0,0,u"엑셀예제")

worksheet.write_merge(0,0,1,2,u"엑셀예제")

worksheet.write_merge(0,0,3,4,u"엑셀예제")

worksheet.write(1,1,u"열기")

worksheet.write(1,2,u"읽기")

worksheet.write(1,3,u"쓰기")

worksheet.write(1,4,u"저장하기")

workbook.save("c:\\work\\example3.xls")