Package taro.spreadsheet.model

Class SpreadsheetTab

java.lang.Object

taro.spreadsheet.model.SpreadsheetTab

public class SpreadsheetTab
extends Object

Method Summary

Modifier and Type	Method	Description
void	addPicture(int row, int col, byte[] bytes, int pictureType)
void	addPicture(String cellAddress, byte[] bytes, int pictureType)
void	addSpacer()
void	autosizeCols()
void	autoSizeRow(int row)
void	autosizeRows()
void	autosizeRowsAndCols()
float	computeRowHeightInPoints(int fontSizeInPoints, int numLines)
SpreadsheetCell	getCell(int row, int col)
SpreadsheetCell	getCell(String cellAddress)
static String	getCellAddress(int row, int col)
int	getColWidth(int col)	In (1/256th of a character width)
SpreadsheetCell	getOrCreateCell(int row, int col)
SpreadsheetCell	getOrCreateCell(String cellAddress)
org.apache.poi.xssf.usermodel.XSSFSheet	getPoiSheet()
int	getRowHeight(int row)	In twips (1/20th of a point)
void	mergeCells(int firstRow, int lastRow, int firstCol, int lastCol, Object content, SpreadsheetCellStyle style)
void	mergeCells(String firstCell, String lastCell, Object content, SpreadsheetCellStyle style)
int	printAcross(int row, int col, SpreadsheetCellStyle style, Object... values)	Returns the index of the next col after the last one written.
void	printAcross(String cellAddress, SpreadsheetCellStyle style, String... values)
int	printDown(int row, int col, SpreadsheetCellStyle style, Object... values)	Returns the index of the next row after the last one written
void	printDown(String cellAddress, SpreadsheetCellStyle style, String... values)
org.apache.poi.ss.usermodel.CellStyle	registerStyle(SpreadsheetCellStyle style)
void	setBottomBorder(int row, int firstCol, int lastCol, org.apache.poi.ss.usermodel.BorderStyle border)
void	setColWidth(int col, int twips)	In (1/256th of a character width)
void	setLeftBorder(int firstRow, int lastRow, int col, org.apache.poi.ss.usermodel.BorderStyle border)
void	setRightBorder(int firstRow, int lastRow, int col, org.apache.poi.ss.usermodel.BorderStyle border)
void	setRowHeight(int row, int twips)	In twips (1/20th of a point)
void	setStyle(int firstRow, int lastRow, int firstCol, int lastCol, SpreadsheetCellStyle style)
void	setStyle(int row, int col, SpreadsheetCellStyle style)
void	setStyle(String firstCell, String lastCell, SpreadsheetCellStyle style)
void	setStyle(String cellAddress, SpreadsheetCellStyle style)
void	setSurroundBorder(int firstRow, int lastRow, int firstCol, int lastCol, org.apache.poi.ss.usermodel.BorderStyle border)
void	setSurroundBorder(String firstCell, String lastCell, org.apache.poi.ss.usermodel.BorderStyle border)
void	setTopBorder(int row, int firstCol, int lastCol, org.apache.poi.ss.usermodel.BorderStyle border)
void	setValue(int row, int col, Object content)
void	setValue(int row, int col, Object content, SpreadsheetCellStyle style)
void	setValue(String cellAddress, Object content)
void	setValue(String cellAddress, Object content, SpreadsheetCellStyle style)

Methods inherited from class java.lang.Object

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

Method Detail

getCellAddress

public static String getCellAddress(int row,
                                    int col)

setValue

public void setValue(String cellAddress,
                     Object content)

setValue

public void setValue(String cellAddress,
                     Object content,
                     SpreadsheetCellStyle style)

setValue

public void setValue(int row,
                     int col,
                     Object content)

setValue

public void setValue(int row,
                     int col,
                     Object content,
                     SpreadsheetCellStyle style)

setStyle

public void setStyle(String cellAddress,
                     SpreadsheetCellStyle style)

setStyle

public void setStyle(String firstCell,
                     String lastCell,
                     SpreadsheetCellStyle style)

setStyle

public void setStyle(int row,
                     int col,
                     SpreadsheetCellStyle style)

setStyle

public void setStyle(int firstRow,
                     int lastRow,
                     int firstCol,
                     int lastCol,
                     SpreadsheetCellStyle style)

getPoiSheet

public org.apache.poi.xssf.usermodel.XSSFSheet getPoiSheet()

getCell

public SpreadsheetCell getCell(String cellAddress)

getCell

public SpreadsheetCell getCell(int row,
                               int col)

getOrCreateCell

public SpreadsheetCell getOrCreateCell(String cellAddress)

getOrCreateCell

public SpreadsheetCell getOrCreateCell(int row,
                                       int col)

mergeCells

public void mergeCells(String firstCell,
                       String lastCell,
                       Object content,
                       SpreadsheetCellStyle style)

mergeCells

public void mergeCells(int firstRow,
                       int lastRow,
                       int firstCol,
                       int lastCol,
                       Object content,
                       SpreadsheetCellStyle style)

getRowHeight

public int getRowHeight(int row)

In twips (1/20th of a point)

setRowHeight

public void setRowHeight(int row,
                         int twips)

In twips (1/20th of a point)

getColWidth

public int getColWidth(int col)

In (1/256th of a character width)

setColWidth

public void setColWidth(int col,
                        int twips)

In (1/256th of a character width)

autosizeRowsAndCols

public void autosizeRowsAndCols()

autosizeRows

public void autosizeRows()

autosizeCols

public void autosizeCols()

autoSizeRow

public void autoSizeRow(int row)

computeRowHeightInPoints

public float computeRowHeightInPoints(int fontSizeInPoints,
                                      int numLines)

addSpacer

public void addSpacer()

printDown

public void printDown(String cellAddress,
                      SpreadsheetCellStyle style,
                      String... values)

printAcross

public void printAcross(String cellAddress,
                        SpreadsheetCellStyle style,
                        String... values)

printDown

public int printDown(int row,
                     int col,
                     SpreadsheetCellStyle style,
                     Object... values)

Returns the index of the next row after the last one written

printAcross

public int printAcross(int row,
                       int col,
                       SpreadsheetCellStyle style,
                       Object... values)

Returns the index of the next col after the last one written.

setSurroundBorder

public void setSurroundBorder(String firstCell,
                              String lastCell,
                              org.apache.poi.ss.usermodel.BorderStyle border)

setSurroundBorder

public void setSurroundBorder(int firstRow,
                              int lastRow,
                              int firstCol,
                              int lastCol,
                              org.apache.poi.ss.usermodel.BorderStyle border)

setRightBorder

public void setRightBorder(int firstRow,
                           int lastRow,
                           int col,
                           org.apache.poi.ss.usermodel.BorderStyle border)

setLeftBorder

public void setLeftBorder(int firstRow,
                          int lastRow,
                          int col,
                          org.apache.poi.ss.usermodel.BorderStyle border)

setTopBorder

public void setTopBorder(int row,
                         int firstCol,
                         int lastCol,
                         org.apache.poi.ss.usermodel.BorderStyle border)

setBottomBorder

public void setBottomBorder(int row,
                            int firstCol,
                            int lastCol,
                            org.apache.poi.ss.usermodel.BorderStyle border)

registerStyle

public org.apache.poi.ss.usermodel.CellStyle registerStyle(SpreadsheetCellStyle style)

addPicture

public void addPicture(String cellAddress,
                       byte[] bytes,
                       int pictureType)

addPicture

public void addPicture(int row,
                       int col,
                       byte[] bytes,
                       int pictureType)