title: How to put every five rows into one sheet with xlwt and xlrd?
body: <p><strong>Now I can only save all 14 lines data to Sheet1.
  I want to put every 5 rows in a sheet,for example:</strong>
  <a href="https://i.stack.imgur.com/8mymq.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8mymq.png" alt="enter image description here"></a></p>
  
  <p><strong>Now my code is like this:</strong></p>
  
  <pre><code>import xlwt
  import xlrd
  from xlutils.copy import copy
  myyear = '2018'
  myweek = '10'
  mycd='1001'
  fileName = myyear + myweek + '.xls'
  workbook = xlwt.Workbook(encoding='UTF-8')
  worksheet = workbook.add_sheet('sheet1')
  worksheet.write(0, 0, label='year')
  worksheet.write(0, 1, label='week')
  worksheet.write(0, 2, label='CD')
  worksheet.write(0, 3, label='keyword')
  worksheet.write(0, 4, label='importance')
  savePath = r'D:/' + fileName
  workbook.save(savePath)
  rexcel = xlrd.open_workbook(savePath)
  rows = rexcel.sheets()[0].nrows
  excel = copy(rexcel)
  worksheet = excel.get_sheet(0)
  current_row = rows
  for cmp_noun, value in [[1,1],[2,2],[3,3],[4,4],[5,5],[6,6],[7,7],[8,8],[9,9],[10,10],[11,11],[12,12],[13,13],[14,14]]:
      if current_row&lt;=5:
          worksheet.write(current_row, 0, label=myyear)
          worksheet.write(current_row, 1, label=myweek)
          worksheet.write(current_row, 2, label=mycd)
          worksheet.write(current_row, 3, label=cmp_noun)
          worksheet.write(current_row, 4, label=value)
          current_row += 1
  excel.save(savePath)
  </code></pre>
  
  <p><strong>How to modify the code to become the effect I want?</strong></p>