src/com/sxt/stat/utils/ExprotCustomerUtils.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.sxt.stat.utils;



import java.io.IOException;
import java.util.Date;
import java.util.List;

import org.apache.commons.io.output.ByteArrayOutputStream;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
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.ss.util.CellRangeAddress;

import com.sxt.bus.domain.Customer;

/**
 * 客户数据库导出
 * 
 * @author LJH
 *
 */
public class ExprotCustomerUtils {

	/**
	 * 导出客户数据
	 * 
	 * @param customers
	 * @param fileName
	 * @param sheetName
	 * @param response
	 * @return
	 */
	
	
	@SuppressWarnings("deprecation")
	public static ByteArrayOutputStream exportCustomer(List<Customer> customers,  String sheetName) {
		// 一组装excel文档
		// 1,创建工作簿
		HSSFWorkbook workbook = new HSSFWorkbook();
		// 2,创建样式
		HSSFCellStyle baseStyle = ExprotHSSFCellStyle.createBaseStyle(workbook);
		HSSFCellStyle subTitleStyle = ExprotHSSFCellStyle.createSubTitleStyle(workbook);
		HSSFCellStyle tableTitleStyle = ExprotHSSFCellStyle.createTableTitleStyle(workbook);
		HSSFCellStyle titleStyle = ExprotHSSFCellStyle.createTitleStyle(workbook);
		// 3在工作簿创建sheet
		HSSFSheet sheet = workbook.createSheet(sheetName);
		// 4,设置sheet
		sheet.setDefaultColumnWidth(25);
		// 5,合并
		CellRangeAddress region1 = new CellRangeAddress(0, 0, 0, 6);
		CellRangeAddress region2 = new CellRangeAddress(1, 1, 0, 6);
		sheet.addMergedRegion(region1);
		sheet.addMergedRegion(region2);
		// 6,创建第一行
		int index = 0;
		HSSFRow row1 = sheet.createRow(index);