Logo Search packages:      
Sourcecode: jexcelapi version File versions  Download package

jxl::write::biff::WritableSheetImpl Class Reference

Inheritance diagram for jxl::write::biff::WritableSheetImpl:

jxl::write::WritableSheet jxl::Sheet

List of all members.


Detailed Description

A writable sheet. This class contains implementation of all the writable sheet methods which may be invoke by the API

Definition at line 87 of file WritableSheetImpl.java.


Public Member Functions

void addCell (WritableCell cell) throws WriteException, RowsExceededException
void addColumnPageBreak (int col)
void addHyperlink (WritableHyperlink h) throws WriteException, RowsExceededException
void addImage (WritableImage image)
void addRowPageBreak (int row)
Cell findCell (Pattern pattern, int firstCol, int firstRow, int lastCol, int lastRow, boolean reverse)
Cell findCell (Pattern pattern, int firstCol, int firstRow, int lastCol, int lastRow, boolean reverse)
Cell findCell (String contents, int firstCol, int firstRow, int lastCol, int lastRow, boolean reverse)
Cell findCell (String contents)
LabelCell findLabelCell (String contents)
Cell getCell (int column, int row)
Cell getCell (String loc)
Cell[] getColumn (int col)
CellFormat getColumnFormat (int col)
int[] getColumnPageBreaks ()
int getColumns ()
CellView getColumnView (int col)
int getColumnWidth (int col)
DataValidation getDataValidation ()
Image getDrawing (int i)
Hyperlink[] getHyperlinks ()
WritableImage getImage (int i)
Range[] getMergedCells ()
String getName ()
int getNumberOfImages ()
Cell[] getRow (int row)
int getRowHeight (int row)
int[] getRowPageBreaks ()
int getRows ()
CellView getRowView (int row)
SheetSettings getSettings ()
WritableCell getWritableCell (int column, int row)
WritableCell getWritableCell (String loc)
WritableHyperlink[] getWritableHyperlinks ()
void insertColumn (int col)
void insertRow (int row)
boolean isHidden ()
boolean isProtected ()
Range mergeCells (int col1, int row1, int col2, int row2) throws WriteException, RowsExceededException
void removeColumn (int col)
void removeHyperlink (WritableHyperlink h, boolean preserveLabel)
void removeHyperlink (WritableHyperlink h)
void removeImage (WritableImage wi)
void removeRow (int row)
void setColumnGroup (int col1, int col2, boolean collapsed) throws WriteException, RowsExceededException
void setColumnView (int col, CellView view)
void setColumnView (int col, int width, CellFormat format)
void setColumnView (int col, int width)
void setFooter (String l, String c, String r)
void setHeader (String l, String c, String r)
void setHidden (boolean h)
void setName (String n)
void setPageSetup (PageOrientation p, PaperSize ps, double hm, double fm)
void setPageSetup (PageOrientation p, double hm, double fm)
void setPageSetup (PageOrientation p)
void setProtected (boolean prot)
void setRowGroup (int row1, int row2, boolean collapsed) throws WriteException, RowsExceededException
void setRowView (int row, CellView view) throws RowsExceededException
void setRowView (int row, int height, boolean collapsed) throws RowsExceededException
void setRowView (int row, boolean collapsed) throws RowsExceededException
void setRowView (int row, int height) throws RowsExceededException
void setSelected ()
void unmergeCells (Range r)
void unsetColumnGroup (int col1, int col2) throws WriteException, RowsExceededException
void unsetRowGroup (int row1, int row2) throws WriteException, RowsExceededException
 WritableSheetImpl (String n, File of, FormattingRecords fr, SharedStrings ss, WorkbookSettings ws, WritableWorkbookImpl ww)
void write () throws IOException

Package Functions

void addDrawing (DrawingGroupObject o)
void addValidationCell (CellValue cv)
void checkMergedBorders ()
void copy (WritableSheet s)
void copy (Sheet s)
Chart[] getCharts ()
ColumnInfoRecord getColumnInfo (int c)
ComboBox getComboBox ()
final FooterRecord getFooter ()
final HeaderRecord getHeader ()
RowRecord getRowInfo (int r)
RowRecord getRowRecord (int row) throws RowsExceededException
WritableWorkbookImpl getWorkbook ()
WorkbookSettings getWorkbookSettings ()
void importSheet (Sheet s)
boolean isChartOnly ()
void rationalize (IndexMapping xfMapping, IndexMapping fontMapping, IndexMapping formatMapping)
void removeDataValidation (CellValue cv)
void removeDrawing (DrawingGroupObject o)
void setComboBox (ComboBox cb)

Private Member Functions

void autosizeColumn (int col)
void autosizeColumns ()
DrawingGroupObject[] getDrawings ()
WorkspaceInformationRecord getWorkspaceOptions ()
String validateName (String n)

Private Attributes

AutoFilter autoFilter
TreeSet autosizedColumns
ButtonPropertySetRecord buttonPropertySet
boolean chartOnly
ArrayList columnBreaks
TreeSet columnFormats
ComboBox comboBox
ArrayList conditionalFormats
DataValidation dataValidation
ArrayList drawings
boolean drawingsModified
FormattingRecords formatRecords
ArrayList hyperlinks
ArrayList images
int maxColumnOutlineLevel
int maxRowOutlineLevel
MergedCells mergedCells
String name
int numColumns
int numRows
File outputFile
PLSRecord plsRecord
ArrayList rowBreaks
RowRecord[] rows
SheetSettings settings
SharedStrings sharedStrings
SheetWriter sheetWriter
ArrayList validatedCells
WritableWorkbookImpl workbook
WorkbookSettings workbookSettings

Static Private Attributes

static final char[] illegalSheetNameCharacters
static final String[] imageTypes = new String[] {"png"}
static Logger logger = Logger.getLogger(WritableSheetImpl.class)
static final int maxSheetNameLength = 31
static final int numRowsPerSheet = 65536
static final int rowGrowSize = 10

Classes

class  ColumnInfoComparator

The documentation for this class was generated from the following file:

Generated by  Doxygen 1.6.0   Back to index