xyz.erupt.excel.service

Class EruptExcelService

java.lang.Object

xyz.erupt.excel.service.EruptExcelService

@Service
public class EruptExcelService
extends Object

Author:

YuePeng date 12/4/18.

Field Summary

Fields

Modifier and Type	Field and Description
static String	XLS_FORMAT
static String	XLSX_FORMAT

Constructor Summary

Constructors

Constructor and Description
EruptExcelService()

Method Summary

Modifier and Type	Method and Description
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)

Methods inherited from class java.lang.Object

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

Field Detail

XLS_FORMAT

public static final String XLS_FORMAT

See Also:

Constant Field Values

XLSX_FORMAT

public static final String XLSX_FORMAT

See Also:

Constant Field Values

Constructor Detail

EruptExcelService

public EruptExcelService()

Method Detail

exportExcel

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

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

Returns:

Workbook

excelToEruptObject

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

Throws:

Exception

getStringCellValue

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

createExcelTemplate

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