title: How to set formatting for entire row or column in xlsxwriter Python?
body: <pre><code>workbook = xlsxwriter.Workbook('demo1.xlsx')
  worksheet = workbook.add_worksheet()
  format = workbook.add_format({ 'bg_color': '#5081BB','font_color': '#FFFFFF','font_size': 12,'text_wrap':'true'})
  textWrap = workbook.add_format({'text_wrap':'true'})
  col = 0
  row = 0
  for i in data[&quot;tabledata&quot;]:
      for j in i:
          worksheet.write(row, col, j,textWrap)
          col = col+1
      row = row+1
      col = 0
  worksheet.set_row(0, 20, format)
  worksheet.set_row(1, 20, format)
  workbook.close()
  </code></pre>
  <p>this doesn't properly work, then what is the use of <code>set_row</code> and <code>set_column</code>?<br>
  How to apply the format for specific row/column? I also need to apply
  date format for date columns.</p>
  <pre><code>worksheet.set_column(7, none, Dateformat)
  </code></pre>