xyz.erupt.excel.service

类 EruptExcelService

java.lang.Object

xyz.erupt.excel.service.EruptExcelService

@Service
public class EruptExcelService
extends Object

作者:

YuePeng date 12/4/18.

字段概要

字段

限定符和类型	字段和说明
static String	XLS_FORMAT
static String	XLSX_FORMAT

构造器概要

构造器

构造器和说明
EruptExcelService()

方法概要

限定符和类型	方法和说明
org.apache.poi.ss.usermodel.Workbook	createExcelTemplate(EruptModel eruptModel)
List<com.google.gson.JsonObject>	excelToEruptObject(EruptModel eruptModel, org.apache.poi.ss.usermodel.Workbook workbook)
org.apache.poi.ss.usermodel.Workbook	exportExcel(EruptModel eruptModel, Page page) excel导出，展示的格式和view表格一致
String	getStringCellValue(org.apache.poi.ss.usermodel.Cell cell)

从类继承的方法 java.lang.Object

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

字段详细资料

XLS_FORMAT

public static final String XLS_FORMAT

另请参阅:

常量字段值

XLSX_FORMAT

public static final String XLSX_FORMAT

另请参阅:

常量字段值

构造器详细资料

EruptExcelService

public EruptExcelService()

方法详细资料

exportExcel

public org.apache.poi.ss.usermodel.Workbook exportExcel(EruptModel eruptModel,
                                                        Page page)

excel导出，展示的格式和view表格一致

返回:

Workbook

excelToEruptObject

public List<com.google.gson.JsonObject> excelToEruptObject(EruptModel eruptModel,
                                                           org.apache.poi.ss.usermodel.Workbook workbook)
                                                    throws Exception

抛出:

Exception

getStringCellValue

public String getStringCellValue(org.apache.poi.ss.usermodel.Cell cell)

createExcelTemplate

public org.apache.poi.ss.usermodel.Workbook createExcelTemplate(EruptModel eruptModel)