Shulou(Shulou.com)06/03 Report--

Brief introduction:

Apache POI is an open source library of the Apache Software Foundation. POI provides API to Java programs to read and write files in Microsoft Office format.

The main read and write Microsoft Office function points provided in POI are as follows:

HSSF-provides the ability to read and write files in Microsoft Excel format.

XSSF-provides the ability to read and write files in Microsoft Excel OOXML format.

HWPF-provides the ability to read and write files in Microsoft Word format.

HSLF-provides the ability to read and write files in Microsoft PowerPoint format.

HDGF-provides the ability to read and write files in Microsoft Visio format.

Example:

Create an Excel document

Example 1 demonstrates how to create an Excel document using Jakarta POI API. Example 1 program is as follows: 12345678910111213141516171819202122232425262728293031323334353637import org.apache.poi.hssf.usermodel.HSSFWorkbook;import org.apache.poi.hssf.usermodel.HSSFSheet;import org.apache.poi.hssf.usermodel.HSSFRow;import org.apache.poi.hssf.usermodel.HSSFCell;import java.io.FileOutputStream;public class CreateXL {/ * * Excel file location to be stored, assuming that under disk D * / public static String outputFile = "D:\\ test.xls" Public static void main (String argv []) {try {/ / create a new Excel workbook HSSFWorkbook workbook = new HSSFWorkbook (); / / create a worksheet in the Excel workbook with the default value / / if you want to create a new worksheet called "benefit indicator", its statement is: / / HSSFSheet sheet = workbook.createSheet ("benefit indicator"); HSSFSheet sheet = workbook.createSheet () / / create a row at index 0 (topmost row) HSSFRow row = sheet.createRow ((short) 0); / / create a cell at index 0 (top left) HSSFCell cell = row.createCell ((short) 0); / / define the cell as a string type cell.setCellType (HSSFCell.CELL_TYPE_STRING); / / become obsolete / / enter some content cell.setCellValue ("added value") in the cell / / create an output file stream FileOutputStream fOut = new FileOutputStream (outputFile); / / save the corresponding Excel workbook to workbook.write (fOut); fOut.flush (); / / close the file fOut.close () at the end of the operation; System.out.println ("file generation...");} catch (Exception e) {System.out.println ("xlCreate ():" + e) Reading data in an Excel document example 2 demonstrates how to read data in an Excel document. Suppose there is an Excel file named test1.xls in the JTest directory of the D disk. Example 2 the program is as follows: the location of 12345678910111213141516171819202122232425262728import org.apache.poi.hssf.usermodel.HSSFWorkbook;import org.apache.poi.hssf.usermodel.HSSFSheet;import org.apache.poi.hssf.usermodel.HSSFRow;import org.apache.poi.hssf.usermodel.HSSFCell;import java.io.FileInputStream;public class ReadXL {/ * * Excel files. Notice the backslash * / public static String fileToBeRead = "D:\\ test1.xls"; public static void main (String argv []) {try {/ / create a reference to the Excel workbook file HSSFWorkbook workbook = new HSSFWorkbook (new FileInputStream (fileToBeRead)); / / create a reference to the worksheet. / / this example references by name (let's assume that the table has the default name "Sheet1") HSSFSheet sheet = workbook.getSheet ("Sheet1"); / / you can also use getSheetAt (int index) to reference by index, / / in the Excel document, the default index of the first worksheet is 0, / / its statement is: HSSFSheet sheet = workbook.getSheetAt (0); / / read the upper-left unit HSSFRow row = index (0) HSSFCell cell = row.getCell ((short) 0); / / output unit content, cell.getStringCellValue () is to take the value of the unit System.out.println ("upper left unit is:" + cell.getStringCellValue ());} catch (Exception e) {System.out.println ("xlRead ():" + e) } format cells here, we will only introduce a few statements related to formatting, we assume that workbook is a reference to a workbook. In Java, the first step is to create and format fonts and cells, and then apply these formats: 1. Create fonts and set them in red and bold: 123HSSFFont font = workbook.createFont (); font.setColor (HSSFFont.COLOR_RED); font.setBoldweight (HSSFFont.BOLDWEIGHT_BOLD); 2. Create the format 12HSSFCellStyle cellStyle= workbook.createCellStyle (); cellStyle.setFont (font); 3. Apply the format 1234HSSFCell cell = row.createCell ((short) 0); cell.setCellStyle (cellStyle) Cell.setCellType (HSSFCell.CELL_TYPE_STRING); cell.setCellValue ("title"); processing WORD document 12345678910111213141516import java.io. *; import org.apache.poi.hwpf.extractor.WordExtractor;import org.apache.poi.hssf.usermodel.HSSFWorkbook;import org.apache.poi.hssf.usermodel.HSSFSheet;import org.apache.poi.hssf.usermodel.HSSFRow;import org.apache.poi.hssf.usermodel.HSSFCell;public class TestPoi {public TestPoi () {} public static void main (String args []) throws Exception {FileInputStream in = new FileInputStream ("D:\\ a.doc"); WordExtractor extractor = new WordExtractor (); String str = extractor.extractText (in) / / System.out.println ("the result length is" + str.length ()); System.out.println (str);}}

What is Apache POI above? For more details, please pay attention to other related articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.