bap.core.ct

Class ExcelOperator

java.lang.Object

bap.core.ct.ExcelOperator

public class ExcelOperator
extends java.lang.Object

excel操作类

Author:

BW.Panda Jul 5, 2016

Constructor Summary

Constructors

Constructor and Description
ExcelOperator()

Method Summary

Modifier and Type	Method and Description
static org.apache.poi.hssf.usermodel.HSSFCellStyle	createCommonCellStyle(org.apache.poi.hssf.usermodel.HSSFWorkbook workbook) 功能描述:创建CT中导出Excel时文档用的通用单元格样式
static <T> org.apache.poi.hssf.usermodel.HSSFWorkbook	createExcel(java.util.List<T> dataList, java.util.Map<java.lang.String,java.lang.String> map) 功能描述: 创建一个Excel文档

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

ExcelOperator

public ExcelOperator()

Method Detail

createExcel

public static <T> org.apache.poi.hssf.usermodel.HSSFWorkbook createExcel(java.util.List<T> dataList,
                                                                         java.util.Map<java.lang.String,java.lang.String> map)

功能描述: 创建一个Excel文档

Type Parameters:

T - 数据集合的泛型类型

Parameters:

dataList - 数据集合对象

map -

 map对象
                                key 为字段描述，将被用于excel的标题，如：名字
                                value 为字段名，如：name
 

Returns:

HSSFWorkbook对象

createCommonCellStyle

public static org.apache.poi.hssf.usermodel.HSSFCellStyle createCommonCellStyle(org.apache.poi.hssf.usermodel.HSSFWorkbook workbook)

功能描述:创建CT中导出Excel时文档用的通用单元格样式

Parameters:

workbook - excel文档对象

Returns:

HSSFCellStyle