ambit2.db.reporters.xlsx

Class AbstractXLSXReporter<Q extends net.idea.modbcum.i.IQueryRetrieval<IStructureRecord>>

java.lang.Object

net.idea.modbcum.p.DefaultAmbitProcessor<Target,Result>

net.idea.modbcum.p.AbstractDBProcessor<Q,Output>

net.idea.modbcum.r.QueryAbstractReporter<T,Q,Output>

net.idea.modbcum.r.QueryReporter<IStructureRecord,Q,Output>

ambit2.db.reporters.QueryStructureReporter<Q,Output>

ambit2.db.reporters.QueryHeaderReporter<Q,OutputStream>

ambit2.db.reporters.xlsx.AbstractXLSXReporter<Q>

All Implemented Interfaces:

Serializable, net.idea.modbcum.i.IDBProcessor<Q,OutputStream>, net.idea.modbcum.i.processors.IProcessor<Q,OutputStream>, net.idea.modbcum.i.reporter.Reporter<Q,OutputStream>

Direct Known Subclasses:

StructureRecordXLSXReporter, SubstanceRecordXLSXReporter

public abstract class AbstractXLSXReporter<Q extends net.idea.modbcum.i.IQueryRetrieval<IStructureRecord>>
extends QueryHeaderReporter<Q,OutputStream>

See Also:

Serialized Form

Field Summary

Fields

Modifier and Type	Field and Description
protected org.apache.poi.ss.usermodel.DataFormat	dataformat
protected String	fileExtension
protected OutputStream	out
protected org.apache.poi.ss.usermodel.Sheet	sheet
protected org.apache.poi.ss.usermodel.CellStyle	style
protected org.apache.poi.ss.usermodel.Workbook	workbook
protected boolean	writingStarted

Fields inherited from class ambit2.db.reporters.QueryHeaderReporter

groupProperties, header, includeMol, template

Fields inherited from class net.idea.modbcum.r.QueryAbstractReporter

autoCommit, batch, licenseURI, maxRecords, output, processors, showFooter, showHeader, startTime, timeout

Fields inherited from class net.idea.modbcum.p.AbstractDBProcessor

closeConnection, connection

Fields inherited from class net.idea.modbcum.p.DefaultAmbitProcessor

enabled, logger, propertyChangeSupport

Constructor Summary

Constructors

Constructor and Description
AbstractXLSXReporter(String baseRef, boolean hssf, Template template, Profile groupedProperties, SubstanceEndpointsBundle[] bundles, String urlPrefix, boolean includeMol)

Method Summary

Modifier and Type	Method and Description
protected org.apache.poi.ss.usermodel.RichTextString	createRichTextString(String value, org.apache.poi.ss.usermodel.Font font)
void	footer(OutputStream output, Q query)
String	getFileExtension()

Methods inherited from class ambit2.db.reporters.QueryHeaderReporter

configureProcessors, configurePropertyProcessors, getGroupProperties, getHeader, getTemplate, isIncludeMol, setGroupProperties, setTemplate, template2Header

Methods inherited from class ambit2.db.reporters.QueryStructureReporter

createBatch, isIncludeLicenseInTextFiles

Methods inherited from class net.idea.modbcum.r.QueryAbstractReporter

getLicenseURI, getMaxRecords, getOutput, getProcessors, getStartTime, getTimeout, header, isAutoCommit, isShowFooter, isShowHeader, process, processItem, setAutoCommit, setCloseConnection, setLicenseURI, setMaxRecords, setOutput, setProcessors, setShowFooter, setShowHeader, setStartTime, setTimeout, wrapup

Methods inherited from class net.idea.modbcum.p.AbstractDBProcessor

close, getConnection, isCloseConnection, isEnabled, setConnection

Methods inherited from class net.idea.modbcum.p.DefaultAmbitProcessor

addPropertyChangeListener, addPropertyChangeListener, getID, open, removePropertyChangeListener, removePropertyChangeListener, setEnabled, toString

Methods inherited from class java.lang.Object

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

Methods inherited from interface net.idea.modbcum.i.reporter.Reporter

close

Methods inherited from interface net.idea.modbcum.i.processors.IProcessor

getID, isEnabled, open, setEnabled

Field Detail

workbook

protected org.apache.poi.ss.usermodel.Workbook workbook

sheet

protected org.apache.poi.ss.usermodel.Sheet sheet

dataformat

protected org.apache.poi.ss.usermodel.DataFormat dataformat

style

protected org.apache.poi.ss.usermodel.CellStyle style

out

protected OutputStream out

writingStarted

protected boolean writingStarted

fileExtension

protected String fileExtension

Constructor Detail

AbstractXLSXReporter

public AbstractXLSXReporter(String baseRef,
                            boolean hssf,
                            Template template,
                            Profile groupedProperties,
                            SubstanceEndpointsBundle[] bundles,
                            String urlPrefix,
                            boolean includeMol)

Method Detail

footer

public void footer(OutputStream output,
                   Q query)

Specified by:

footer in class net.idea.modbcum.r.QueryAbstractReporter<IStructureRecord,Q extends net.idea.modbcum.i.IQueryRetrieval<IStructureRecord>,OutputStream>

createRichTextString

protected org.apache.poi.ss.usermodel.RichTextString createRichTextString(String value,
                                                                          org.apache.poi.ss.usermodel.Font font)

getFileExtension

public String getFileExtension()

Specified by:

getFileExtension in interface net.idea.modbcum.i.reporter.Reporter<Q extends net.idea.modbcum.i.IQueryRetrieval<IStructureRecord>,OutputStream>

Overrides:

getFileExtension in class net.idea.modbcum.r.QueryAbstractReporter<IStructureRecord,Q extends net.idea.modbcum.i.IQueryRetrieval<IStructureRecord>,OutputStream>