기본 콘텐츠로 건너뛰기

글

라벨이 python excel 2007 xlsx인 게시물 표시

python xlsx으로 저장하기

openpyxl를 사용하면 간단하게 사용 할 수 있음. 다운 받는곳 http://ericgazoni.wordpress.com/2011/10/31/openpyxl-1-6-6/ https://bitbucket.org/ericgazoni/openpyxl/src sample code #!/usr/bin/env python from openpyxl.workbook import Workbook from openpyxl.writer.excel import ExcelWriter from openpyxl.cell import get_column_letter wb = Workbook() dest_filename = r'empty_book.xlsx' ws = wb.worksheets[0] ws.title = "range names" for col_idx in xrange(1, 40):     col = get_column_letter(col_idx)     for row in xrange(1, 600):         ws.cell('%s%s'%(col, row)).value = '%s%s' % (col, row) ws = wb.create_sheet() ws.title = 'Pi' ws.cell('F5').value = 3.14 print dir(wb) wb.save(filename = dest_filename)