python - How to insert and format values cell by cell in an XLSX file using openpyxl -

i trying write xlsx file using openpyxl module. using append() method insert values row row. want insert values cell cell instead. format cell (font, colour, alignment etc). please me.

you can set cell cell (if need) using openpyxl. here small example sets value, name (named_range) , style of cells in workbook:

from openpyxl.workbook import workbook wb = workbook() dest_filename = r'empty_book.xlsx' ws = wb.worksheets[0]      name = 'name'  col_idx in xrange(1, 101):     col = get_column_letter(col_idx)     row in xrange(1, 1001):         ws.cell('%s%s'%(col, row)).value = '%s%s' % (col, row)         ws.cell('%s%s'%(col, row)).style.fill.fill_type = 'solid'         ws.cell('%s%s'%(col, row)).style.fill.start_color.index = openpyxl.style.color.darkyellow         wb.create_named_range(name+str(i), ws, '%s%s'%(col, row))  wb.save(filename = dest_filename) 

look style class in openpyxl documentation learn more how set individual formattings.