poi解析officeドキュメント
4736 ワード
Apache POI Apache ,POI API Java Microsoft Office 。
:
HSSF - Microsoft Excel 。
XSSF - Microsoft Excel OOXML 。
HWPF - Microsoft Word 。
HSLF - Microsoft PowerPoint 。
HDGF - Microsoft Visio 。
Excel
1 Jakarta POI API Excel 。
1 :
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;
import java.io.FileOutputStream;
public class CreateXL {
public static String outputFile="D:\\test.xls";
public static void main(String argv[]){
try{
// Excel
HSSFWorkbook workbook = new HSSFWorkbook();
// Excel ,
// " " , :
// HSSFSheet sheet = workbook.createSheet(" ");
HSSFSheet sheet = workbook.createSheet();
// 0 ( )
HSSFRow row = sheet.createRow((short)0);
// 0 ( )
HSSFCell cell = row.createCell((short) 0);
//
cell.setCellType(HSSFCell.CELL_TYPE_STRING);
//
cell.setCellValue(" ");
//
FileOutputStream fOut = new FileOutputStream(outputFile);
// Excel
workbook.write(fOut);
fOut.flush();
// ,
fOut.close();
System.out.println(" ...");
}catch(Exception e) {
System.out.println(" xlCreate() : " + e );
}
}
}
Excel
2 Excel 。 D JTest test1.xls Excel 。
2 :
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;
import java.io.FileInputStream;
public class ReadXL {
public static String fileToBeRead="D:\\test1.xls";
public static void main(String argv[]){
try{
// Excel
HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(fileToBeRead));
// 。
// ( "Sheet1")
HSSFSheet sheet = workbook.getSheet("Sheet1");
// getSheetAt(int index) ,
// Excel , 0,
// :HSSFSheet sheet = workbook.getSheetAt(0);
//
HSSFRow row = sheet.getRow(0);
HSSFCell cell = row.getCell((short)0);
// ,cell.getStringCellValue()
System.out.println(" : " + cell.getStringCellValue());
}catch(Exception e) {
System.out.println(" xlRead() : " + e );
}
}
}
, , workbook 。 Java , , :
1、 , 、 :
HSSFFont font = workbook.createFont();
font.setColor(HSSFFont.COLOR_RED);
font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
2、
HSSFCellStyle cellStyle= workbook.createCellStyle();
cellStyle.setFont(font);
3、
HSSFCell cell = row.createCell((short) 0);
cell.setCellStyle(cellStyle);
cell.setCellType(HSSFCell.CELL_TYPE_STRING);
cell.setCellValue(" ");
WORD
import java.io.*;
import org.textmining.text.extraction.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);
}
}