title: How to copy and paste data from excel to another excel using python
body: <p>I would like to copy excel data from source excel file to destination excel file. However, I am not just simply copy whole data from source file.</p>
  
  <p>I need keep copying ONLY certain rows and columns like the first 5 rows by 4 columns (this data covered, row: 1st to 5th, column: A to D) from source file and paste on fixed coordination of destination excel file like row: 3rd to 7th, column: A to D. Next iteration I would like to copy the next 5 rows by 4 columns (this data covered, row: 6th to 10th, column: A to D) to same coordination (row: 3rd to 7th, column: A to D) and keep copying from source file until finish copy whole data from source file.</p>
  
  <p>Below is the attachments of source file and desired destination file.</p>
  
  <p><a href="https://i.stack.imgur.com/9ye6l.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9ye6l.png" alt="source excel file"></a>
  above figure shows data from source file</p>
  
  <p><a href="https://i.stack.imgur.com/wbTjJ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wbTjJ.png" alt="desired destination excel file"></a>
  above figure shows data from destination file</p>
  
  <p>Here is the code that I have tried, but it returns weird output:</p>
  
  <pre><code>        # source          
          filename ="C:/Users/aaa/Desktop/combine_all.xlsx"
          wb1 = xl.load_workbook(filename) 
          ws1 = wb1.worksheets[0]                         
          # destination
          filename1 ="C:/Users/aaa/Desktop/algorithm.xlsx"
          wb2 = xl.load_workbook(filename1) 
          ws2 = wb2.active                           
          mr = ws1.max_row 
          mc = ws1.max_column  
          try:                     
              m = [1, 6, 11, 16, 21, 26, 31, 36, 41, 46, 51, 56, 61, 66, 71, 76, 81, 86, 91, 96, 101, 106, 111, 116, 121, 126, 131, 136]
              n = [6, 11, 16, 21, 26, 31, 36, 41, 46, 51, 56, 61, 66, 71, 76, 81, 86, 91, 96, 101, 106, 111, 116, 121, 126, 131, 136, 141]
              for q in range (3, 8):
                  for xm, yn in zip(m, n):                             
                      for i in range (xm, yn): 
                          for j in range (1, 5): 
                              c = ws1.cell(row = i, column = j)                                    
                              ws2.cell(row = q, column = j).value = c.value  
  </code></pre>
  
  <p>Appreciate a lot if anyone could help me, thanks in advance!</p>