How to manipulate Word, Excel, PDF files in Java

reading data for Office and PDF documents is a common feature in a normal application, especially in many Web applications. So today we'll take a quick look at Java's reading of Word, Excel, and PDF files. This blog only explains simple applications. If you want to get a deeper understanding of the principle. Readers should study some of the relevant source code.

First, let's get to know the jar package that reads the relevant document:

1. Reference POI package Read Word document content

Poi.jar

Http://apache.freelamp.com/poi/release/bin/poi-bin-3.6-20091214.zip http://apache.etoak.com/poi/release/bin/ Poi-bin-3.6-20091214.zip Http://labs.renren.com/apache-mirror/poi/release/bin/poi-bin-3.6-20091214.zip

2. Refer to the JXL package to read the contents of an Excel document

Jxl.jar

Http://nchc.dl.sourceforge.net/project/jexcelapi/CSharpJExcel/CSharpJExcel.zip

3. Reference PDFBox read the contents of a PDF document

Pdfbox.jar

Http://labs.renren.com/apache-mirror/pdfbox/1.1.0/pdfbox-1.1.0.jar http://apache.etoak.com/pdfbox/1.1.0/ Pdfbox-1.1.0.jar Http://apache.freelamp.com/pdfbox/1.1.0/pdfbox-1.1.0.jar

Fontbox.jar

Http://apache.etoak.com/pdfbox/1.1.0/fontbox-1.1.0.jar http://labs.renren.com/apache-mirror/pdfbox/1.1.0/ Fontbox-1.1.0.jar Http://apache.freelamp.com/pdfbox/1.1.0/fontbox-1.1.0.jar

Jempbox.jar

Http://labs.renren.com/apache-mirror/pdfbox/1.1.0/jempbox-1.1.0.jar http://apache.etoak.com/pdfbox/1.1.0/ Jempbox-1.1.0.jar Http://apache.freelamp.com/pdfbox/1.1.0/jempbox-1.1.0.jar

Let's take a quick look at the application examples of these jar packages that read the document:

1. Reference POI package Read Word document content

2. Import Java.io.File;
4. Import Java.io.FileInputStream;
6. Import org.apache.poi.hwpf.HWPFDocument;
8. Import Org.apache.poi.hwpf.usermodel.Range;
12. /**
14. *
16. * @author Cao Shenhuan
18. */
20. Public class docfile{
26. @Override
28. Public String getcontent (File f) throws Exception {
30. FileInputStream FIS = new FileInputStream (f);
32. Hwpfdocument doc = new hwpfdocument (FIS);
34. Range rang = Doc.getrange ();
36. String text = Rang.text ();
38. Fis.close ();
40. return text;
42. }

Import Java.io.File;   Import Java.io.FileInputStream;   Import org.apache.poi.hwpf.HWPFDocument;   Import Org.apache.poi.hwpf.usermodel.Range;   /** * * @author Cao Sheng Huan * * public class docfile{       @Override public     String getcontent (file f) throws Exception {           file InputStream fis = new FileInputStream (f);           Hwpfdocument doc = new hwpfdocument (FIS);           Range rang = Doc.getrange ();           String text = Rang.text ();           Fis.close ();           return text;       }   

2. Refer to the JXL package to read the contents of an Excel document

2. Import Java.io.File;
4. Import Java.io.FileInputStream;
6. Import JXL. Cell;
8. Import JXL. Sheet;
10. Import JXL. Workbook;
14. /**
16. *
18. * @author Cao Shenhuan
20. */
22. Public class xlsfile{
26. @Override
28. Public String getcontent (File f) throws Exception {
30. //Build Workbook object, read-only Workbook object
32. //Create workbook directly from a local file
34. //Create workbook from input stream
38. FileInputStream FIS = new FileInputStream (f);
40. StringBuilder sb = new StringBuilder ();
42. Jxl. Workbook RWB = Workbook.getworkbook (FIS);
44. Once the workbook is created, we can access it through
46. An array collection of Excel sheet (terms: worksheets),
48. You can also call the Getsheet method to get the specified payroll table
50. sheet[] Sheet = Rwb.getsheets ();
52. For (int i = 0; i < sheet.length; i++) {
54. Sheet rs = Rwb.getsheet (i);
56. For (int j = 0; j < Rs.getrows (); j + +) {
58. Cell[] cells = Rs.getrow (j);
60. For (int k=0;k<cells.length;k++)
62. Sb.append (Cells[k].getcontents ());
64. }
66. }
68. Fis.close ();
70. return sb.tostring ();
72. }
76. }

Import Java.io.File;   Import Java.io.FileInputStream; Import JXL.   Cell; Import JXL.   Sheet; Import JXL.   Workbook;        /** * * @author Cao Sheng Huan * * public class xlsfile{@Override public String getcontent (File f) throws Exception { Build Workbook object, read-only Workbook object//Create workbook directly from local file//create workbook from input stream FileInputStream FIS = new FILEINPUTST           Ream (f);           StringBuilder sb = new StringBuilder (); Jxl.   Workbook RWB = Workbook.getworkbook (FIS);           Once workbook is created, we can access the array of//excel Sheet (term: Worksheet),//You can also call the Getsheet method to get the specified payroll sheet[] Sheet = Rwb.getsheets ();               for (int i = 0; i < sheet.length; i++) {Sheet rs = rwb.getsheet (i);                  for (int j = 0; J < Rs.getrows (); j + +) {cell[] cells = Rs.getrow (j);               for (int k=0;k<cells.length;k++) sb.append (Cells[k].getcontents ());           }} fis.close ();       return sb.tostring (); }   }

From the above code we know: once we get sheet, we can access the Excel cell (the term: cell). Refer to the following code snippet://Get the first row, the value of the first column, Cell c00 = Rs.getcell (0, 0); String strc00 = c00.getcontents (); Gets the value of the first row, the second column, Cell C10 = Rs.getcell (1, 0); String STRC10 = c10.getcontents (); When you have finished working with Excel spreadsheet data, be sure to use the close () method to close the previously created object to free up memory space used in reading the data table, which is especially important when reading large amounts of data.

3. Reference PDFBox read the contents of a PDF document

2. Import Java.io.File;
4. Import Java.io.FileInputStream;
6. Import Org.pdfbox.pdfparser.PDFParser;
8. Import org.pdfbox.pdmodel.PDDocument;
10. Import Org.pdfbox.util.PDFTextStripper;
14. /**
16. *
18. * @author Cao Shenhuan
20. */
22. <pre class="java" name="code" >Public class pdffile{
26. Public String getcontent (File f) throws Exception {
28. FileInputStream FIS = new FileInputStream (f);
30. Pdfparser p = new Pdfparser (FIS);
32. P.parse ();
34. PDDocument PDD = P.getpddocument ();
36. Pdftextstripper ts = new Pdftextstripper ();
38. String C = Ts.gettext (PDD);
40. Pdd.close ();
42. Fis.close ();
44. return C;
46. }
48. }</pre><br>

=========== for share only =========

How to manipulate Word, Excel, PDF files in Java