Java生成excel,向excel追加数据(通用代码)

所需jar包下载地址: poi.jar→ http://download.youkuaiyun.com/download/cjava_math/9950387
jxl.jar→
package cn.sos.until;

import java.io.FileInputStream;

import java.io.FileOutputStream;

import java.io.IOException;

import java.io.OutputStream;

import java.util.List;

import java.util.Map;

import jxl.Workbook;

import jxl.write.Label;

import jxl.write.WritableSheet;

import jxl.write.WritableWorkbook;

import jxl.write.WriteException;

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.poifs.filesystem.POIFSFileSystem;

/**

• 数据写入excel工具类

• @author lannan

*@map key:列头 value:数据

*/

public class ExcelFile {

//第一次写入



public static void createExcel(Map<String, Object>map,OutputStream os) throws WriteException,IOException{

	

	int n = 0;

	int m = 0;

    //创建工作薄

    WritableWorkbook workbook = Workbook.createWorkbook(os);

    

    //创建新的一页

    WritableSheet sheet = workbook.createSheet("First Sheet",0);

    

    

    //创建要显示的内容,创建一个单元格，第一个参数为列坐标，第二个参数为行坐标，第三个参数为内容

    

    for (String key : map.keySet()) {

    	Label dk = new Label(n,0,key);

    	sheet.addCell(dk);

    	n++;

    	

	}

    

    for (Object value : map.values()) {

    	Label dk = new Label(m,1,value.toString());

    	sheet.addCell(dk);

    	m++;

	}

    

    

    //把创建的内容写入到输出流中，并关闭输出流

    workbook.write();

    workbook.close();

    os.close();

}



//向excel中追加数据.@excelPath:excel所在路径,list:数据集合.(第2,3,4,5,6.....次写入

public static void addExcel(String excelPath,List<Object> list ) throws IOException{

	

	FileInputStream fs = new FileInputStream(excelPath);//获取excel

	

	POIFSFileSystem ps = new POIFSFileSystem(fs);//获取excel信息

	

	HSSFWorkbook wb = new HSSFWorkbook(ps);

	

	HSSFSheet sheet = wb.getSheetAt(0);//获取工作表

	

	HSSFRow row = sheet.getRow(0);//获取第一行(即:字段列头,便于赋值)

	

	System.out.println(sheet.getLastRowNum()+"空"+row.getLastCellNum());//分别得到最后一行行号,和一条记录的最后一个单元格

	

	FileOutputStream out = new FileOutputStream(excelPath);//向excel中添加数据

	

	row = sheet.createRow(sheet.getLastRowNum()+1);//在现有行号后追加数据

	

	for (int i = 0; i < list.size(); i++) {

		

		String str = String.valueOf(list.get(i));

		row.createCell(i).setCellValue(str);//设置单元格的数据

	}

	out.flush();

	wb.write(out);

	wb.close();

	

}

)

}