cn.afterturn.easypoi.util

Class PoiPublicUtil

java.lang.Object

cn.afterturn.easypoi.util.PoiPublicUtil

public final class PoiPublicUtil
extends Object

EASYPOI 的公共基础类

Author:

JueYue 2015年4月5日 上午12:59:22

Method Summary

Modifier and Type	Method and Description
static Object	createObject(Class<?> clazz, String targetId) 彻底创建一个对象
static String	doubleToString(Double value) double to String 防止科学计数法
static Field[]	getClassFields(Class<?> clazz) 获取class的 包括父类的
static String	getFileExtendName(byte[] photoByte)
static Object[]	getIsAndType(ImageEntity entity) 返回流和图片类型
static Object	getParamsValue(String params, Object object) 获取参数值
static Object	getRealValue(String currentText, Map<String,Object> map) 解析数据
static Map<String,org.apache.poi.ss.usermodel.PictureData>	getSheetPictrues03(org.apache.poi.hssf.usermodel.HSSFSheet sheet, org.apache.poi.hssf.usermodel.HSSFWorkbook workbook) 获取Excel2003图片
static Map<String,org.apache.poi.ss.usermodel.PictureData>	getSheetPictrues07(org.apache.poi.xssf.usermodel.XSSFSheet sheet, org.apache.poi.xssf.usermodel.XSSFWorkbook workbook) 获取Excel2007图片
static String	getValueByTargetId(String key, String targetId, String defalut) 统一 key的获取规则
static Object	getValueDoWhile(Object object, String[] paramsArr, int index) 通过遍历过去对象值
static boolean	isCollection(Class<?> clazz) 判断是不是集合的实现类
static boolean	isJavaClass(Field field) 是不是java基础类
static boolean	isNotUserExcelUserThis(List<String> exclusionsList, Field field, String targetId) 判断是否不要在这个excel操作中
static <K,V> Map<K,V>	mapFor(Object... mapping)
static void	setWordText(org.apache.poi.xwpf.usermodel.XWPFRun currentRun, String currentText) 支持换行操作

Methods inherited from class java.lang.Object

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

Method Detail

mapFor

public static <K,V> Map<K,V> mapFor(Object... mapping)

createObject

public static Object createObject(Class<?> clazz,
                                  String targetId)

彻底创建一个对象

Parameters:

clazz -

Returns:

getClassFields

public static Field[] getClassFields(Class<?> clazz)

获取class的 包括父类的

Parameters:

clazz -

Returns:

getFileExtendName

public static String getFileExtendName(byte[] photoByte)

Parameters:

photoByte -

Returns:

getSheetPictrues03

public static Map<String,org.apache.poi.ss.usermodel.PictureData> getSheetPictrues03(org.apache.poi.hssf.usermodel.HSSFSheet sheet,
                                                                                     org.apache.poi.hssf.usermodel.HSSFWorkbook workbook)

获取Excel2003图片

Parameters:

sheet - 当前sheet对象

workbook - 工作簿对象

Returns:

Map key:图片单元格索引（1_1）String，value:图片流PictureData

getSheetPictrues07

public static Map<String,org.apache.poi.ss.usermodel.PictureData> getSheetPictrues07(org.apache.poi.xssf.usermodel.XSSFSheet sheet,
                                                                                     org.apache.poi.xssf.usermodel.XSSFWorkbook workbook)

获取Excel2007图片

Parameters:

sheet - 当前sheet对象

workbook - 工作簿对象

Returns:

Map key:图片单元格索引（1_1）String，value:图片流PictureData

isCollection

public static boolean isCollection(Class<?> clazz)

判断是不是集合的实现类

Parameters:

clazz -

Returns:

isJavaClass

public static boolean isJavaClass(Field field)

是不是java基础类

Parameters:

field -

Returns:

isNotUserExcelUserThis

public static boolean isNotUserExcelUserThis(List<String> exclusionsList,
                                             Field field,
                                             String targetId)

判断是否不要在这个excel操作中

Parameters:

exclusionsList -

field -

targetId -

Returns:

getIsAndType

public static Object[] getIsAndType(ImageEntity entity)
                             throws Exception

返回流和图片类型

Parameters:

entity -

Returns:

(byte[]) isAndType[0],(Integer)isAndType[1]

Throws:

Exception

getParamsValue

public static Object getParamsValue(String params,
                                    Object object)
                             throws Exception

获取参数值

Parameters:

params -

object -

Returns:

Throws:

Exception

getRealValue

public static Object getRealValue(String currentText,
                                  Map<String,Object> map)
                           throws Exception

解析数据

Returns:

Throws:

Exception

getValueDoWhile

public static Object getValueDoWhile(Object object,
                                     String[] paramsArr,
                                     int index)
                              throws Exception

通过遍历过去对象值

Parameters:

object -

paramsArr -

index -

Returns:

Throws:

Exception

doubleToString

public static String doubleToString(Double value)

double to String 防止科学计数法

Parameters:

value -

Returns:

getValueByTargetId

public static String getValueByTargetId(String key,
                                        String targetId,
                                        String defalut)

统一 key的获取规则

Parameters:

key -

targetId -

Returns:

setWordText

public static void setWordText(org.apache.poi.xwpf.usermodel.XWPFRun currentRun,
                               String currentText)

支持换行操作

Parameters:

currentRun -

currentText -