jp.ac.tokushima_u.db.media

Class UWorkbook

java.lang.Object

jp.ac.tokushima_u.db.media.UWorkbook

Direct Known Subclasses:

UXLS, UXLSX

public class UWorkbook
extends Object

Field Summary

Fields

Modifier and Type	Field and Description
protected CellStyle	cellStyle_header
protected CellStyle	cellStyle_numeral
protected CellStyle	cellStyle_numeral_3g
protected CellStyle	cellStyle_numeral_3gf1
protected CellStyle	cellStyle_numeral_3gf2
protected CellStyle	cellStyle_numeral_3gf3
protected CellStyle	cellStyle_standard
protected int	cnt_hyperlinks
protected static int	ColumnMaxWidth
protected static int	ColumnMinWidth
protected DataFormat	dataFormat
protected static String	DEFAULT_FONT_NAME
protected static int	DEFAULT_FONT_POINT
protected static int	MaxHyperlinks
protected Workbook	workbook

Constructor Summary

Constructors

Constructor and Description
UWorkbook()

Method Summary

Modifier and Type	Method and Description
void	autoSizeColumn(Sheet sheet, int cols)
Cell	createBlankCell(Row row, int c)
Cell	createBlankCell(Row row, int c, USS.Decoration deco)
protected static CellStyle	createDefaultCellStyle(Workbook book)
Row	createHeader(Sheet sheet, int r, List<USS.UColumn> header)
Row	createHeader(Sheet sheet, int r, String[] header)
Cell	createHeaderCell(Row row, int c, String v)
Cell	createHeaderCell(Row row, int c, String v, USS.Decoration deco)
Cell	createNumericCell(Row row, int c, double v)
Cell	createNumericCell(Row row, int c, double v, USS.Decoration deco)
Cell	createNumericCell(Row row, int c, long v)
Cell	createNumericCell(Row row, int c, long v, USS.Decoration deco)
Row	createRow(Sheet sheet, int r)
Sheet	createSheet(String name)
Cell	createStringCell(Row row, int c, CharSequence v)
Cell	createStringCell(Row row, int c, CharSequence v, USS.Decoration deco)
protected static UObject	getCellObject(Cell cell)
protected static String	getCellString(Cell cell)
static USS	loadAsUSS(File file, int tsheet, int skiprows, String tvalue, int coffset)
static USS	loadAsUSS(InputStream in, int tsheet, int skiprows, String tvalue, int coffset)
boolean	save(File file)
void	setAutoFilter(Sheet sheet, int cols)
void	setDefaultColumnStyle(Sheet sheet, int cols)
void	setHyperlink(Cell cell, String linkto)
boolean	write(OutputStream out)

Methods inherited from class java.lang.Object

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

Field Detail

DEFAULT_FONT_NAME

protected static String DEFAULT_FONT_NAME

DEFAULT_FONT_POINT

protected static int DEFAULT_FONT_POINT

workbook

protected Workbook workbook

cellStyle_standard

protected CellStyle cellStyle_standard

cellStyle_header

protected CellStyle cellStyle_header

cellStyle_numeral

protected CellStyle cellStyle_numeral

cellStyle_numeral_3g

protected CellStyle cellStyle_numeral_3g

cellStyle_numeral_3gf1

protected CellStyle cellStyle_numeral_3gf1

cellStyle_numeral_3gf2

protected CellStyle cellStyle_numeral_3gf2

cellStyle_numeral_3gf3

protected CellStyle cellStyle_numeral_3gf3

dataFormat

protected DataFormat dataFormat

MaxHyperlinks

protected static final int MaxHyperlinks

See Also:

Constant Field Values

cnt_hyperlinks

protected int cnt_hyperlinks

ColumnMinWidth

protected static final int ColumnMinWidth

See Also:

Constant Field Values

ColumnMaxWidth

protected static final int ColumnMaxWidth

See Also:

Constant Field Values

Constructor Detail

UWorkbook

public UWorkbook()

Method Detail

createDefaultCellStyle

protected static CellStyle createDefaultCellStyle(Workbook book)

createSheet

public Sheet createSheet(String name)

setDefaultColumnStyle

public void setDefaultColumnStyle(Sheet sheet,
                                  int cols)

createRow

public Row createRow(Sheet sheet,
                     int r)

createHeader

public Row createHeader(Sheet sheet,
                        int r,
                        String[] header)

createHeader

public Row createHeader(Sheet sheet,
                        int r,
                        List<USS.UColumn> header)

createBlankCell

public Cell createBlankCell(Row row,
                            int c,
                            USS.Decoration deco)

createBlankCell

public Cell createBlankCell(Row row,
                            int c)

createHeaderCell

public Cell createHeaderCell(Row row,
                             int c,
                             String v,
                             USS.Decoration deco)

createHeaderCell

public Cell createHeaderCell(Row row,
                             int c,
                             String v)

createStringCell

public Cell createStringCell(Row row,
                             int c,
                             CharSequence v,
                             USS.Decoration deco)

createStringCell

public Cell createStringCell(Row row,
                             int c,
                             CharSequence v)

createNumericCell

public Cell createNumericCell(Row row,
                              int c,
                              long v,
                              USS.Decoration deco)

createNumericCell

public Cell createNumericCell(Row row,
                              int c,
                              long v)

createNumericCell

public Cell createNumericCell(Row row,
                              int c,
                              double v,
                              USS.Decoration deco)

createNumericCell

public Cell createNumericCell(Row row,
                              int c,
                              double v)

setHyperlink

public void setHyperlink(Cell cell,
                         String linkto)

autoSizeColumn

public void autoSizeColumn(Sheet sheet,
                           int cols)

setAutoFilter

public void setAutoFilter(Sheet sheet,
                          int cols)

save

public boolean save(File file)
             throws IOException

Throws:

IOException

write

public boolean write(OutputStream out)
              throws IOException

Throws:

IOException

getCellString

protected static String getCellString(Cell cell)

getCellObject

protected static UObject getCellObject(Cell cell)

loadAsUSS

public static USS loadAsUSS(InputStream in,
                            int tsheet,
                            int skiprows,
                            String tvalue,
                            int coffset)
                     throws IOException

Throws:

IOException

loadAsUSS

public static USS loadAsUSS(File file,
                            int tsheet,
                            int skiprows,
                            String tvalue,
                            int coffset)
                     throws IOException

Throws:

IOException