java hssf 写 excle

在 poi-2.5.1.jar 下

package com.club.community.util;

import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.UnsupportedEncodingException;
import java.util.ArrayList;
import java.util.List;
import org.apache.log4j.Logger;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import com.club.exception.BusinessAccessException;


public class CreateExcelUtil {
	private static final Logger log = Logger.getLogger(CreateExcelUtil.class);
	
	private static final String SEPARATOR = File.separator;
	
	public static void crateExcel(String path, String fileName, String sheetName, List<String> titleList, List<String[]> contentList ) {//, List<String> titleList, List<String>
		log.info("生成excel开始,路径: " + path + SEPARATOR + fileName);
		
		HSSFWorkbook workbook = new HSSFWorkbook(); //创建新的Excel工作薄 
		HSSFSheet sheet;
		try {
			sheet = workbook.createSheet(new String(sheetName.getBytes(),"iso8859-1") );//在Excel工作薄中建工作表
			HSSFRow row = sheet.createRow((short) 0); //在索引0的位置建行（最顶端的行） 
			HSSFCell cell;
			String title = "";
			for (int i = 0; i < titleList.size(); i++) {
				title = titleList.get(i);
				cell = row.createCell((short) i);//在索引0的位置建单元格
				cell.setEncoding(HSSFCell.ENCODING_UTF_16); //定义单元格为字符串类型
				cell.setCellValue(title);
			}
			
			String[] contents = new String[titleList.size()];
			for (int i = 0; i < contentList.size(); i++) {
				row = sheet.createRow((short) i + 1); //在索引1的位置创建行（最顶端的行） 
				contents = contentList.get(i);
				for (int j = 0; j < contents.length; j++) {
					cell = row.createCell((short) j); //在索引0的位置创建单元格（左上端） 
					cell.setEncoding(HSSFCell.ENCODING_UTF_16); //定义单元格为字符串类型  
					cell.setCellValue(contents[j]); //在单元格输入一些内容 
				}
			}
		} catch (UnsupportedEncodingException e) {
			log.error(e);
			throw new BusinessAccessException("生成excel失败");
		}
		String fullPathName = path + SEPARATOR + fileName;
		File f = new File(fullPathName);
		if(!f.exists()) {
			f.getParentFile().mkdirs();
		}
		FileOutputStream fOut;//新建输出文件流 
		try {
			fOut = new FileOutputStream(fullPathName);
			workbook.write(fOut); //把相应的Excel工作薄存盘 
			fOut.flush();
			fOut.close(); //操作结束，关闭文件 
			log.info("生成excel结束,路径: " + path + SEPARATOR + fileName);
			System.out.println("excel文件已经生成，存放在" + fullPathName);
		} catch (FileNotFoundException e) {
			log.error(e);
			log.info("生成excel结束,路径: " + path + SEPARATOR + fileName);
			throw new BusinessAccessException("生成excel失败");
		} catch (IOException e) {
			log.error(e);
			log.info("生成excel结束,路径: " + path + SEPARATOR + fileName);
			throw new BusinessAccessException("生成excel失败");
		}
	}
	
	public static void main(String[] args) {
		List<String> titleList = new ArrayList<String>();
		titleList.add("作者");
		titleList.add("编辑");
		
		List<String[]> contentList = new ArrayList<String[]>();
		String[] a1 = {"张三", "李四"};
		String[] a2 = {"王五", "徐六"};
		String[] a3 = {"2222", "3333"};
		String[] a4 = {"4444", "5555"};
		contentList.add(a1);
		contentList.add(a2);
		contentList.add(a3);
		contentList.add(a4);
		
		crateExcel("c:\\abcdefg", "aa.xls", "bb", titleList, contentList);
	}
}

• poi-2.5.1.jar (783.4 KB)
• 下载次数: 0