chemaxon.formats.documents.jchemexcel

Class JChemExcelAPI

java.lang.Object

chemaxon.formats.documents.jchemexcel.JChemExcelAPI

@PublicAPI
public class JChemExcelAPI
extends java.lang.Object

Low-level API to create JChemExcel files

Since:

Marvin 5.12

Author:

Andras Kovacs

Constructor Summary

Constructors

Constructor and Description
JChemExcelAPI(org.apache.poi.ss.usermodel.Workbook wb, java.io.OutputStream output) Constructor for adding molecule/structure data one-by-one to store them in a JChemExcel workbook.

Method Summary

Modifier and Type	Method and Description
org.apache.poi.ss.usermodel.Cell	addStructure(java.lang.String worksheetName, int columnIndex, int rowIndex, byte[] structureData) Adds a structure to the cell in the given column/row on the sheet with the given name.
org.apache.poi.ss.usermodel.Cell	addStructure(java.lang.String worksheetName, int columnIndex, int rowIndex, byte[] structureData, java.lang.String format) Adds a structure to the cell in the given column/row on the sheet with the given name.
org.apache.poi.ss.usermodel.Cell	addStructure(java.lang.String worksheetName, int columnIndex, int rowIndex, byte[] structureData, java.lang.String id, boolean showId) Adds a structure to the cell in the given column/row on the sheet with the given name.
org.apache.poi.ss.usermodel.Cell	addStructure(java.lang.String worksheetName, int columnIndex, int rowIndex, byte[] structureData, java.lang.String format, java.lang.String id, boolean showId) Adds a structure to the cell in the given column/row on the sheet with the given name.
org.apache.poi.ss.usermodel.Cell	addStructure(java.lang.String worksheetName, int columnIndex, int rowIndex, Molecule molecule, java.lang.String targetFormat) Adds a structure to the cell in the given column/row on the sheet with the given name.
org.apache.poi.ss.usermodel.Cell	addStructure(java.lang.String worksheetName, int columnIndex, int rowIndex, Molecule molecule, java.lang.String targetFormat, java.lang.String id, boolean showId) Adds a structure to the cell in the given column/row on the sheet with the given name.
org.apache.poi.ss.usermodel.Cell	addStructure(java.lang.String worksheetName, int columnIndex, int rowIndex, java.lang.String structure) Adds a structure to the cell in the given column/row on the sheet with the given name.
org.apache.poi.ss.usermodel.Cell	addStructure(java.lang.String worksheetName, int columnIndex, int rowIndex, java.lang.String structure, java.lang.String format) Adds a structure to the cell in the given column/row on the sheet with the given name.
org.apache.poi.ss.usermodel.Cell	addStructure(java.lang.String worksheetName, int columnIndex, int rowIndex, java.lang.String structure, java.lang.String id, boolean showId) Adds a structure to the cell in the given column/row on the sheet with the given name.
org.apache.poi.ss.usermodel.Cell	addStructure(java.lang.String worksheetName, int columnIndex, int rowIndex, java.lang.String structure, java.lang.String format, java.lang.String id, boolean showId) Adds a structure to the cell in the given column/row on the sheet with the given name.
void	finalize()
void	finish() Writes the workbook to the stream, and closes the stream.
org.apache.poi.ss.usermodel.Sheet	getOrCreateWorksheet(java.lang.String worksheetName)
org.apache.poi.ss.usermodel.Workbook	getWorkbook() Returns the Workbook object model instance

Methods inherited from class java.lang.Object

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

Constructor Detail

JChemExcelAPI

public JChemExcelAPI(org.apache.poi.ss.usermodel.Workbook wb,
                     java.io.OutputStream output)
              throws java.io.FileNotFoundException,
                     chemaxon.license.LicenseException

Constructor for adding molecule/structure data one-by-one to store them in a JChemExcel workbook. Structures/molecules can be added using addStructure() method overloads.

Parameters:

wb - the workbook the structures should be added to

output - the stream to be written the workbook to

Throws:

java.io.FileNotFoundException

chemaxon.license.LicenseException

Method Detail

getWorkbook

public org.apache.poi.ss.usermodel.Workbook getWorkbook()

Returns the Workbook object model instance

getOrCreateWorksheet

public org.apache.poi.ss.usermodel.Sheet getOrCreateWorksheet(java.lang.String worksheetName)

addStructure

public org.apache.poi.ss.usermodel.Cell addStructure(java.lang.String worksheetName,
                                                     int columnIndex,
                                                     int rowIndex,
                                                     Molecule molecule,
                                                     java.lang.String targetFormat)
                                              throws java.io.IOException,
                                                     MolFormatException,
                                                     chemaxon.util.ArgumentException

