title: Writing into existing excel file
body: <p>I have a .xlsx file in which multiple worksheets are there (with some content). I want to write some data into specific sheets say sheet1 and sheet5. Right now I am doing it using xlrd, xlwt, and xlutils copy() function. But is there any way to do it by opening the file in append mode and adding the data and save it (Like as we do it for the text/CSV files)?</p>
  <p>Here is my code:</p>
  <pre><code>rb = open_workbook(&quot;C:\text.xlsx&quot;,formatting_info='True')
  wb = copy(rb)
  Sheet1 = wb.get_sheet(8)
  Sheet2 = wb.get_sheet(7)
  Sheet1.write(0,8,'Obtained_Value')
  Sheet2.write(0,8,'Obtained_Value')
  value1 = [1,2,3,4]  
  value2 = [5,6,7,8]
  for i in range(len(value1)):
   Sheet1.write(i+1,8,value1[i])
  for j in range(len(value2)):
   Sheet2.write(j+1,8,value2[j])
  wb.save(&quot;C:\text.xlsx&quot;)
  </code></pre>