com.psec.excel

Class WriteExcel

java.lang.Object

com.psec.excel.WriteExcel

Direct Known Subclasses:

HelloExcel, HelloExcelNHN

public class WriteExcel
extends java.lang.Object

The WriteExcel class creates a Workbook with one or more Sheets. The WriteExcel.Area object is used to provide the columns of data and rows of columns with which to populate the data. CellStyles are provided by default, by column specification or by row.

Multiple Areas can be applied to one sheet and multiple Sheets can be written using multiple Areas.

CellStyles are created using the addStyle or addStyles methods. WriteExcel manages the combinations so only the active combinations are written to the the output Workbook CellStyle registry.

See Also:

WriteExcel description

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	WriteExcel.Area Used to specify the contents of a portion of a Sheet.

Constructor Summary

Constructors

Constructor and Description
WriteExcel()

Method Summary

Modifier and Type	Method and Description
WriteExcel	addCellComment(java.lang.String sSheet, int nRow, int nCol, java.lang.String sText) Adds a Comment to the specified Cell using a fixed Font.
WriteExcel	addCellComment(java.lang.String sSheet, int nRow, int nCol, java.lang.String sText, boolean bFixed) Adds a Comment to the specified Cell with specified Font.
WriteExcel	addDataFormat(java.lang.String sName, java.lang.String sMatcher, java.lang.String sDataFmt) Adds a DataFormat type.
void	addExternalSheet(java.lang.String sSheet, Sheet oS, java.lang.String sPrintArea) This clones the source Sheet into the Workbook being constructed as a Sheet named sSheet.
WriteExcel	addStyleDefn(java.lang.String sName, java.lang.String sStyStr) Registers a named style.
WriteExcel	bookSheet(java.lang.String sName) Creates an empty Sheet called sName.
java.lang.String	cellSummary(Cell oC) Return a stringized summary of the Cell.
void	close() Close the Workbook.
static WriteExcel	create(Workbook oWB) Internal access to Cell manipulation routines.
static WriteExcel	create(WriteExcel oWE, java.lang.String sFileName) Creates an instance of WriteExcel that will write sFileName.
static WriteExcel	create(WriteExcel oWE, java.lang.String sFileName, java.lang.String sSrcName) Create an instance of WriteExcel that will write sFileName and uses sSrcFile as a template file.
WriteExcel.Area	createArea(java.lang.String sSheet) Creates an Area with a base Row and Column of 0 on the specified Sheet.
WriteExcel.Area	createArea(java.lang.String sSheet, int nRow, int nCol) Creates an Area with the specified base Row and Column on the specified Sheet.
void	customExit(CellStyle oCS, java.lang.String sStr) Allow custom modifications to CellStyle.
java.lang.String[]	dumpCellFontCache() Return a stringized summary of the CellStyle Font cache.
java.lang.String[]	dumpCellStyleCache() Return a stringized summary of the CellStyle cache.
java.lang.String[]	getHdrExtras() Gets the standard header builtins styles.
int	getRowCount(java.lang.String sSheet) Gets the Row count on the specified Sheet.
java.lang.String[]	getStdExtras() Gets the standard builtins styles.
java.lang.String	getStrValue(java.lang.String sSheet, int nRow, int nCol) Gets the String value of the specified Cell.
Workbook	getWorkbook() Gets the Workbook being constructed.
void	makeFileLink(java.lang.String sLinkSty, java.lang.String sSheet, int nRow, int nCol, java.lang.String sStr, java.lang.String sFileName) Make File link entry.
void	makeIndexLink(java.lang.String sTargLinkSty, java.lang.String sTargSheet, java.lang.String sIdxName, int nIdxRow, int nIdxCol, java.lang.String sIdxLinkSty) Make index link entry.
void	makeIndexLink(java.lang.String sTargLinkSty, java.lang.String sTargSheet, java.lang.String sIdxName, int nIdxRow, int nIdxCol, java.lang.String sIdxLinkSty, int nIdxLnkRow, int nIdxLnkCol) Make index link entry.
void	makeStdLink(java.lang.String sTargLinkSty, java.lang.String sTargSheet, int nTargRow, int nTargCol, java.lang.String sSrcLinkSty, java.lang.String sSrcSheet, int nSrcRow, int nSrcCol) Make standard link entry.
void	makeUniLink(java.lang.String sLinkSty, java.lang.String sTargSheet, int nTargRow, int nTargCol, java.lang.String sSrcSheet, int nSrcRow, int nSrcCol, java.lang.String sSrcText) Make a one directional link from the source location to the target location.
void	makeUniLink(java.lang.String sLinkSty, java.lang.String sTargSheet, int nTargRow, int nTargCol, java.lang.String sSrcSheet, int nSrcRow, int nSrcCol, java.lang.String sSrcText, int nRows) Make a one directional link from the source location to the target location.
void	makeUrlLink(java.lang.String sLinkSty, java.lang.String sSheet, int nRow, int nCol, java.lang.String sStr, java.lang.String sUrlName) Make URL link entry.
void	refreshCell(java.lang.String sSheet, int nRow, int nCol) Refresh the calculated value in a specific Cell.
void	refreshCells() Refresh the calculated values of all cells.
void	setNegativeFormat(boolean bShowNegAsRed, java.lang.String sNegFmt) Set how negative numbers are displayed.
void	zapCell(java.lang.String sSheet, int nRow, int nCol, java.lang.String sVal) Make changes to specified Cell data with the CellStyle determined according to sVal.
void	zapCell(java.lang.String sSheet, int nRow, int nCol, java.lang.String sVal, boolean bKeepStyle) Make changes to specified Cell data with optional CellStyle preservation.

