A C D E F G H I L M P R S T V W 
All Classes All Packages

A

addPicture(int, int, byte[], int) - Method in class taro.spreadsheet.model.SpreadsheetTab
 
addPicture(String, byte[], int) - Method in class taro.spreadsheet.model.SpreadsheetTab
 
addSpacer() - Method in class taro.spreadsheet.model.SpreadsheetTab
 
apply(SpreadsheetCellStyle) - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
Returns a new style that applies the given style to this one, ignoring all null fields.
apply(SpreadsheetFont) - Method in class taro.spreadsheet.model.SpreadsheetFont
 
applyStyle(SpreadsheetCellStyle) - Method in class taro.spreadsheet.model.SpreadsheetCell
Applies the given style to the current style for this cell, meaning non-null fields on the given style will be set on this cell's style, but null fields will be ignored.
ARIAL - taro.spreadsheet.model.Fonts
 
autosizeCols() - Method in class taro.spreadsheet.model.SpreadsheetTab
 
autoSizeRow(int) - Method in class taro.spreadsheet.model.SpreadsheetTab
 
autosizeRows() - Method in class taro.spreadsheet.model.SpreadsheetTab
 
autosizeRowsAndCols() - Method in class taro.spreadsheet.model.SpreadsheetTab
 

C

CENTER - Static variable in class taro.spreadsheet.model.SpreadsheetCellStyle
 
CENTER_ONE_DECIMAL - Static variable in class taro.spreadsheet.model.SpreadsheetCellStyle
 
COLOR_BAD - Static variable in class taro.spreadsheet.model.SpreadsheetCellStyle
 
COLOR_GOOD - Static variable in class taro.spreadsheet.model.SpreadsheetCellStyle
 
COLOR_NEUTRAL - Static variable in class taro.spreadsheet.model.SpreadsheetCellStyle
 
COLOR_NOTE - Static variable in class taro.spreadsheet.model.SpreadsheetCellStyle
 
computeRowHeightInPoints(int, int) - Method in class taro.spreadsheet.model.SpreadsheetTab
 
copy() - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
copy() - Method in class taro.spreadsheet.model.SpreadsheetFont
 
createTab(String) - Method in class taro.spreadsheet.model.SpreadsheetWorkbook
 

D

DEFAULT - Static variable in class taro.spreadsheet.model.SpreadsheetCellStyle
 

E

equals(Object) - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
equals(Object) - Method in class taro.spreadsheet.model.SpreadsheetFont
 

F

Fonts - Enum in taro.spreadsheet.model
Created by dgautier on 2/24/2015.

G

getAlign() - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
getBackgroundColor() - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
getBold() - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
getBold() - Method in class taro.spreadsheet.model.SpreadsheetFont
 
getBottomBorder() - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
getBottomBorderColor() - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
getCell(int, int) - Method in class taro.spreadsheet.model.SpreadsheetTab
 
getCell(int, int) - Method in class taro.spreadsheet.SpreadsheetReader
 
getCell(String) - Method in class taro.spreadsheet.model.SpreadsheetTab
 
getCell(String) - Method in class taro.spreadsheet.SpreadsheetReader
 
getCellAddress(int, int) - Static method in class taro.spreadsheet.model.SpreadsheetTab
 
getCellAddress(int, int) - Static method in class taro.spreadsheet.SpreadsheetReader
 
getCellStyles() - Method in class taro.spreadsheet.model.SpreadsheetWorkbook
 
getCellType(int, int) - Method in class taro.spreadsheet.SpreadsheetReader
 
getColumnIndex(String) - Static method in class taro.spreadsheet.SpreadsheetReader
Gets the 0-based index (used by POI) of the column given a cellId in Excel notation, which must be one or more letters (case-insensitive) followed by an integer.
getColWidth(int) - Method in class taro.spreadsheet.model.SpreadsheetTab
In (1/256th of a character width)
getDataFormatString() - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
getDateValue(int, int) - Method in class taro.spreadsheet.SpreadsheetReader
Returns the Date content of the cell, or null if the cell doesn't exist or is empty.
getDateValue(String) - Method in class taro.spreadsheet.SpreadsheetReader
 
getDateValue(Cell) - Method in class taro.spreadsheet.SpreadsheetReader
 
getDoubleUnderline() - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
getDoubleUnderline() - Method in class taro.spreadsheet.model.SpreadsheetFont
 
getFont() - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
getFontName() - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
getFontName() - Method in class taro.spreadsheet.model.SpreadsheetFont
 
getFontOffset() - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
getFontOffset() - Method in class taro.spreadsheet.model.SpreadsheetFont
 
