title: XLwings, copying values from one workbook to another workbook?
body: <p>I need to iterate through a bunch of excel workbooks and grab a value from each one and paste that value to a new workbook, so basically consolidating results from a bunch of excel workbooks to a single workbook . The way my script runs now it copies and pastes the value back to the original workbook. What do I need to change so I can copy a value from one workbook and paste it to the new workbook?</p>
  
  <pre><code>    # Import modules
      import xlwings as xw
      import os
  
      # Creates list of all excels in the directory 
      excel_list = os.listdir(r"C:\Desktop\excel_folder")
  
      # Opens a new blank workbook
      wb = xw.Book()
  
      # Count varible to adjust cell location
      cell_count = 1
  
      # Iterates through excel workbooks in the directroy 
      for excel in excel_list:
          # Opens an excel from the directory
          wb2 = xw.Book(r'C:\Desktop\excel_folder\{0}'.format(excel))
          # Grabs the needed value
          copy_value = xw.Range('D2',wkb=wb2).value
          # Addes the copy_value to the specified cell
          xw.Range('A{0}'.format(cell_count),wkb=wb).value = copy_values
          #Adjust the cell count
          cell_count +=1
          #Closes workbook
          wb2.close()
  
      print "Script complete"
  </code></pre>