利用POI读写Excel

WriteExcel.java

package com;

import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.Date;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFDataFormat;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFHyperlink;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.util.CellRangeAddress;
import org.apache.poi.hssf.util.HSSFColor;

public class WriteExcel {
	public static void main(String[] args) {
		// 创建Excel的工作书册 Workbook,对应到一个excel文档
		HSSFWorkbook wb=new HSSFWorkbook();

		// 创建Excel的工作sheet,对应到一个excel文档的tab
		HSSFSheet sheet=wb.createSheet("sheet1");

		// 设置excel每列宽度
		//sheet.setColumnWidth(0, 1100);
		//sheet.setColumnWidth(1,3500);

		// 创建字体样式
		//HSSFFont font=wb.createFont();
		//font.setFontName("Verdana");
		//font.setBoldweight((short)100);
		//font.setFontHeight((short)300);
		//font.setColor(HSSFColor.BLUE.index);

		//创建单元格样式
		//HSSFCellStyle style=wb.createCellStyle();
		//style.setAlignment(HSSFCellStyle.ALIGN_CENTER);
		//style.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
		//style.setFillForegroundColor(HSSFColor.LIGHT_TURQUOISE.index);
		//style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);

		//设置边框
		//style.setBottomBorderColor(HSSFColor.RED.index);
		//style.setBorderBottom(HSSFCellStyle.BORDER_THIN);
	   // style.setBorderLeft(HSSFCellStyle.BORDER_THIN);
	    //style.setBorderRight(HSSFCellStyle.BORDER_THIN);
	    //style.setBorderTop(HSSFCellStyle.BORDER_THIN);

	    //style.setFont(font);// 设置字体

	    // 创建Excel的sheet的一行
	    HSSFRow row = sheet.createRow(0);
	   // row.setHeight((short) 500);// 设定行的高度

	    // 创建一个Excel的单元格
	    HSSFCell cell = row.createCell(0);

	    // 给Excel的单元格设置样式和赋值
	    //cell.setCellStyle(style);
	    cell.setCellValue("hello world");

	    // 合并单元格(startRow，endRow，startColumn，endColumn)
	    //sheet.addMergedRegion(new CellRangeAddress(0, 0, 0, 2));

	    // 设置单元格内容格式
	    //HSSFCellStyle style1 = wb.createCellStyle();
	   // style1.setDataFormat(HSSFDataFormat.getBuiltinFormat("h:mm:ss"));

	    //style1.setWrapText(true);// 自动换行

	    row = sheet.createRow(1);

	    // 设置单元格的样式格式

	    //cell = row.createCell(0);
	   // cell.setCellStyle(style1);
	   // cell.setCellValue(new Date());

	    // 创建超链接
	    //HSSFHyperlink link = new HSSFHyperlink(HSSFHyperlink.LINK_URL);
	    //link.setAddress("http://www.baidu.com");
	    cell = row.createCell(1);
	    cell.setCellValue("百度");
	    //cell.setHyperlink(link);// 设定单元格的链接

	    try {
			FileOutputStream os = new FileOutputStream("e:\\workbook.xls");
			wb.write(os);
			os.close();
		} catch (FileNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}

ReadExcel1.java

package com;

import java.io.FileInputStream;
import java.io.InputStream;

import org.apache.poi.hssf.extractor.ExcelExtractor;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

public class ReadExcel1 {
	public static void main(String[] args) {
		InputStream is = null;
	    HSSFWorkbook wb = null;
	    try {
			is=new FileInputStream("e:\\workbook.xls");
			wb=new HSSFWorkbook(is);
		} catch (Exception e) {
			e.printStackTrace();
		}
	    ExcelExtractor extractor = new ExcelExtractor(wb);
	    extractor.setIncludeSheetNames(false);
	    extractor.setFormulasNotResults(false);
	    extractor.setIncludeCellComments(true);

	    String text = extractor.getText();
	    System.out.println(text);
	}
}