RichText request
Created originally on Bitbucket by kaywebber
{{{ import openpyxl import openpyxl.workbook import openpyxl.writer.excel excel = openpyxl.workbook.Workbook() #Rich text feature #rt = new openpyxl.worksheet.RichText() #rt.create_text('This invoice is ') #payable = rt.create_text_run('payable within thirty days after the end of the month') #payable.font.bold = True #payable.font.italic = True #payable.font.color = openpyxl.style.Color.DARKGREEN #rt.create_text(', unless specified otherwise on the invoice.') #excel.get_active_sheet().cell('A18').value = rt
writer = openpyxl.writer.excel.ExcelWriter(excel) writer.save("openpyxl.xlsx") }}}