io.vertx.tp.plugin.excel

Interface ExcelClient

All Superinterfaces:

io.vertx.up.plugin.TpClient<ExcelClient>

All Known Implementing Classes:

ExcelClientImpl

public interface ExcelClient
extends io.vertx.up.plugin.TpClient<ExcelClient>

ExcelClient for office excel data loading Apache Poi

Field Summary

Fields

Modifier and Type	Field and Description
static String	MAPPING

Method Summary

Modifier and Type	Method and Description
static ExcelClient	createShared(io.vertx.core.Vertx vertx, io.vertx.core.json.JsonObject config)
ExcelClient	exportTable(String identifier, io.vertx.core.json.JsonArray data, io.vertx.core.Handler<io.vertx.core.AsyncResult<io.vertx.core.buffer.Buffer>> handler)
<T> ExcelClient	importTable(String tableOnly, InputStream in, io.vertx.core.Handler<io.vertx.core.AsyncResult<Set<T>>> handler)
<T> ExcelClient	importTable(String tableOnly, String filename, io.vertx.core.Handler<io.vertx.core.AsyncResult<Set<T>>> handler)
Set<ExTable>	ingest(InputStream in, boolean isXlsx)
ExcelClient	ingest(InputStream in, boolean isXlsx, io.vertx.core.Handler<io.vertx.core.AsyncResult<Set<ExTable>>> handler)
Set<ExTable>	ingest(String filename)
ExcelClient	ingest(String filename, io.vertx.core.Handler<io.vertx.core.AsyncResult<Set<ExTable>>> handler)
ExcelClient	init(io.vertx.core.json.JsonObject params)
<T> ExcelClient	loading(InputStream in, boolean isXlsx, io.vertx.core.Handler<io.vertx.core.AsyncResult<Set<T>>> handler) Two format supported here: 2013 / 2017
<T> ExcelClient	loading(String filename, io.vertx.core.Handler<io.vertx.core.AsyncResult<Set<T>>> handler) Excel file data loading

Field Detail

MAPPING

static final String MAPPING

See Also:

Constant Field Values

Method Detail

createShared

static ExcelClient createShared(io.vertx.core.Vertx vertx,
                                io.vertx.core.json.JsonObject config)

init

ExcelClient init(io.vertx.core.json.JsonObject params)

Specified by:

init in interface io.vertx.up.plugin.TpClient<ExcelClient>

loading

<T> ExcelClient loading(String filename,
                        io.vertx.core.Handler<io.vertx.core.AsyncResult<Set<T>>> handler)

Excel file data loading

Parameters:

filename - data input file

handler - callback handler to process Set

Returns:

self reference

ingest

ExcelClient ingest(String filename,
                   io.vertx.core.Handler<io.vertx.core.AsyncResult<Set<ExTable>>> handler)

ingest

Set<ExTable> ingest(String filename)

exportTable

ExcelClient exportTable(String identifier,
                        io.vertx.core.json.JsonArray data,
                        io.vertx.core.Handler<io.vertx.core.AsyncResult<io.vertx.core.buffer.Buffer>> handler)

importTable

<T> ExcelClient importTable(String tableOnly,
                            String filename,
                            io.vertx.core.Handler<io.vertx.core.AsyncResult<Set<T>>> handler)

importTable

<T> ExcelClient importTable(String tableOnly,
                            InputStream in,
                            io.vertx.core.Handler<io.vertx.core.AsyncResult<Set<T>>> handler)

loading

<T> ExcelClient loading(InputStream in,
                        boolean isXlsx,
                        io.vertx.core.Handler<io.vertx.core.AsyncResult<Set<T>>> handler)

Two format supported here: 2013 / 2017

ingest

ExcelClient ingest(InputStream in,
                   boolean isXlsx,
                   io.vertx.core.Handler<io.vertx.core.AsyncResult<Set<ExTable>>> handler)

ingest

Set<ExTable> ingest(InputStream in,
                    boolean isXlsx)