java导出Excel文件

最新推荐文章于 2024-07-03 14:13:18 发布

银狐被占用

最新推荐文章于 2024-07-03 14:13:18 发布

阅读量508

点赞数 1

分类专栏： java

本文链接：https://blog.csdn.net/baby97/article/details/78490948

版权

java 专栏收录该内容

12 篇文章 0 订阅

订阅专栏

import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStream;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import java.util.List;
import java.util.Map;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

	public void exportExcel(List<DTO> list, String fileName, Map<String,String> headName) throws WriteException,IOException{
    	OutputStream os = new FileOutputStream(new File(fileName));
        //创建工作薄
        WritableWorkbook workbook = Workbook.createWorkbook(os);
        //创建新的一页
        WritableSheet sheet = workbook.createSheet("列表",0);
        //生成列表标题
        Map<String,Object> dataMap;
        int row = 0, cell = 0;
        if(headName == null){
        	headName = (Map<String,String>)list.get(0);
        }
		for(String key : headName.keySet()){
			Label label = new Label(cell, row ,headName.get(key));
			sheet.addCell(label);
			cell++;
		}
		//生成内容
    	for(row = 0;row < list.size();row++){
    		cell = 0;
    		dataMap = (Map<String,Object>)list.get(row);
    		for(String key : headName.keySet()){
    			Label label = new Label(cell, row + 1 ,dataMap.get(key).toString());
    			sheet.addCell(label);
    			cell++;
    		}
    	}
        workbook.write();
        workbook.close();
        os.close();
    }