POI读写excel

POI读写Excel文件

import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.util.Date;
import java.util.Iterator;
import org.apache.poi.hssf.extractor.ExcelExtractor;
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.HSSFColor;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.Font;
import org.apache.poi.ss.usermodel.IndexedColors;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.util.CellRangeAddress;
import org.junit.Test;

public class ExcelTest {

	@Test
	public void testWrite() throws Exception{
		  // 创建Excel的工作书册 Workbook,对应到一个excel文档
		HSSFWorkbook excel =new HSSFWorkbook();
		  // 创建Excel的工作sheet,对应到一个excel文档的tab
		HSSFSheet sheet =excel.createSheet("第一个sheet");
		// 设置excel每列宽度
		sheet.setColumnWidth(0, 300);
		sheet.setColumnWidth(1, 500);
		  // 创建字体样式
		HSSFFont font =excel.createFont();
		font.setColor(IndexedColors.BLUE.getIndex());
		font.setFontName("华文宋体");
		font.setFontHeight((short) 300);
		font.setBoldweight(Font.BOLDWEIGHT_BOLD);
		
		 // 创建单元格样式
		HSSFCellStyle  style=excel.createCellStyle();
		style.setAlignment(CellStyle.ALIGN_CENTER);
		style.setWrapText(true);
		style.setFillBackgroundColor(HSSFColor.LIGHT_BLUE.index);
		style.setVerticalAlignment(CellStyle.VERTICAL_CENTER);
		style.setFillPattern(CellStyle.SOLID_FOREGROU