hi friend,

To read a file in Java you may use java.io package. To read more in detail how to read file in Java you may go through the link, may this will be helpful for you.

http://www.roseindia.net/java/beginners/java-read-file-line-by-line.shtml

To know how to write in excel file you may go through the tutorial page http://www.roseindia.net/tutorial/java/poi/insertIntoExcelFileData.html.

Thanks.