title: Excel data mapping using python
body: <p>I would like to open a master excel workbook and fill in a table in the master workbook with the help of data contained in other workbooks which are lying in some other directories.</p>
  
  <p>The mapping of data is based on the following logic: </p>
  
  <ol>
  <li><p>Program should first open a master workbook(say master.xls)</p></li>
  <li><p>Program then should find out the value corresponding to cell A1 in the master workbook, say, the value of cell A1 is 'AB_CD_EF'.</p></li>
  <li><p>Next step is to find out the workbook names lying in all 'sub-directories' and check if the filename of any of the workbook contained in all of those directories matches with the value in cell A1 of master spreadhseet.</p></li>
  <li><p>If any of the workbook name matches with cell A1, program should open that workbook and pull out the data contained in a particular cell of that workbook , say cell D5 and copy it into cell B1 of master spreadsheet.</p></li>
  <li><p>The prgram then should iterate through all the values contained in column A of master spreadhseet and fill in the complete table using the data contained in other workbooks (same as steps 2 to 5 above).</p></li>
  </ol>
  
  <p>Hope my question is clear. Any help would be appreciated.</p>
  
  <p>Thanks in advance.</p>