com.platform.utils.excel

Class ExcelImport

java.lang.Object

com.platform.utils.excel.ExcelImport

public class ExcelImport
extends Object

Excel文件导入的基本功能类 可导入EXCEL2003 和 EXCEL2007格式。

Author:

lipengjun

Field Summary

Fields

Modifier and Type	Field and Description
static String	EXCEL03_EXTENSION excel2003扩展名
static String	EXCEL07_EXTENSION excel2007扩展名

Method Summary

Modifier and Type	Method and Description
static List<String[]>	getExcelData(org.springframework.web.multipart.MultipartFile excelFile) 通过解析MultipartFile对象获取excel内容，并且将其拼装为List对象返回
static List<String[]>	getExcelData03(org.springframework.web.multipart.MultipartFile excelFile) 解析EXCEL数据为 List
static List<String[]>	getExcelData07(org.springframework.web.multipart.MultipartFile excelFile) 解析EXCEL数据为 List
static Map<Integer,List<String[]>>	getExcelDataAll(org.springframework.web.multipart.MultipartFile excelFile) 通过解析MultipartFile对象获取excel内容，并且将其拼装为Map>对象返回

Methods inherited from class java.lang.Object

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

Field Detail

EXCEL03_EXTENSION

public static final String EXCEL03_EXTENSION

excel2003扩展名

See Also:

Constant Field Values

EXCEL07_EXTENSION

public static final String EXCEL07_EXTENSION

excel2007扩展名

See Also:

Constant Field Values

Method Detail

getExcelData07

public static List<String[]> getExcelData07(org.springframework.web.multipart.MultipartFile excelFile)

解析EXCEL数据为 List

Parameters:

excelFile - 要解析的上传EXCEL文件

Returns:

List

getExcelData03

public static List<String[]> getExcelData03(org.springframework.web.multipart.MultipartFile excelFile)

解析EXCEL数据为 List

Parameters:

excelFile - 要解析的上传EXCEL文件

Returns:

List

getExcelData

public static List<String[]> getExcelData(org.springframework.web.multipart.MultipartFile excelFile)
                                   throws RRException

通过解析MultipartFile对象获取excel内容，并且将其拼装为List对象返回

Parameters:

excelFile -

Returns:

Throws:

Exception

RRException

getExcelDataAll

public static Map<Integer,List<String[]>> getExcelDataAll(org.springframework.web.multipart.MultipartFile excelFile)
                                                   throws RRException

通过解析MultipartFile对象获取excel内容，并且将其拼装为Map>对象返回

Parameters:

excelFile -

Returns:

Throws:

Exception

RRException