getFonts() - Method in class taro.spreadsheet.model.SpreadsheetWorkbook
 
getFontSizeInPoints() - Method in class taro.spreadsheet.model.SpreadsheetCell
 
getFontSizeInPoints() - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
getFontSizeInPoints() - Method in class taro.spreadsheet.model.SpreadsheetFont
 
getIndention() - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
getItalic() - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
getItalic() - Method in class taro.spreadsheet.model.SpreadsheetFont
 
getLeftBorder() - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
getLeftBorderColor() - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
getLocked() - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
getNumCols(int) - Method in class taro.spreadsheet.SpreadsheetReader
 
getNumericValue(int, int) - Method in class taro.spreadsheet.SpreadsheetReader
Returns the numeric content of the cell, or 0 if the cell doesn't exist or is empty.
getNumericValue(String) - Method in class taro.spreadsheet.SpreadsheetReader
Returns the numeric content of the cell, or 0 if the cell doesn't exist or is empty.
getNumericValue(Cell) - Method in class taro.spreadsheet.SpreadsheetReader
 
getNumRows() - Method in class taro.spreadsheet.SpreadsheetReader
 
getOrCreateCell(int, int) - Method in class taro.spreadsheet.model.SpreadsheetTab
 
getOrCreateCell(String) - Method in class taro.spreadsheet.model.SpreadsheetTab
 
getOrCreateFont() - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
getPoiCell() - Method in class taro.spreadsheet.model.SpreadsheetCell
 
getPoiSheet() - Method in class taro.spreadsheet.model.SpreadsheetTab
 
getPoiSheet() - Method in class taro.spreadsheet.SpreadsheetReader
 
getPoiWorkbook() - Method in class taro.spreadsheet.model.SpreadsheetWorkbook
 
getRightBorder() - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
getRightBorderColor() - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
getRotation() - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
getRowHeight(int) - Method in class taro.spreadsheet.model.SpreadsheetTab
In twips (1/20th of a point)
getRowIndex(String) - Static method in class taro.spreadsheet.SpreadsheetReader
Gets the 0-based index (used by POI) of the row given a cellId in Excel notation, which must be one or more letters (case-insensitive) followed by an integer.
getSheetName() - Method in class taro.spreadsheet.SpreadsheetReader
 
getStrikeout() - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
getStrikeout() - Method in class taro.spreadsheet.model.SpreadsheetFont
 
getStringValue(int, int) - Method in class taro.spreadsheet.SpreadsheetReader
Returns the trimmed content of the cell as a String, or an empty String if the cell doesn't exist or is empty.
getStringValue(String) - Method in class taro.spreadsheet.SpreadsheetReader
Returns the trimmed content of the cell as a String, or an empty String if the cell doesn't exist or is empty.
getStringValue(Cell) - Method in class taro.spreadsheet.SpreadsheetReader
Returns the trimmed content of the cell as a String, or an empty String if the cell doesn't exist or is empty.
getStyle() - Method in class taro.spreadsheet.model.SpreadsheetCell
 
getTab() - Method in class taro.spreadsheet.model.SpreadsheetCell
 
getTab(int) - Method in class taro.spreadsheet.model.SpreadsheetWorkbook
 
getTab(String) - Method in class taro.spreadsheet.model.SpreadsheetWorkbook
 
getTopBorder() - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
getTopBorderColor() - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
getUnderline() - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
getUnderline() - Method in class taro.spreadsheet.model.SpreadsheetFont
 
getValue() - Method in class taro.spreadsheet.model.SpreadsheetCell
 
getValue(int, int) - Method in class taro.spreadsheet.SpreadsheetReader
Attempts to convert all values to a string.
getValue(String) - Method in class taro.spreadsheet.SpreadsheetReader
Attempts to convert all values to a string.
getValue(Cell) - Method in class taro.spreadsheet.SpreadsheetReader
Attempts to convert all values to a string.
getVerticalAlign() - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
getWrapText() - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 

H

hashCode() - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
hashCode() - Method in class taro.spreadsheet.model.SpreadsheetFont
 
HEADER - Static variable in class taro.spreadsheet.model.SpreadsheetCellStyle
 

I

isHidden() - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
isNumeric(int, int) - Method in class taro.spreadsheet.SpreadsheetReader
 
isString(int, int) - Method in class taro.spreadsheet.SpreadsheetReader
 

L

LEFT - Static variable in class taro.spreadsheet.model.SpreadsheetCellStyle
 

M

mergeCells(int, int, int, int, Object, SpreadsheetCellStyle) - Method in class taro.spreadsheet.model.SpreadsheetTab
 
