title: Easy way to fill in an Excel file with Python
body: <p>Let us say I have an excel file called <strong>test.xlsx</strong>, which is a workbook with three sheets, where sheet1 is called <strong>hello1</strong>, sheet2 two is called <strong>hello2</strong>, and sheet3 is called <strong>bye</strong>.</p>
  
  <p>Now, I'd like to read the file, and then re-write the same file but ONLY change the values in (column B, row 11) of the sheet named hello2, and (column D, row 14) of sheet named bye.  The values I want to give there are 'test' (a string), and 135, respectively (i.e., write test in sheet hello2 and 14 in sheet bye).</p>
  
  <p>You may be wondering why I am asking such odd question but basically I am looking to gain some of the following skills/knowledge: </p>
  
  <ul>
  <li>To be able to read a workbook and then a specific sheet of an excel file using python</li>
  <li>To be able to write to an excel sheet at a given position using python</li>
  </ul>
  
  <p>Note: for reference, I can use any version of python in redhat server, the excel file was generated with my mac, saved as xlsx format using excel for mac 2011. version 14.0.1, and then I copied the excel file to redhat server.</p>