|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object jxl.write.WritableWorkbook
A writable workbook
Field Summary | |
static WritableFont |
ARIAL_10_PT
The default font for Cell formats |
static WritableFont |
HYPERLINK_FONT
The font used for hyperlinks |
static WritableCellFormat |
HYPERLINK_STYLE
The style used for hyperlinks |
static WritableCellFormat |
NORMAL_STYLE
The default style for cells |
Method Summary | |
abstract void |
close()
Closes this workbook, and makes any memory allocated available for garbage collection. |
abstract void |
copySheet(int s,
java.lang.String name,
int index)
Copies the specified sheet and places it at the index specified by the parameter |
abstract void |
copySheet(java.lang.String s,
java.lang.String name,
int index)
Copies the specified sheet and places it at the index specified by the parameter |
abstract WritableSheet |
createSheet(java.lang.String name,
int index)
Creates, and returns a worksheet at the specified position with the specified name If the index specified is less than or equal to zero, the new sheet is created at the beginning of the workbook. |
abstract int |
getNumberOfSheets()
Returns the number of sheets in this workbook |
abstract WritableSheet |
getSheet(int index)
Gets the specified sheet within this workbook |
abstract WritableSheet |
getSheet(java.lang.String name)
Gets the sheet with the specified name from within this workbook |
abstract WritableSheet[] |
getSheets()
Gets the sheets within this workbook. |
abstract WritableSheet |
moveSheet(int fromIndex,
int toIndex)
Moves the specified sheet within this workbook to another index position. |
abstract void |
removeSheet(int index)
Removes the sheet at the specified index from this workbook |
abstract void |
setColourRGB(Colour c,
int r,
int g,
int b)
Sets the RGB value for the specified colour for this workbook |
abstract void |
setProtected(boolean prot)
Indicates whether or not this workbook is protected |
abstract void |
write()
Writes out the data held in this workbook in Excel format |
Methods inherited from class java.lang.Object |
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
public static final WritableFont ARIAL_10_PT
public static WritableFont HYPERLINK_FONT
public static WritableCellFormat HYPERLINK_STYLE
public static final WritableCellFormat NORMAL_STYLE
Method Detail |
public abstract void close() throws java.io.IOException
java.io.IOException
public abstract void copySheet(int s, java.lang.String name, int index)
s
- the index of the sheet to copyname
- the name of the new sheetindex
- the position of the new sheetpublic abstract void copySheet(java.lang.String s, java.lang.String name, int index)
s
- the name of the sheet to copyname
- the name of the new sheetindex
- the position of the new sheetpublic abstract WritableSheet createSheet(java.lang.String name, int index)
name
- index
- public abstract int getNumberOfSheets()
public abstract WritableSheet getSheet(int index) throws java.lang.IndexOutOfBoundsException
index
- the zero based index of the reQuired sheet
IndexOutOfBoundException
- when index refers to a non-existent
sheet
java.lang.IndexOutOfBoundsException
public abstract WritableSheet getSheet(java.lang.String name)
name
- the sheet name
public abstract WritableSheet[] getSheets()
public abstract WritableSheet moveSheet(int fromIndex, int toIndex)
fromIndex
- the zero based index of the required sheettoIndex
- the zero based index of the required sheet
public abstract void removeSheet(int index)
index
- public abstract void setColourRGB(Colour c, int r, int g, int b)
c
- the colour whose RGB value is to be overwrittenr
- the red portion to set (0-255)g
- the green portion to set (0-255)b
- the blue portion to set (0-255)public abstract void setProtected(boolean prot)
prot
- Protected flagpublic abstract void write() throws java.io.IOException
java.io.IOException
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |