title: How do I read multiple text files and process it one by one and write rows into a excel file
body: <p>I try to do some data processing.<br>
  My question as following:</p>
  
  <p>Folder (C://) contains multiple text files.</p>
  
  <p>To read 1st text file -> process(get some data inside) to list1<br>
  To read 2nd text file -> process(get some data inside) to list2<br>
  .<br>
  .<br>
  To read Nth text file -> process to listN  </p>
  
  <p>Write ([list1],[list2],....,[listN]) into one excel.</p>