mergeCells(String, String, Object, SpreadsheetCellStyle) - Method in class taro.spreadsheet.model.SpreadsheetTab
 

P

printAcross(int, int, SpreadsheetCellStyle, Object...) - Method in class taro.spreadsheet.model.SpreadsheetTab
Returns the index of the next col after the last one written.
printAcross(String, SpreadsheetCellStyle, String...) - Method in class taro.spreadsheet.model.SpreadsheetTab
 
printDown(int, int, SpreadsheetCellStyle, Object...) - Method in class taro.spreadsheet.model.SpreadsheetTab
Returns the index of the next row after the last one written
printDown(String, SpreadsheetCellStyle, String...) - Method in class taro.spreadsheet.model.SpreadsheetTab
 

R

readAcross(String, int) - Method in class taro.spreadsheet.SpreadsheetReader
 
readAcrossNumeric(String, int) - Method in class taro.spreadsheet.SpreadsheetReader
 
readAcrossUntilBlank(String) - Method in class taro.spreadsheet.SpreadsheetReader
 
readDown(String, int) - Method in class taro.spreadsheet.SpreadsheetReader
 
readDownNumeric(String, int) - Method in class taro.spreadsheet.SpreadsheetReader
 
readDownUntilBlank(String) - Method in class taro.spreadsheet.SpreadsheetReader
 
readSheet() - Method in class taro.spreadsheet.SpreadsheetReader
 
registerStyle(SpreadsheetCellStyle) - Method in class taro.spreadsheet.model.SpreadsheetTab
 
registerStyle(SpreadsheetCellStyle) - Method in class taro.spreadsheet.model.SpreadsheetWorkbook
 
RIGHT - Static variable in class taro.spreadsheet.model.SpreadsheetCellStyle
 
rowHasData(int) - Method in class taro.spreadsheet.SpreadsheetReader
 

S

setBottomBorder(int, int, int, BorderStyle) - Method in class taro.spreadsheet.model.SpreadsheetTab
 
setColWidth(int, int) - Method in class taro.spreadsheet.model.SpreadsheetTab
In (1/256th of a character width)
setLeftBorder(int, int, int, BorderStyle) - Method in class taro.spreadsheet.model.SpreadsheetTab
 
setRightBorder(int, int, int, BorderStyle) - Method in class taro.spreadsheet.model.SpreadsheetTab
 
setRowHeight(int, int) - Method in class taro.spreadsheet.model.SpreadsheetTab
In twips (1/20th of a point)
setStyle(int, int, int, int, SpreadsheetCellStyle) - Method in class taro.spreadsheet.model.SpreadsheetTab
 
setStyle(int, int, SpreadsheetCellStyle) - Method in class taro.spreadsheet.model.SpreadsheetTab
 
setStyle(String, String, SpreadsheetCellStyle) - Method in class taro.spreadsheet.model.SpreadsheetTab
 
setStyle(String, SpreadsheetCellStyle) - Method in class taro.spreadsheet.model.SpreadsheetTab
 
setStyle(SpreadsheetCellStyle) - Method in class taro.spreadsheet.model.SpreadsheetCell
 
setSurroundBorder(int, int, int, int, BorderStyle) - Method in class taro.spreadsheet.model.SpreadsheetTab
 
setSurroundBorder(String, String, BorderStyle) - Method in class taro.spreadsheet.model.SpreadsheetTab
 
setTopBorder(int, int, int, BorderStyle) - Method in class taro.spreadsheet.model.SpreadsheetTab
 
setValue(int, int, Object) - Method in class taro.spreadsheet.model.SpreadsheetTab
 
setValue(int, int, Object, SpreadsheetCellStyle) - Method in class taro.spreadsheet.model.SpreadsheetTab
 
setValue(Object) - Method in class taro.spreadsheet.model.SpreadsheetCell
 
setValue(String, Object) - Method in class taro.spreadsheet.model.SpreadsheetTab
 
setValue(String, Object, SpreadsheetCellStyle) - Method in class taro.spreadsheet.model.SpreadsheetTab
 
SpreadsheetCell - Class in taro.spreadsheet.model
 
SpreadsheetCellStyle - Class in taro.spreadsheet.model
 
SpreadsheetCellStyle() - Constructor for class taro.spreadsheet.model.SpreadsheetCellStyle
 
SpreadsheetFont - Class in taro.spreadsheet.model
 
SpreadsheetFont() - Constructor for class taro.spreadsheet.model.SpreadsheetFont
 
SpreadsheetReader - Class in taro.spreadsheet
Very simple utility to help read a POI sheet within an Excel (.xlsx) file.
SpreadsheetReader(Sheet) - Constructor for class taro.spreadsheet.SpreadsheetReader
 