Methods inherited from class java.lang.Object

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

Constructor Detail

WriteExcel

public WriteExcel()

Method Detail

addCellComment

public WriteExcel addCellComment(java.lang.String sSheet,
                                 int nRow,
                                 int nCol,
                                 java.lang.String sText)
                          throws java.lang.Exception

Adds a Comment to the specified Cell using a fixed Font. The size of the window is calculated based on the text.

This method call should be after the WriteExcel.Area.writeArea() has been issued.

Parameters:

sSheet - The sheet name containing th cell.

nRow - The base 0 row index on the Sheet.

nCol - The base 0 column index on the Row.

sText - The comment text. Use a "\r\n" to cause a line break.

Returns:

WriteExcel for chaining purposes.

Throws:

java.lang.Exception

addCellComment

public WriteExcel addCellComment(java.lang.String sSheet,
                                 int nRow,
                                 int nCol,
                                 java.lang.String sText,
                                 boolean bFixed)
                          throws java.lang.Exception

Adds a Comment to the specified Cell with specified Font. The size of the window is calculated based on the text.

This method call should be after the WriteExcel.Area.writeArea() has been issued.

Parameters:

sSheet - The sheet name containing th cell.

nRow - The base 0 row index on the Sheet.

nCol - The base 0 column index on the Row.

sText - The comment text. Use a "\r\n" to cause a line break.

bFont - The text Font will be fixed if true, otherwise the default proportional font.

Returns:

WriteExcel for chaining purposes.

Throws:

java.lang.Exception

addDataFormat

public WriteExcel addDataFormat(java.lang.String sName,
                                java.lang.String sMatcher,
                                java.lang.String sDataFmt)
                         throws java.lang.Exception

Adds a DataFormat type. DataFormats are matched when data is written to a cell. The value selected is used as the DataFormat seen in an Excel Cell when right clicking on the Cell and selecting Format Cells....

This method call(s) should be made before any Areas are created using the createArea methods.

Examples

The next line of code will display with no decimal points. The ND is the signal. It will match any number of decimals but there must be at least one.

addDataFormat("nodec","^ND-?[0-9]+[.][0-9]+$","0",)

A value of "ND10.333" or "ND-40.1" would select this format;

The next line of code will display with two decimal points and negative coloring. It will match any number of decimals but there must be at least one.

