title: Copying text from file to specified Excel column
body: <p>I've got a text file, say, "<code>A.txt</code>" and an Excel file, say "<code>B.xlsx</code>". My goal is to copy all the text from <code>A.txt</code> to a specified column in <code>B.xlsx</code> using a python script. For example, let's say <code>A.txt</code> looks like:</p>
  
  <pre><code>Word1 5
  Word2 Word3
  6 Word4
  </code></pre>
  
  <p>I would then want to copy this into, say, column J in worksheet "Words", such that the contents of cell J1 are "<code>Word1 5</code>", the contents of J2 are "<code>Word2 Word3</code>", and so on...   </p>
  
  <p>So, to reformulate the question, how can I copy text from a specified text file and paste it into a specified Excel column, such that the content of each cell is equivalent to the content of each line (one-to-one relationship)?</p>
  
  <p>Many thanks in advance for any help!</p>