Hello, I've had 2 semesters of java and am still learning things.
I want to be able to extract text from a word document and write to an excel document.
I found Apache POI, that seems to be able to do this task, but I'm not sure what exactly what I should download or how to use it, after I download.
If anyone could provide a step-by-step process I should use to be able to use the Apache POI, that would be great.
I need to know:
- what to download
- how to install and verify
- and be able to use the program I make with this POI on any computer computer, like would I have to do any special install on that computer or is it something that is included within the jar I make in the end...
Im kinda a noob so any information on how to go about how to get this to work would be excellent.
My objective is to be able to read data from a templated Word Document and organize that data into an excel document. First thing I need is a method to read in word docs and write in excel spreadsheets.
ANY help to getting the Apache POI installed and start using it to read and write Microsoft Documents would be Fantastic!
Thank you in advance for any help!
Well I use JGrasp and downloaded the Binary Distribution and Source Distribution for POI 3.8. My main question would be how to set the CLASSPATH. It'll be a Stand-alone Java program. I need to know where to put the files I downloaded or set up the Classpath so I can import and use the methods.
I don't know jgrasp, but I would assume if it's an IDE, you should have a wizard to start a new project.
Otherwise, textpad or notepad++ should work if you configure the java compiler (javac) and runtime (java)
requirements and CLASSPATH. Basically it has to find the poi.jar at both compilation time and runtime.