title: Write data from one excel sheet to another
body: <p>I have some .csv files in my folder with names like <code>1filename.csv</code>, <code>2filename.csv</code>, <code>3filename.csv</code> then <code>1abc.csv</code>, <code>2abc.csv</code> and so on.</p>
  
  <p>I need to merge files with same post name and each file has same no. of columns with same heading.So final file should have only one row with titles for columns and appended with data.</p>
  
  <p>Example: 1. <code>1filename.csv</code>, <code>2filename.csv</code>, <code>3filename.csv</code> should be merged to  <code>filename.csv</code> (where the data is appended one after the other)</p>
  
  <p>2.<code>1abc.csv</code>, <code>2abc.csv</code> will be merged and to form abc.csv</p>
  
  <p>Can I achieve this in batch file or with the help of phpexcel? I want to do in batch file but i am not sure that it is possible.</p>
  
  <p>Thanks</p>
  
  <p>These are the files which needs to be merged I will have 1000s of files splitted with different domains :
  <img src="https://i.stack.imgur.com/qGqFx.png" alt="enter image description here"></p>
  
  <p>This is how csv files will look like, one file can have maximum of 800 rows and same number of columns with same heading:
  <img src="https://i.stack.imgur.com/QNgww.png" alt="enter image description here"></p>