A C E G O P S T

A

ALL_ROWS - Static variable in class com.softartisans.excelwriter.ExcelTemplate

The maximum number of rows that can be inserted into a spreadsheet.

C

com.softartisans.excelwriter - package com.softartisans.excelwriter

E

ExcelTemplate - class com.softartisans.excelwriter.ExcelTemplate.

The ExcelTemplate object represents a template* spreadsheet, that is, a file created in Microsoft Excel that contains data markers.

ExcelTemplate() - Constructor for class com.softartisans.excelwriter.ExcelTemplate

Creates a new ExcelTemplate object.

G

getContentType() - Method in class com.softartisans.excelwriter.ExcelTemplate

Returns the current setting for the ContentType header sent to a web browser.

getDecryptPassword() - Method in class com.softartisans.excelwriter.ExcelTemplate

Returns the current value of the DecryptPassword.

getEncryptPassword() - Method in class com.softartisans.excelwriter.ExcelTemplate

Returns the current value of the EncryptPassword.

getExcludeMacros() - Method in class com.softartisans.excelwriter.ExcelTemplate

Return the current setting of ExcludeMacros.

getLicenseKey() - Method in class com.softartisans.excelwriter.ExcelTemplate

Returns the license key used for this instance of ExcelWriter.

getPreserveStrings() - Method in class com.softartisans.excelwriter.ExcelTemplate

Returns the current setting of PreserveStrings.

getRemoveExtraDataMarkers() - Method in class com.softartisans.excelwriter.ExcelTemplate

Returns the current value of the RemoveExtraDataMarkers flag.

getSpreadsheetsCreatedToday() - Method in class com.softartisans.excelwriter.ExcelTemplate

Returns the number of spreadsheets created in the last 24 hours.

getVersion() - Static method in class com.softartisans.excelwriter.ExcelTemplate

Returns the exact version of the ExcelWriter product.

O

open(String) - Method in class com.softartisans.excelwriter.ExcelTemplate

Opens an ExcelWriter template spreadsheet, that is, a file created in Microsoft Excel that contains data markers where values will be inserted.

open(InputStream) - Method in class com.softartisans.excelwriter.ExcelTemplate

Opens an ExcelWriter template spreadsheet from an InputStream.

P

process() - Method in class com.softartisans.excelwriter.ExcelTemplate

Enters datasource values into a new spreadsheet, based on the data marker values in the template.

S

save(HttpServletResponse) - Method in class com.softartisans.excelwriter.ExcelTemplate

Returns output spreadsheet to the browser.

save(HttpServletResponse, String, boolean) - Method in class com.softartisans.excelwriter.ExcelTemplate

Returns output spreadsheet to the browser.

save(OutputStream) - Method in class com.softartisans.excelwriter.ExcelTemplate

Returns the processed spreadsheet to a specified output stream.

save(String) - Method in class com.softartisans.excelwriter.ExcelTemplate

Writes the processed spreadsheet to a specified output file, by path name.

setCellDataSource(Object, String) - Method in class com.softartisans.excelwriter.ExcelTemplate

Set an Object as a data source to bind to a single cell in the template.

setColumnDataSource(Object[], String) - Method in class com.softartisans.excelwriter.ExcelTemplate

Set an array of Objects as a data source to bind to a single column in the template.

setColumnDataSource(Object[], String, int) - Method in class com.softartisans.excelwriter.ExcelTemplate

Set an array of Objects as a data source to bind to a single column in the template.

setContentType(String) - Method in class com.softartisans.excelwriter.ExcelTemplate

Sets the value of the ContentType header sent to a web browser through the save(HttpServletResponse) method.

setDataSource(ResultSet, String) - Method in class com.softartisans.excelwriter.ExcelTemplate

Set a ResultSet as a data source to bind to template data markers.

setDataSource(ResultSet, String, int) - Method in class com.softartisans.excelwriter.ExcelTemplate

Set a ResultSet as a data source to bind to template data markers.

setDataSource(Object[][], String[], String) - Method in class com.softartisans.excelwriter.ExcelTemplate

Set a two-dimensional array of Objects as a data source to bind to datamarkers in the template.

setDataSource(Object[][], String[], String, int, boolean) - Method in class com.softartisans.excelwriter.ExcelTemplate

Set a two-dimensional array of Objects as a data source to bind to datamarkers in the template.

setDecryptPassword(String) - Method in class com.softartisans.excelwriter.ExcelTemplate

Sets the DecryptPassword.

setEncryptPassword(String) - Method in class com.softartisans.excelwriter.ExcelTemplate

Sets the EncryptPassword.

setExcludeMacros(boolean) - Method in class com.softartisans.excelwriter.ExcelTemplate

Sets whether ExcelWriter should remove macros from the resulting template or leave them in.

setLicenseKey(String) - Method in class com.softartisans.excelwriter.ExcelTemplate

Instructs ExcelTemplate to use a particular license key for the duration of this instance, rather than obtaining one programatically from the License.jar file in the classpath.

setPreserveStrings(boolean) - Method in class com.softartisans.excelwriter.ExcelTemplate

Determines whether data inserted into a template is kept as a string or if an attempt to convert to an Excel data type is made.

setRemoveExtraDataMarkers(boolean) - Method in class com.softartisans.excelwriter.ExcelTemplate

Sets whether ExcelWriter should ignore and remove data markers in the template which don't bind to data sources.

setRowDataSource(Object[], String[], String) - Method in class com.softartisans.excelwriter.ExcelTemplate

Set an array of Objects as a data source to bind to a row in the template.

T

toString() - Method in class com.softartisans.excelwriter.ExcelTemplate

Returns a string representation of the ExcelTemplate object, which gives a summary of the values currently used in the object.

A C E G O P S T