Skip to content

Instantly share code, notes, and snippets.

@liudong
Created April 10, 2013 10:57
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save liudong/5353662 to your computer and use it in GitHub Desktop.
Save liudong/5353662 to your computer and use it in GitHub Desktop.
Python: Save something to a Excel spreadsheet
from openpyxl.workbook import Workbook
from openpyxl.writer.excel import ExcelWriter
from openpyxl.cell import get_column_letter
class XlsLogger(object):
"""
Save something to a Excel spreadsheet
"""
def __init__(self):
self.xls_log_workbook = Workbook()
self.xls_log_worksheet = self.xls_log_workbook.worksheets[0]
self.xls_log_worksheet.title = 'xls'
self.xls_log_worksheet.cell('%s%s' % (get_column_letter(1), 1)).value = "Title"
self.xls_log_worksheet.cell('%s%s' % (get_column_letter(2), 1)).value = "Description"
self.cur_row = 2
def log(self, title, description):
self.xls_log_worksheet.cell('%s%s' % (get_column_letter(1), self.cur_row)).value = title
self.xls_log_worksheet.cell('%s%s' % (get_column_letter(2), self.cur_row)).value = description
self.cur_row += 1
def save(self, xls_file):
ew = ExcelWriter(workbook=self.xls_log_workbook)
ew.save(filename=xls_file)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment