title: concatenate data in excel using openpyxl in Python
body: <p>Here comes again,
  I have managed to collect specific data from resx file (xml) to generate an Excel file.
  Now, the task is to concatenate all the data to lowest row in this excel file.</p>
  
  <h1>First opening the input file to read(r) and write(w).</h1>
  
  <p>wb = load_workbook('Excel.xlsx')</p>
  
  <h1>access the worksheet named 'Sheet'</h1>
  
  <p>ws=get_sheet_by_name('Sheet')</p>
  
  <p>So now, I need to Concatenate the data from all the cells in one column to the last empty cell of that column. Then generate this new excel file.</p>
  
  <p>for example,
  Column Name: any column
  row1:        ABC 
  row2:        EFG
  row3:        HIJ</p>
  
  <p>last row after concatenation should look like,</p>
  
  <p>row4 : ABC
         EFG
         HIJ </p>
  
  <p>As a python beginner this seems to be a pretty hard stuff for me. Please help to improve.</p>
  
  <p>Thanks a lot.</p>