A B C D E G H I L M N O P R S T W Z

A

addCellComment(String, int, int, String) - Method in class com.psec.excel.WriteExcel

Adds a Comment to the specified Cell using a fixed Font.

addCellComment(String, int, int, String, boolean) - Method in class com.psec.excel.WriteExcel

Adds a Comment to the specified Cell with specified Font.

addDataFilterLine() - Method in class com.psec.excel.WriteExcel.Area

Creates a Data filter line as row 0.

addDataFormat(String, String, String) - Method in class com.psec.excel.WriteExcel

Adds a DataFormat type.

addExternalSheet(String, Sheet, String) - Method in class com.psec.excel.WriteExcel

This clones the source Sheet into the Workbook being constructed as a Sheet named sSheet.

addProp(String) - Method in class com.psec.util.Parm.Opt

Parse and add property string.

addRow(ArrayList<String>) - Method in class com.psec.excel.WriteExcel.Area

Adds a row of columns to the Area row array.

addRow(ArrayList<String>, int) - Method in class com.psec.excel.WriteExcel.Area

Adds a row of columns to the Area row array and adds a stripe mark.

addRow(ArrayList<String>, String) - Method in class com.psec.excel.WriteExcel.Area

Adds a row of columns to the Area row array along with a row format specifier.

addRow(String[]) - Method in class com.psec.excel.WriteExcel.Area

Adds a row of columns to the Area row array.

addRow(String[], int) - Method in class com.psec.excel.WriteExcel.Area

Adds a row of columns to the Area row array and adds a stripe mark.

addRow(String[], String) - Method in class com.psec.excel.WriteExcel.Area

Adds a row of columns to the Area row array along with a row format specifier.

addStyleDefn(String, String) - Method in class com.psec.excel.WriteExcel

Registers a named style.

Area() - Constructor for class com.psec.excel.WriteExcel.Area

Class constructor.

attachWorkbook(Workbook) - Method in class com.psec.excel.ReadExcelFile

Attaches the Workbook to a ReadExcelFile instance so all its methods can be used.

B

bHelp - Variable in class com.psec.util.Parm.Opt

Trigger dump of options when true.

bookSheet(String) - Method in class com.psec.excel.WriteExcel

Creates an empty Sheet called sName.

Brief() - Constructor for class com.psec.util.Parm.Brief

C

canAccept() - Method in class com.psec.excel.ReadExcelRecord

This function can be changed to be selective as to what rows are included in the Row set.

canAccept() - Method in class com.psec.run.DemoExcel.ReadCounts

cellSummary(Cell) - Method in class com.psec.excel.WriteExcel

Return a stringized summary of the Cell.

close() - Method in class com.psec.excel.WriteExcel

Close the Workbook.

closeFile() - Method in class com.psec.excel.ReadExcelFile

Closes the Workbook.

ColMap(int, String, Field) - Constructor for class com.psec.excel.ReadExcelFile.ColMap

The constructor

colWidth(int, int, int) - Method in class com.psec.excel.WriteExcel.Area

Sets the width of a set of columns to nChars.

colWidth(int, int) - Method in class com.psec.excel.WriteExcel.Area

Sets the width of the specified column to nChars.

com.psec.excel - package com.psec.excel

com.psec.run - package com.psec.run

com.psec.util - package com.psec.util

create(WriteExcel, String) - Static method in class com.psec.excel.WriteExcel

Creates an instance of WriteExcel that will write sFileName.

create(WriteExcel, String, String) - Static method in class com.psec.excel.WriteExcel

Create an instance of WriteExcel that will write sFileName and uses sSrcFile as a template file.

create(Workbook) - Static method in class com.psec.excel.WriteExcel

Internal access to Cell manipulation routines.

createArea(String) - Method in class com.psec.excel.WriteExcel

Creates an Area with a base Row and Column of 0 on the specified Sheet.

createArea(String, int, int) - Method in class com.psec.excel.WriteExcel

Creates an Area with the specified base Row and Column on the specified Sheet.

customExit(CellStyle, String) - Method in class com.psec.excel.WriteExcel

Allow custom modifications to CellStyle.

D

DemoExcel - Class in com.psec.run

Class used to test and demonstrate the ReadExcelFile and WriteExcel capabilities.

DemoExcel() - Constructor for class com.psec.run.DemoExcel

DemoExcel.ReadCounts - Class in com.psec.run

This exit is used in creating a chart from a template.

dumpCellFontCache() - Method in class com.psec.excel.WriteExcel

Return a stringized summary of the CellStyle Font cache.

dumpCellStyleCache() - Method in class com.psec.excel.WriteExcel

Return a stringized summary of the CellStyle cache.

E

e(String) - Static method in class com.psec.run.HelloExcel

e(String) - Static method in class com.psec.run.HelloExcelNHN

G

getAbsRow() - Method in class com.psec.excel.WriteExcel.Area

Return next absolute row.

getBaseCol() - Method in class com.psec.excel.WriteExcel.Area

Return absolute column of start of Area on sheet.

getBaseRow() - Method in class com.psec.excel.WriteExcel.Area

Return absolute row of start of Area on sheet.

getColAsStr(Row, ReadExcelFile.ColMap) - Method in class com.psec.excel.ReadExcelFile

Return a stringized version of the Cell at the specified location.

getColCell(Row, ReadExcelFile.ColMap) - Method in class com.psec.excel.ReadExcelFile

Return Cell at the specified location.

getColMap() - Method in class com.psec.excel.ReadExcelRecord

The ColMap string definition is returned.

getColMap() - Method in class com.psec.run.DemoExcel.ReadCounts

getDataRow() - Method in class com.psec.excel.WriteExcel.Area

Return absolute row of first data row.

getHdrCount() - Method in class com.psec.excel.WriteExcel.Area

Return size of Header array.

getHdrExtras() - Method in class com.psec.excel.WriteExcel

Gets the standard header builtins styles.

getPrintArea(String) - Method in class com.psec.excel.ReadExcelFile

Returns the String version of a Sheet print area.

getProp(String) - Method in class com.psec.util.Parm.Opt

Return property value for sKey or null;

getProp(String, String) - Method in class com.psec.util.Parm.Opt

Return property value for sKey or sDef;

getProps() - Method in class com.psec.util.Parm.Opt

Return an array of property value names;

getRowCount() - Method in class com.psec.excel.WriteExcel.Area

Return size of Rows array.

getRowCount(String) - Method in class com.psec.excel.WriteExcel

Gets the Row count on the specified Sheet.

getRows() - Method in class com.psec.excel.WriteExcel.Area

Gets the current row array contents.

getSheet(String) - Method in class com.psec.excel.ReadExcelFile

Returns the named Sheet.

getSheet() - Method in class com.psec.excel.WriteExcel.Area

Return Sheet name area.

getStdExtras() - Method in class com.psec.excel.WriteExcel

Gets the standard builtins styles.

getStrValue(String, int, int) - Method in class com.psec.excel.WriteExcel

Gets the String value of the specified Cell.

getWorkbook() - Method in class com.psec.excel.ReadExcelFile

Gets the Workbook being accessed.

getWorkbook() - Method in class com.psec.excel.WriteExcel

Gets the Workbook being constructed.

getWriter() - Method in class com.psec.excel.WriteExcel.Area

Return WriteExcel for this area.

H

header(String) - Method in class com.psec.excel.WriteExcel.Area

Adds a set of columns to the header array.

header(String, String) - Method in class com.psec.excel.WriteExcel.Area

Adds a set of columns to the header array and applies a default row format specifier.

HelloExcel - Class in com.psec.run

Demonstrate a very basic example of WriteExcel.

HelloExcel() - Constructor for class com.psec.run.HelloExcel

HelloExcelNHN - Class in com.psec.run

Demonstrate a very basic example of WriteExcel.

HelloExcelNHN() - Constructor for class com.psec.run.HelloExcelNHN

I

isTrue(String) - Method in class com.psec.util.Parm.Opt

Return whether a property value represents true.

L

log(String) - Static method in class com.psec.run.HelloExcel

log(String) - Static method in class com.psec.run.HelloExcelNHN

M

main(String[]) - Static method in class com.psec.run.DemoExcel

main(String[]) - Static method in class com.psec.run.HelloExcel

main(String[]) - Static method in class com.psec.run.HelloExcelNHN

main(String[]) - Static method in class com.psec.run.TestArgsPowerShell

mainStart(Parm[], String[], Parm.MainRun) - Method in class com.psec.util.Parm.Opt

The mainStart method handles the standard startup and termination procedures.

makeFileLink(String, String, int, int, String, String) - Method in class com.psec.excel.WriteExcel

Make File link entry.

makeIndexLink(String, String, String, int, int, String) - Method in class com.psec.excel.WriteExcel

Make index link entry.

makeIndexLink(String, String, String, int, int, String, int, int) - Method in class com.psec.excel.WriteExcel

Make index link entry.

makeStdLink(String, String, int, int, String, String, int, int) - Method in class com.psec.excel.WriteExcel

Make standard link entry.

makeUniLink(String, String, int, int, String, int, int, String) - Method in class com.psec.excel.WriteExcel

Make a one directional link from the source location to the target location.

makeUniLink(String, String, int, int, String, int, int, String, int) - Method in class com.psec.excel.WriteExcel

Make a one directional link from the source location to the target location.

makeUrlLink(String, String, int, int, String, String) - Method in class com.psec.excel.WriteExcel

Make URL link entry.

N

nCol - Variable in class com.psec.excel.ReadExcelFile.ColMap

The column number relative to 0 on the Workbook sheet where the value is to be obtained

nMtg1 - Variable in class com.psec.run.DemoExcel.ReadCounts

nMtg2 - Variable in class com.psec.run.DemoExcel.ReadCounts

Note() - Constructor for class com.psec.excel.ReadExcelRecord.Note

O

oCell - Variable in class com.psec.excel.ReadExcelRecord.Note

oCM - Variable in class com.psec.excel.ReadExcelRecord

The column map for record set

oFld - Variable in class com.psec.excel.ReadExcelFile.ColMap

The field that can be used to populate the value using Java reflection in the extended ReadExcelRecord class

oNote - Variable in class com.psec.excel.ReadExcelRecord.Note

openFile(String) - Method in class com.psec.excel.ReadExcelFile

Opens the Workbook.

Opt() - Constructor for class com.psec.util.Parm.Opt

OptionalFlag - Annotation Type in com.psec.util

Fields following this annotation marker are deemed optional by the Gson.builder interface used by these programs.

oRow - Variable in class com.psec.excel.ReadExcelRecord

The Row containing the columns.

P

Parm - Class in com.psec.util

Table based Parms Handler

Parm(Parm.PS, String, String, String, String) - Constructor for class com.psec.util.Parm

Parm instance constructor.

Parm.Brief - Class in com.psec.util

Brief base class used by PSEC routines.

Parm.MainRun - Interface in com.psec.util

The interface class to be implemented by the class that is to be called by the mainStart method.

Parm.Opt - Class in com.psec.util

Base class for option set.

Parm.PS - Interface in com.psec.util

Interface used to process each option.

printHelp(Parm[], String) - Static method in class com.psec.util.Parm

List the options.

R

ReadCounts() - Constructor for class com.psec.run.DemoExcel.ReadCounts

readExcel(String, Class<ReadExcelRecord>) - Method in class com.psec.excel.ReadExcelFile

Iterate across a sheet and selectively create a set of readExcelRecord instances, one for each row selected.

ReadExcelFile - Class in com.psec.excel

The ReadExcelFile class opens an existing Workbook with one or more Sheets.

ReadExcelFile() - Constructor for class com.psec.excel.ReadExcelFile

ReadExcelFile.ColMap - Class in com.psec.excel

The ColMap class describes a single column used internally as part of the readExcel method processing.

ReadExcelRecord - Class in com.psec.excel

The ReadExcelRecord class in combination with the ReadExcelFile class method readExcel or readExcelSmart is used to iterate through a Workbook sheet.

ReadExcelRecord() - Constructor for class com.psec.excel.ReadExcelRecord

ReadExcelRecord.Note - Class in com.psec.excel

Used internally in the WriteExcel clone operation

readExcelSmart(String, Class<?>, int, boolean) - Method in class com.psec.excel.ReadExcelFile

Iterate across a sheet and selectively create a set of readExcelRecord instances, one for each row selected.

refreshCell(String, int, int) - Method in class com.psec.excel.WriteExcel

Refresh the calculated value in a specific Cell.

refreshCells() - Method in class com.psec.excel.WriteExcel

Refresh the calculated values of all cells.

run(Parm.Opt) - Method in class com.psec.run.DemoExcel

run(String[]) - Method in class com.psec.run.HelloExcel

run(String[]) - Method in class com.psec.run.HelloExcelNHN

run(Parm.Opt) - Method in class com.psec.run.TestArgsPowerShell

run(Parm.Opt) - Method in interface com.psec.util.Parm.MainRun

run method called by mainStart.

S

sBrief - Variable in class com.psec.util.Parm.Opt

Fully qualified name of Brief file.

sCondCode - Variable in class com.psec.util.Parm.Brief

Final condition.

selfIntro(Object) - Method in class com.psec.util.Parm.Opt

Print to System.out standard introductory line.

set(String) - Method in interface com.psec.util.Parm.PS

The set method is used to move (and possibly transform) the sNext value to the static Parm.Opt object instance being constructed.

setBrief(Parm.Brief) - Method in class com.psec.util.Parm.Opt

Set the internal oBrief value to paramater oBrief value.

setNegativeFormat(boolean, String) - Method in class com.psec.excel.WriteExcel

Set how negative numbers are displayed.

sMon - Variable in class com.psec.run.DemoExcel.ReadCounts

sName - Variable in class com.psec.excel.ReadExcelFile.ColMap

The name of the field in the extended ReadExcelRecord class

sReason - Variable in class com.psec.util.Parm.Brief

Reason for failure.

T

TestArgsPowerShell - Class in com.psec.run

Used by the PSEC utility to exercise the parameter passing functions.

TestArgsPowerShell() - Constructor for class com.psec.run.TestArgsPowerShell

W

writeArea() - Method in class com.psec.excel.WriteExcel.Area

Writes the Area to sCurrent sheet.

WriteExcel - Class in com.psec.excel

The WriteExcel class creates a Workbook with one or more Sheets.

WriteExcel() - Constructor for class com.psec.excel.WriteExcel

WriteExcel.Area - Class in com.psec.excel

Used to specify the contents of a portion of a Sheet.

Z

zapCell(String, int, int, String) - Method in class com.psec.excel.WriteExcel

Make changes to specified Cell data with the CellStyle determined according to sVal.

zapCell(String, int, int, String, boolean) - Method in class com.psec.excel.WriteExcel

Make changes to specified Cell data with optional CellStyle preservation.

zapColText(int, int, String) - Method in class com.psec.excel.WriteExcel.Area

Changes the column text for nHdr and nCol.

zapHdrFmt(int, int, String) - Method in class com.psec.excel.WriteExcel.Area

Changes the header format specifier for the specified nHdr and nCol.

zapHdrText(int, int, String) - Method in class com.psec.excel.WriteExcel.Area

Changes the header text for the specified nHdr and nCol.

A B C D E G H I L M N O P R S T W Z