SpreadsheetTab - Class in taro.spreadsheet.model
 
SpreadsheetWorkbook - Class in taro.spreadsheet.model
 
SpreadsheetWorkbook() - Constructor for class taro.spreadsheet.model.SpreadsheetWorkbook
 
SpreadsheetWorkbook(InputStream) - Constructor for class taro.spreadsheet.model.SpreadsheetWorkbook
 
SpreadsheetWorkbook(OPCPackage) - Constructor for class taro.spreadsheet.model.SpreadsheetWorkbook
 
SpreadsheetWorkbook(XSSFWorkbook) - Constructor for class taro.spreadsheet.model.SpreadsheetWorkbook
 
SUBTITLE - Static variable in class taro.spreadsheet.model.SpreadsheetCellStyle
 

T

taro - package taro
 
taro.spreadsheet - package taro.spreadsheet
 
taro.spreadsheet.model - package taro.spreadsheet.model
 
TaroException - Exception in taro
 
TaroException() - Constructor for exception taro.TaroException
 
TaroException(String) - Constructor for exception taro.TaroException
 
TaroException(String, Throwable) - Constructor for exception taro.TaroException
 
TaroException(String, Throwable, boolean, boolean) - Constructor for exception taro.TaroException
 
TaroException(Throwable) - Constructor for exception taro.TaroException
 
TaroSpreadsheetException - Exception in taro.spreadsheet
 
TaroSpreadsheetException() - Constructor for exception taro.spreadsheet.TaroSpreadsheetException
 
TaroSpreadsheetException(String) - Constructor for exception taro.spreadsheet.TaroSpreadsheetException
 
TaroSpreadsheetException(String, Throwable) - Constructor for exception taro.spreadsheet.TaroSpreadsheetException
 
TaroSpreadsheetException(String, Throwable, boolean, boolean) - Constructor for exception taro.spreadsheet.TaroSpreadsheetException
 
TaroSpreadsheetException(Throwable) - Constructor for exception taro.spreadsheet.TaroSpreadsheetException
 
TITLE - Static variable in class taro.spreadsheet.model.SpreadsheetCellStyle
 

V

valueOf(String) - Static method in enum taro.spreadsheet.model.Fonts
Returns the enum constant of this type with the specified name.
values() - Static method in enum taro.spreadsheet.model.Fonts
Returns an array containing the constants of this enum type, in the order they are declared.

W

withAlign(HorizontalAlignment) - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
withBackgroundColor(Color) - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
withBold(Boolean) - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
withBold(Boolean) - Method in class taro.spreadsheet.model.SpreadsheetFont
 
withBottomBorder(BorderStyle) - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
withBottomBorderColor(Color) - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
withDataFormatString(String) - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
withDoubleUnderline(boolean) - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
withDoubleUnderline(Boolean) - Method in class taro.spreadsheet.model.SpreadsheetFont
 
withFont(SpreadsheetFont) - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
withFontName(String) - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
withFontName(String) - Method in class taro.spreadsheet.model.SpreadsheetFont
 
withFontOffset(Integer) - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
withFontOffset(Integer) - Method in class taro.spreadsheet.model.SpreadsheetFont
 
withFontSizeInPoints(Integer) - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
withFontSizeInPoints(Integer) - Method in class taro.spreadsheet.model.SpreadsheetFont
 
withHidden(Boolean) - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
withIndention(Integer) - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
withItalic(Boolean) - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
withItalic(Boolean) - Method in class taro.spreadsheet.model.SpreadsheetFont
 
withLeftBorder(BorderStyle) - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
withLeftBorderColor(Color) - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
withLocked(Boolean) - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
withNumDecimals(int) - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
withRightBorder(BorderStyle) - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
withRightBorderColor(Color) - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
withRotation(Integer) - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
withStrikeout(Boolean) - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
withStrikeout(Boolean) - Method in class taro.spreadsheet.model.SpreadsheetFont
 
withSurroundBorder(BorderStyle) - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
withTopBorder(BorderStyle) - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
withTopBorderColor(Color) - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
withUnderline(boolean) - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
withUnderline(boolean) - Method in class taro.spreadsheet.model.SpreadsheetFont
 
withVerticalAlign(VerticalAlignment) - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
withWrapText(Boolean) - Method in class taro.spreadsheet.model.SpreadsheetCellStyle
 
write(OutputStream) - Method in class taro.spreadsheet.model.SpreadsheetWorkbook
 
A C D E F G H I L M P R S T V W 
All Classes All Packages