Adds a structure to the cell in the given column/row on the sheet with the given name.

Parameters:

worksheetName - sheet name of the structure added to

columnIndex - the column-index of the cell the structure added to

rowIndex - the row-index of the cell the structure added to

molecule - the molecule object of the structure

targetFormat - the structure format the molecule will be stored on the structure-sheet

Returns:

the Cell object created

Throws:

java.io.IOException

MolFormatException

chemaxon.util.ArgumentException

addStructure

public org.apache.poi.ss.usermodel.Cell addStructure(java.lang.String worksheetName,
                                                     int columnIndex,
                                                     int rowIndex,
                                                     Molecule molecule,
                                                     java.lang.String targetFormat,
                                                     java.lang.String id,
                                                     boolean showId)
                                              throws java.io.IOException,
                                                     MolFormatException,
                                                     chemaxon.util.ArgumentException

Adds a structure to the cell in the given column/row on the sheet with the given name.

Parameters:

worksheetName - sheet name of the structure added to

columnIndex - the column-index of the cell the structure added to

rowIndex - the row-index of the cell the structure added to

molecule - the molecule object of the structure

targetFormat - the structure format the molecule will be stored on the structure-sheet

id - an Id for the structure also added to the cell (as =JCIDSYSStructure(...,id))

showId - shows the Id instead of the structure by default

Returns:

the Cell object created

Throws:

java.io.IOException

MolFormatException

chemaxon.util.ArgumentException

addStructure

public org.apache.poi.ss.usermodel.Cell addStructure(java.lang.String worksheetName,
                                                     int columnIndex,
                                                     int rowIndex,
                                                     java.lang.String structure)
                                              throws MolFormatException,
                                                     chemaxon.util.ArgumentException,
                                                     java.io.UnsupportedEncodingException,
                                                     java.io.IOException

Adds a structure to the cell in the given column/row on the sheet with the given name. The structure format will be determined automatically, but it causes a substantial overhead compared to when the format also passed as a parameter.

Parameters:

worksheetName - sheet name of the structure added to

columnIndex - the column-index of the cell the structure added to

rowIndex - the row-index of the cell the structure added to

structure - the structure string

Returns:

the Cell object created

Throws:

MolFormatException

chemaxon.util.ArgumentException

java.io.UnsupportedEncodingException

java.io.IOException

addStructure

public org.apache.poi.ss.usermodel.Cell addStructure(java.lang.String worksheetName,
                                                     int columnIndex,
                                                     int rowIndex,
                                                     java.lang.String structure,
                                                     java.lang.String format)
                                              throws java.io.UnsupportedEncodingException,
                                                     MolFormatException,
                                                     chemaxon.util.ArgumentException,
                                                     java.io.IOException,
                                                     java.lang.UnsupportedOperationException

Adds a structure to the cell in the given column/row on the sheet with the given name.

Parameters:

worksheetName - sheet name of the structure added to

columnIndex - the column-index of the cell the structure added to

rowIndex - the row-index of the cell the structure added to

structure - the structure string

format - the structure string format

Returns:

the Cell object created

Throws:

java.io.UnsupportedEncodingException

MolFormatException

chemaxon.util.ArgumentException

java.io.IOException

java.lang.UnsupportedOperationException

addStructure

public org.apache.poi.ss.usermodel.Cell addStructure(java.lang.String worksheetName,
                                                     int columnIndex,
                                                     int rowIndex,
                                                     java.lang.String structure,
                                                     java.lang.String id,
                                                     boolean showId)
                                              throws MolFormatException,
                                                     chemaxon.util.ArgumentException,
                                                     java.io.UnsupportedEncodingException,
                                                     java.io.IOException

Adds a structure to the cell in the given column/row on the sheet with the given name. The structure format will be determined automatically, but it causes a substantial overhead compared to when the format also passed as a parameter.

Parameters:

worksheetName - sheet name of the structure added to

columnIndex - the column-index of the cell the structure added to

rowIndex - the row-index of the cell the structure added to

structure - the structure string

id - an Id for the structure also added to the cell (as =JCIDSYSStructure(...,id))

Returns:

the Cell object created

Throws:

MolFormatException

chemaxon.util.ArgumentException

java.io.UnsupportedEncodingException

java.io.IOException

addStructure

public org.apache.poi.ss.usermodel.Cell addStructure(java.lang.String worksheetName,
                                                     int columnIndex,
                                                     int rowIndex,
                                                     java.lang.String structure,
                                                     java.lang.String format,
                                                     java.lang.String id,
                                                     boolean showId)
                                              throws java.io.UnsupportedEncodingException,
                                                     MolFormatException,
                                                     chemaxon.util.ArgumentException,
                                                     java.io.IOException,
                                                     java.lang.UnsupportedOperationException

