Skip to content

Instantly share code, notes, and snippets.

@etenesaca
Last active March 23, 2016 16:58
Show Gist options
  • Select an option

  • Save etenesaca/01a21193670118888450 to your computer and use it in GitHub Desktop.

Select an option

Save etenesaca/01a21193670118888450 to your computer and use it in GitHub Desktop.
Colores availables in xlwt resports Excel.

Colors in Xlwt

Colores disponibles

USE

#Borders
borders = xlwt.Borders()
borders.left = xlwt.Borders.THIN
borders.top = xlwt.Borders.THIN
borders.bottom = xlwt.Borders.THIN
borders.right = xlwt.Borders.THIN

# Alignment
alignment = xlwt.Alignment()
alignment.wrap = 1
alignment.horz = xlwt.Alignment().HORZ_CENTER
alignment.vert = xlwt.Alignment().VERT_CENTER


style = xlwt.easyxf(_xs['bold'] + "pattern: pattern solid, fore_color 27;")
style.borders = borders
style.alignment = alignment

Script for generate Colors

from xlwt import Workbook
import xlwt
book = Workbook()
sheet1 = book.add_sheet('Sheet 1')
book.add_sheet('Sheet 2')
st = xlwt.easyxf('pattern: pattern solid;')
for i in range(0, 100):
    st = xlwt.easyxf('pattern: pattern solid;')
    st.pattern.pattern_fore_colour = i
    sheet1.write(i % 24, i / 24, '#' + str(i),st)
book.save('colors_xlwt.xls')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment