com.psec.run

Class DemoExcel.ReadCounts

java.lang.Object

com.psec.excel.ReadExcelRecord

com.psec.run.DemoExcel.ReadCounts

Enclosing class:

DemoExcel

public static class DemoExcel.ReadCounts
extends ReadExcelRecord

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

It exercises some functions not covered elsewhere and is thus part of the regression test.

Nested Class Summary

Nested classes/interfaces inherited from class com.psec.excel.ReadExcelRecord

ReadExcelRecord.Note

Field Summary

Fields

Modifier and Type	Field and Description
int	nMtg1
int	nMtg2
java.lang.String	sMon

Fields inherited from class com.psec.excel.ReadExcelRecord

oCM, oRow

Constructor Summary

Constructors

Constructor and Description
ReadCounts()

Method Summary

Modifier and Type	Method and Description
boolean	canAccept() This function can be changed to be selective as to what rows are included in the Row set.
java.lang.String[]	getColMap() The ColMap string definition is returned.

Methods inherited from class java.lang.Object

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

Field Detail

sMon

public java.lang.String sMon

nMtg1

public int nMtg1

nMtg2

public int nMtg2

Constructor Detail

ReadCounts

public ReadCounts()

Method Detail

getColMap

public java.lang.String[] getColMap()

Description copied from class: ReadExcelRecord

The ColMap string definition is returned.

The ColMap is an array of strings. Each string describes a group of cells that are mapped into the fields of the extended ReadExcelRecord instance.

The format of each string is

n1=field1;n2=field2;....;nn=fieldn

where

• nx - the absolute column number relative to 0
• fieldx - the field within ReadExcelRecord to populate with the value
• ; - separates each fild definition

Typically each set of fields is separated by a "/" so the example creates 3 columns (1, 7, 13) on each row where values are inspected.

"1=fldA;2=fldB;4=fldC/5=fldA;6=fldB;8=fldC/13=fldA;14=fldB;16=fldC".split("/");

Specified by:

getColMap in class ReadExcelRecord

canAccept

public boolean canAccept()
                  throws java.lang.Exception

Description copied from class: ReadExcelRecord

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

Overrides:

canAccept in class ReadExcelRecord

Throws:

java.lang.Exception