Adds a structure to the cell in the given column/row on the sheet with the given name.

Parameters:

worksheetName - sheet name of the structure added to

columnIndex - the column-index of the cell the structure added to

rowIndex - the row-index of the cell the structure added to

structure - the structure string

format - the structure string format

id - an Id for the structure also added to the cell (as =JCIDSYSStructure(...,id))

showId - shows the Id instead of the structure by default

Returns:

the Cell object created

Throws:

java.io.UnsupportedEncodingException

MolFormatException

chemaxon.util.ArgumentException

java.io.IOException

java.lang.UnsupportedOperationException

addStructure

public org.apache.poi.ss.usermodel.Cell addStructure(java.lang.String worksheetName,
                                                     int columnIndex,
                                                     int rowIndex,
                                                     byte[] structureData)
                                              throws MolFormatException,
                                                     chemaxon.util.ArgumentException,
                                                     java.io.IOException,
                                                     java.lang.UnsupportedOperationException

Adds a structure to the cell in the given column/row on the sheet with the given name. The structure format will be determined automatically, but it causes a substantial overhead compared to when the format also passed as a parameter.

Parameters:

worksheetName - sheet name of the structure added to

columnIndex - the column-index of the cell the structure added to

rowIndex - the row-index of the cell the structure added to

structureData - the structure data byte-array

Returns:

the Cell object created

Throws:

MolFormatException

chemaxon.util.ArgumentException

java.io.IOException

java.lang.UnsupportedOperationException

addStructure

public org.apache.poi.ss.usermodel.Cell addStructure(java.lang.String worksheetName,
                                                     int columnIndex,
                                                     int rowIndex,
                                                     byte[] structureData,
                                                     java.lang.String id,
                                                     boolean showId)
                                              throws MolFormatException,
                                                     chemaxon.util.ArgumentException,
                                                     java.io.IOException,
                                                     java.lang.UnsupportedOperationException

Adds a structure to the cell in the given column/row on the sheet with the given name. The structure format will be determined automatically, but it causes a substantial overhead compared to when the format also passed as a parameter.

Parameters:

worksheetName - sheet name of the structure added to

columnIndex - the column-index of the cell the structure added to

rowIndex - the row-index of the cell the structure added to

structureData - the structure data byte-array

id - an Id for the structure also added to the cell (as =JCIDSYSStructure(...,id))

showId - shows the Id instead of the structure by default

Returns:

the Cell object created

Throws:

MolFormatException

chemaxon.util.ArgumentException

java.io.IOException

java.lang.UnsupportedOperationException

addStructure

public org.apache.poi.ss.usermodel.Cell addStructure(java.lang.String worksheetName,
                                                     int columnIndex,
                                                     int rowIndex,
                                                     byte[] structureData,
                                                     java.lang.String format)
                                              throws java.lang.UnsupportedOperationException,
                                                     java.io.IOException

Adds a structure to the cell in the given column/row on the sheet with the given name.

Parameters:

worksheetName - sheet name of the structure added to

columnIndex - the column-index of the cell the structure added to

rowIndex - the row-index of the cell the structure added to

structureData - the structure data byte-array

format - the structure data format

Returns:

the Cell object created

Throws:

java.lang.UnsupportedOperationException

java.io.IOException

addStructure

public org.apache.poi.ss.usermodel.Cell addStructure(java.lang.String worksheetName,
                                                     int columnIndex,
                                                     int rowIndex,
                                                     byte[] structureData,
                                                     java.lang.String format,
                                                     java.lang.String id,
                                                     boolean showId)
                                              throws java.lang.UnsupportedOperationException,
                                                     java.io.IOException

Adds a structure to the cell in the given column/row on the sheet with the given name.

Parameters:

worksheetName - sheet name of the structure added to

columnIndex - the column-index of the cell the structure added to

rowIndex - the row-index of the cell the structure added to

structureData - the structure data byte-array

format - the structure data format

id - an Id for the structure also added to the cell (as =JCIDSYSStructure(...,id))

showId - shows the Id instead of the structure by default

Returns:

the Cell object created

Throws:

java.lang.UnsupportedOperationException

java.io.IOException

finish

public void finish()
            throws java.io.IOException

Writes the workbook to the stream, and closes the stream.

Throws:

java.io.IOException

finalize

public void finalize()
              throws java.lang.Throwable

Overrides:

finalize in class java.lang.Object

Throws:

java.lang.Throwable