addDataFormat(neg-nodec","^NND-?[0-9]+[.][0-9]+$","0.00;[Red]0.00")

A value of "NND10.333" or "NND-40.1" would select this format;

Parameters:

sName - The DataFormat name. Do not use names starting with "@" as these are internal name. These names are only used in the logs created as style combinations are registered.

sMatcher - The Regex string to match the value being written to the Cell. It should match the entire value.

sDataFmt - The value used as the DataFormat for the CellStyle.

When processing the pattern match, they are executed in the sequence of the calls to method and before any standard DataFormats seen at Standard Types.

The matched Cell data is assumed to be a double or integer with formatting aids such as $ and , puncuation marks and an optional prefix signal.. These are removed when the parsing for the double or integer value takes place.

Thus an alphabetic 'signal' string prefix can be used to coerce the match to select a particular formatting style.

Returns:

WriteExcel for chaining purposes.

Throws:

java.lang.Exception

See Also:

Standard Types., Choosing a Cell Style.

addExternalSheet

public void addExternalSheet(java.lang.String sSheet,
                             Sheet oS,
                             java.lang.String sPrintArea)
                      throws java.lang.Exception

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

This is primarily used to create new Sheets from a template. The source Sheet can be the same Workbook or from a Workbook opened with ReadExcel.

The cloning process prevserves the original column widths, merged cells and formatting.

The Print Area, when specified, will be adjusted to refelect the new Sheet name. All Print Properties in the original Sheet are also transcribed.

Throws:

java.lang.Exception

addStyleDefn

public WriteExcel addStyleDefn(java.lang.String sName,
                               java.lang.String sStyStr)
                        throws java.lang.Exception

Registers a named style. The named style once registered can be referenced as described in Choosing a Cell Style.

Names starting with '#' are builtin Style Names and should not be used unless purposefully overriding a builtin Style Name. They are listed at Builtin Style Names.

Names are case sensitive and can contain alphanumeric characters as well as the - and _ character.

Must be called before calls createArea that reference the Style. Changes to a Style definition will be ignored once it is referenced when a Cell using the style is written to the Workbook.

Parameters:

sName - The name to register.

sStyStr - The cell style orders as described in Cell Style Orders Syntax.

Throws:

java.lang.Exception

See Also:

Builtin Style Names., Choosing a Cell Style.

bookSheet

public WriteExcel bookSheet(java.lang.String sName)
                     throws java.lang.Exception

Creates an empty Sheet called sName.

It can happen that the processing sequence is different than the preferred Sheet sequence in the resulting Workbook. Calling this method allows the Sheet to be created in the desired sequence.

Returns:

WriteExcel for chaining purposes.

Throws:

java.lang.Exception

cellSummary

public java.lang.String cellSummary(Cell oC)
                             throws java.lang.Exception

Return a stringized summary of the Cell. It caches the Style and Font indexes so they can be dumped later. The data value and data format are returned as strings. Used for creating regression test logs.

Parameters:

oC - Cell to examine

Returns:

a summary of the Cell. If oC is null returns null.

Throws:

java.lang.Exception

dumpCellStyleCache

public java.lang.String[] dumpCellStyleCache()
                                      throws java.lang.Exception

Return a stringized summary of the CellStyle cache. Created by the cellSummary method calls and this should be called as the last step.

Returns:

a summary of the CellStyle cache, one for each CellStyle index value.

Throws:

java.lang.Exception

customExit

public void customExit(CellStyle oCS,
                       java.lang.String sStr)

Allow custom modifications to CellStyle. This exit is called if the CellStyle orders contains a CE(...) order.

It allows custom CellStyle changes to be made to the CellStyle being constructed that are not covered by the order set. It is called just prior to caching the CellStyle after all other orders have been processed.

Parameters:

oCS - CellStyle being constructed.

sStr - The string contained in the CE(...) order. This allows different settings based on the string passed in.

dumpCellFontCache

public java.lang.String[] dumpCellFontCache()
                                     throws java.lang.Exception

Return a stringized summary of the CellStyle Font cache. Created by the cellSummary method calls and this should be called as the last step.

Returns:

a summary of the CellStyle font cache, one for each CellStyle font index value.

Throws:

java.lang.Exception

close

public void close()
           throws java.lang.Exception

Close the Workbook. The Workbook is written and the FileOutputStream closed. No further changes can be made.

Throws:

java.lang.Exception

create

public static WriteExcel create(WriteExcel oWE,
                                java.lang.String sFileName)
                         throws java.lang.Exception

Creates an instance of WriteExcel that will write sFileName.

Parameters:

oWE - the parent instance that subclasses WriteExcel;

sFileName - The fully qualified file path and name suitable for use in a FileOutputStrem.

Returns:

The created instance.

Throws:

java.lang.Exception

create

public static WriteExcel create(WriteExcel oWE,
                                java.lang.String sFileName,
                                java.lang.String sSrcName)
                         throws java.lang.Exception

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

Parameters:

oWE - the parent instance that subclasses WriteExcel;

sFileName - The fully qualified file path and name suitable for use in a FileOutputStrem.

sSrcName - The input .xlsx file that is to be used as a template.

Returns:

The created instance.

Throws:

java.lang.Exception

create

public static WriteExcel create(Workbook oWB)

Internal access to Cell manipulation routines. Used in regression testing.

Parameters:

oWB - The Workbook we are accessing

Returns:

WriteExcel in read only mode

createArea

public WriteExcel.Area createArea(java.lang.String sSheet)
                           throws java.lang.Exception

Creates an Area with a base Row and Column of 0 on the specified Sheet. The Sheet is created if it does not exist.

Parameters:

sSheet - The Sheet name for the Area.

Returns:

The created Area.

Throws:

java.lang.Exception

createArea

public WriteExcel.Area createArea(java.lang.String sSheet,
                                  int nRow,
                                  int nCol)
                           throws java.lang.Exception

Creates an Area with the specified base Row and Column on the specified Sheet. The Sheet is created if it does not exist.

Parameters:

sSheet - The Sheet name for the Area.

nRow - The 0 based row index.

nCol - The 0 based column index.

Returns:

The created Area.

Throws:

java.lang.Exception

getHdrExtras

public java.lang.String[] getHdrExtras()

Gets the standard header builtins styles.

Each String returned is of the format #name:stystr where

• name is the style name prefixed with a # to mark it as standard style
• stystr is the string orders as defined in CellStyle orders.

getRowCount

public int getRowCount(java.lang.String sSheet)

Gets the Row count on the specified Sheet.

Parameters:

sSheet - The sheet name to inspect.

Returns:

The count.

getStdExtras

public java.lang.String[] getStdExtras()

Gets the standard builtins styles.

Each String returned is of the format #name:stystr where

• name is the style name prefixed with a # to mark it as standard style
• stystr is the string orders as defined in CellStyle orders.

getStrValue

public java.lang.String getStrValue(java.lang.String sSheet,
                                    int nRow,
                                    int nCol)
                             throws java.lang.Exception

Gets the String value of the specified Cell.

Parameters:

sSheet - The sheet name to inspect.

nRow - The base 0 row index on the Sheet.

nCol - The base 0 column index on the Row.

Returns:

The value as stored in the Cell. It could be null.

Throws:

java.lang.Exception

getWorkbook

public Workbook getWorkbook()
                     throws java.lang.Exception

Gets the Workbook being constructed.

This allows inspection or modifications to be made to the Workbook using the POI library directly. Caution is advised. Calling this method allows the Sheet to be created in the desired sequence.

Returns:

Workbook.

Throws:

java.lang.Exception

makeFileLink

public void makeFileLink(java.lang.String sLinkSty,
                         java.lang.String sSheet,
                         int nRow,
                         int nCol,
                         java.lang.String sStr,
                         java.lang.String sFileName)
                  throws java.lang.Exception

Make File link entry. Creates a link entry that when clicked will open the file using the Windows defaults to find a program to open it with.

The sheet must exist that will be linked before this method can be called.

Parameters:

sTargLinkSty - Style of index to target link. A null value is treated as #lkc.

The builtin #lkc is centered underlined blue. The builtin #lnk is non-centered underlined blue.

Other style values may be used provided they have been added with the addStyleDefn method

sSheet - Source sheet name on which to create link

sIdxRow - Link row on source page.

sIdxCol - Link column on source page.

sStr - The link text

sFileName - The File path passed to the Windows routines.

Throws:

java.lang.Exception

makeIndexLink

public void makeIndexLink(java.lang.String sTargLinkSty,
                          java.lang.String sTargSheet,
                          java.lang.String sIdxName,
                          int nIdxRow,
                          int nIdxCol,
                          java.lang.String sIdxLinkSty)
                   throws java.lang.Exception

Make index link entry. Creates a bi-directional link entry to and from a page called "index".

This method allows for the creation of an index page which is useful in complicated spreadsheets.

The sheet must exist that will be linked before this method can be called. If necessary 'defer' logic should be added to the creating program as sheets are created that need links. The bookSkeet method can be called to position the "index" sheet as the first sheet in the Workbook.

It creates a bi-directional link to the target page from the index page by calling method makeIndexLink with nIdxLnkRow=1 and nIdxLnkCol=1.

Parameters:

sTargLinkSty - Style of index to target link. A null value is treated as #lkc.

The builtin #lkc is centered underlined blue. The builtin #lnk is non-centered underlined blue.

Other style values may be used provided they have been added with the addStyleDefn method

sTargSheet - Sheet name to index

sIdxName - Link name on index page.

sIdxRow - Link row on index page.

sIdxCol - Link column on index page.

sIdxLinkSty - Style of target to index link. A null value will use the sTargLinkSty value or #lkc.

The builtin #lkc is centered underlined blue. The builtin #lnc is non-centered underlined blue.

Other style values may be used provided they have been added with the addStyleDefn method

Throws:

java.lang.Exception

makeIndexLink

public void makeIndexLink(java.lang.String sTargLinkSty,
                          java.lang.String sTargSheet,
                          java.lang.String sIdxName,
                          int nIdxRow,
                          int nIdxCol,
                          java.lang.String sIdxLinkSty,
                          int nIdxLnkRow,
                          int nIdxLnkCol)
                   throws java.lang.Exception

Make index link entry. Creates a bi-directional link entry to and from a page called "index".

This method allows for the creation of an index page which is useful in complicated spreadsheets.

The sheet must exist that will be linked before this method can be called. If necessary 'defer' logic should be added to the creating program as sheets are created that need links. The bookSkeet method can be called to position the "index" sheet as the first sheet in the Workbook.

It creates a bi-directional link to the target page from the index page. It creates the index pointer on the target page at row nIdxLnkRow column nIdxLnkCol.

Parameters:

sTargLinkSty - Style of index to target link. A null value is treated as #lkc.

The builtin #lkc is centered underlined blue. The builtin #lnk is non-centered underlined blue.

Other style values may be used provided they have been added with the addStyleDefn method

sTargSheet - Sheet name to index

sIdxName - Link name on index page.

sIdxRow - Link row on index page.

sIdxCol - Link column on index page.

sIdxLinkSty - Style of target to index link. A null value will use the sTargLinkSty value or #lkc.

The builtin #lkc is centered underlined blue. The builtin #lnc is non-centered underlined blue.

Other style values may be used provided they have been added with the addStyleDefn method

sIdxLnkRow - Link row on target page.

sIdxLnkCol - Link column on target page.

Throws:

java.lang.Exception

makeStdLink

public void makeStdLink(java.lang.String sTargLinkSty,
                        java.lang.String sTargSheet,
                        int nTargRow,
                        int nTargCol,
                        java.lang.String sSrcLinkSty,
                        java.lang.String sSrcSheet,
                        int nSrcRow,
                        int nSrcCol)
                 throws java.lang.Exception

Make standard link entry. Creates a bi-directional link entry between the source and target sheets where The link value is the other sheet name.

The sheets must exist that will be linked before this method can be called. If necessary 'defer' logic should be added to the creating program as sheets are created that need links.

The target and source parameters in this method are commutative.

Parameters:

sTargLinkSty - Style of target to source link. A null value is treated as #lkc.

The builtin #lkc is centered underlined blue. The builtin #lnk is non-centered underlined blue.

Other style values may be used provided they have been added with the addStyleDefn method

sTargSheet - Target Sheet name

sTargRow - Link row on target page.

sTargCol - Link column on target page.

sSrcLinkSty - Style of source to link. A null value is treated as #lkc.

The builtin #lkc is centered underlined blue. The builtin #lnk is non-centered underlined blue.

Other style values may be used provided they have been added with the addStyleDefn method

sSrcSheet - Source Sheet name

sSrcRow - Link row on source page.

sSrcCol - Link column on source page.

Throws:

java.lang.Exception

makeUniLink

public void makeUniLink(java.lang.String sLinkSty,
                        java.lang.String sTargSheet,
                        int nTargRow,
                        int nTargCol,
                        java.lang.String sSrcSheet,
                        int nSrcRow,
                        int nSrcCol,
                        java.lang.String sSrcText)
                 throws java.lang.Exception

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

The sheets must exist that will be linked before this method can be called. If necessary 'defer' logic should be added to the creating program as sheets are created that need links.

Implemented by calling makeUniLink with an nRows value of 1.

Parameters:

sLinkSty - Style of link. A null value is treated as #lkc.

The builtin #lkc is centered underlined blue. The builtin #lnk is non-centered underlined blue.

Other style values may be used provided they have been added with the addStyleDefn method

sTargSheet - Target Sheet name

sTargRow - Link row on target page.

sTargCol - Link column on target page.

sSrcSheet - Source Sheet name

sSrcRow - Link row on source page.

sSrcCol - Link column on source page.

sSrcText - Text value to put in link text on the source sheet.

Throws:

java.lang.Exception

makeUniLink

public void makeUniLink(java.lang.String sLinkSty,
                        java.lang.String sTargSheet,
                        int nTargRow,
                        int nTargCol,
                        java.lang.String sSrcSheet,
                        int nSrcRow,
                        int nSrcCol,
                        java.lang.String sSrcText,
                        int nRows)
                 throws java.lang.Exception

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

The sheets must exist that will be linked before this method can be called. If necessary 'defer' logic should be added to the creating program as sheets are created that need links.

When the link is pressed the target location is selected. Multiple rows are selected if the parameter nRows is greated than 1.

Parameters:

sLinkSty - Style of link. A null value is treated as #lkc.

The builtin #lkc is centered underlined blue. The builtin #lnk is non-centered underlined blue.

Other style values may be used provided they have been added with the addStyleDefn method

sTargSheet - Target Sheet name

sTargRow - Link row on target page.

sTargCol - Link column on target page.

sSrcSheet - Source Sheet name

sSrcRow - Link row on source page.

sSrcCol - Link column on source page.

sSrcText - Text value to put in link text on the source sheet.

nRows - number of rows to select in target location.

Throws:

java.lang.Exception

makeUrlLink

public void makeUrlLink(java.lang.String sLinkSty,
                        java.lang.String sSheet,
                        int nRow,
                        int nCol,
                        java.lang.String sStr,
                        java.lang.String sUrlName)
                 throws java.lang.Exception

Make URL link entry. Creates a link entry that when clicked will open the default browser with the URL as the target address.

The sheet must exist that will be linked before this method can be called.

Parameters:

sTargLinkSty - Style of index to target link. A null value is treated as #lkc.

The builtin #lkc is centered underlined blue. The builtin #lnk is non-centered underlined blue.

Other style values may be used provided they have been added with the addStyleDefn method

sSheet - Source sheet name on which to create link

sIdxRow - Link row on source page.

sIdxCol - Link column on source page.

sStr - The link text

sUrlName - The URL passed to the browser

Throws:

java.lang.Exception

refreshCell

public void refreshCell(java.lang.String sSheet,
                        int nRow,
                        int nCol)

Refresh the calculated value in a specific Cell.

WriteExcel uses the POI library provided FormulaEvaluator to maintain the current values of cells containing formulae. This method invokes the FormulaEvaluator instance for this Workbook for the specific cell.

This should be used if referenced values have been changed before obtaining the current value of a cell that contains calculated values.

If the refenced Cell does not exist this call is ignored.

Parameters:

sSheet - Sheet name

nRow - Row number relative to 0

nCol - Column number relative to 0

refreshCells

public void refreshCells()

Refresh the calculated values of all cells.

WriteExcel uses the POI library provided FormulaEvaluator to maintain the current values of cells containing formulae. This method invokes the FormulaEvaluator instance for this Workbook for all cells.

This should be used if referenced values have been changed before obtaining the current value of a cell that contains calculated values.

setNegativeFormat

public void setNegativeFormat(boolean bShowNegAsRed,
                              java.lang.String sNegFmt)
                       throws java.lang.Exception

Set how negative numbers are displayed. Calling this method determines the default for how negative numbers are displayed.

This can be changed for a specific format using addGenericType with an appropriate signal prefix as shown in the example.

Must be called before calls to addStyles or createArea.

Parameters:

bShowNegAsRed - Negative numbers will also be shown in red

sNegFmt - Valid combinations as shown below:

• null : default variation (color option ignored)
• "" : color option with no prefix
• "-" : - prefix plus color option
• "()" : Paren wrapper plus color option

Throws:

java.lang.Exception

zapCell

public void zapCell(java.lang.String sSheet,
                    int nRow,
                    int nCol,
                    java.lang.String sVal)
             throws java.lang.Exception

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

Parameters:

sSheet - The sheet name containing the cell.

nRow - The base 0 row index on the Sheet.

nCol - The base 0 column index on the Row.

sVal - The replacement Cell text. This is parsed according to format specifier.

Throws:

java.lang.Exception

zapCell

public void zapCell(java.lang.String sSheet,
                    int nRow,
                    int nCol,
                    java.lang.String sVal,
                    boolean bKeepStyle)
             throws java.lang.Exception

Make changes to specified Cell data with optional CellStyle preservation.

Parameters:

sSheet - The sheet name containing the cell.

nRow - The base 0 row index on the Sheet.

nCol - The base 0 column index on the Row.

sVal - The replacement Cell text. This is parsed according to format specifier. This is ignored if bKeepStyle is true.

boolean - bKeepStyle The existing style format is preserved if true. Otherwise a new format is determined according to the parsing of sVal.

Throws:

java.lang.Exception