Reading text and writing to Excel in Java

Question

I have some code that puts new text on first line of a text document. I need some code to read that first line from the text document, and then should write this text to the first cell, first column of an Excel document. Then my code would put new text on the first line of the text document. Need some code to read new text from the text document and this time put this text in second row, first column and the cycle repeats.

Can anyone give me some sample code to do this?

Answer 1

http://www.rgagnon.com/javadetails/java-0516.html http://www.javaworld.com/javaworld/javaqa/2001-06/04-qa-0629-excel.html

Please go through the above URL's

Answer 2

Check out the Apache POI-HSSF library for reading and writing Excel files with Java. There are some quick guides to get you started.

Answer 3

You can try Jexcelapi,it is more efficient than poi.