java导出excel设置行高列宽_POI 导出Excel 并且根据内容设置列宽自适应

package com.XXX;

import java.io.IOException;

import java.io.OutputStream;

import java.net.URLEncoder;

import java.text.SimpleDateFormat;

import java.util.Date;

import java.util.Iterator;

import java.util.LinkedHashMap;

import java.util.Set;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import org.apache.poi.hssf.usermodel.HSSFCellStyle;

import org.apache.poi.hssf.usermodel.HSSFFont;

import org.apache.poi.hssf.util.HSSFColor;

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.Row;

import org.apache.poi.ss.usermodel.Sheet;

import org.apache.poi.xssf.streaming.SXSSFWorkbook;

import com.eos.system.annotation.Bizlet;

import commonj.sdo.DataObject;

public class ExcelExportUtil {

/**

*

* Excel导出

* @author RangoLan

* @param criteriaEntity DataObject 获取填充数据源的查询对象

* @param fileName 生成的文件名前缀

* @param response HttpServletResponse响应

* @param colToProperty 表格列名和DataObject对象Property应的LinkedHashMap

* @param datePattern 日期格式数据格式

* @param HttpServletRequest request 请求对象，用于无数据输出时，内部跳转

* @param backPage 执行查询后无数据时返回画面

*/

@Bizlet("数据写入Excel并生成下载")

public static void exportExcel(String fileName,HttpServletRequest request,HttpServletResponse response,DataObject criteriaEntity,LinkedHashMap colToProperty,String datePattern,String backPage) throws Exception {

//根据查询对象criteria填充数据源

DataObject[] datas = (DataObject[])com.eos.foundation.database.DatabaseUtil.queryEntitiesByCriteriaEntity("default", criteriaEntity);

if (datas != null && datas.length > 0) {

if(datePattern==null){