Package | Description |
---|---|
org.zkoss.zss.api.model |
ZK Spreadsheet Model API classes.
|
org.zkoss.zss.api.model.impl |
ZK Spreadsheet Model API implementation classes, Internal use only
|
org.zkoss.zss.model |
ZK Spreadsheet Internal Book Model classes.
|
org.zkoss.zss.model.impl |
ZK Spreadsheet Internal Book Model Implementation classes.
|
org.zkoss.zss.model.impl.html |
The exporter that convert ZK Spreadsheet to HTML.
|
org.zkoss.zss.model.impl.pdf |
The exporter that convert ZK Spreadsheet to PDF.
|
org.zkoss.zss.model.impl.sys.formula |
ZK Spreadsheet Internal Book Model Implementation classes.
|
org.zkoss.zss.model.sys.formula |
ZK Spreadsheet Internal Book Model Engines classes.
|
org.zkoss.zss.range |
ZK Spreadsheet Internal Range API classes.
|
org.zkoss.zss.range.impl |
ZK Spreadsheet Internal Range API Implementation classes.
|
org.zkoss.zss.range.impl.imexp |
ZK Spreadsheet Internal Range API Implementation classes.
|
org.zkoss.zss.ui |
Defines UI Component class of ZK Spreadsheet
|
org.zkoss.zss.ui.impl |
Classes for implementing ZK Spreadsheet UI Components (implementation only).
|
org.zkoss.zssex.formula |
Classes bridging ZK Spreadsheet formula functions to ZK EL functions.
|
Modifier and Type | Method and Description |
---|---|
SBook |
Book.getInternalBook()
get the internal model object to do advanced operation
Note : operate on internal object will not automatically update Spreadsheet |
Modifier and Type | Field and Description |
---|---|
protected ModelRef<SBook> |
FontImpl._bookRef |
protected ModelRef<SBook> |
CellStyleImpl._bookRef |
Modifier and Type | Method and Description |
---|---|
SBook |
BookImpl.getInternalBook() |
SBook |
BookImpl.getNative() |
Modifier and Type | Method and Description |
---|---|
ModelRef<SBook> |
ColorImpl.getBookRef() |
ModelRef<SBook> |
BookImpl.getRef() |
Constructor and Description |
---|
BookImpl(ModelRef<SBook> ref) |
CellStyleImpl(ModelRef<SBook> book,
ModelRef<SCellStyle> style) |
ColorImpl(ModelRef<SBook> book,
ModelRef<SColor> color) |
EditableCellStyleImpl(ModelRef<SBook> book,
ModelRef<SCellStyle> style) |
EditableFontImpl(ModelRef<SBook> book,
ModelRef<SFont> font) |
FontImpl(ModelRef<SBook> book,
ModelRef<SFont> font) |
SheetImpl(ModelRef<SBook> book,
ModelRef<SSheet> sheet) |
Modifier and Type | Method and Description |
---|---|
static SBook |
SBooks.createBook(java.lang.String bookName)
Create a book with the bookName
|
SBook |
STable.getBook() |
SBook |
SSheet.getBook()
Get the owner book
|
SBook |
SName.getBook() |
SBook |
ModelEvent.getBook() |
SBook |
SBookSeries.getBook(java.lang.String name)
Get the book by name;
|
Modifier and Type | Method and Description |
---|---|
java.util.List<SBook> |
SBookSeries.getBooks()
Gets the books list
|
Modifier and Type | Method and Description |
---|---|
abstract void |
SBookSeriesBuilder.buildBookSeries(SBook... books) |
static ModelEvent |
ModelEvents.createModelEvent(java.lang.String name,
SBook book) |
static ModelEvent |
ModelEvents.createModelEvent(java.lang.String name,
SBook book,
java.util.Map data)
Create a model event.
|
static ModelEvent |
ModelEvents.createModelEvent(java.lang.String name,
SBook book,
SSheet sheet,
java.util.Map data) |
Modifier and Type | Method and Description |
---|---|
abstract void |
SBookSeriesBuilder.buildBookSeries(java.util.Set<SBook> books)
Build a book series that allow external book references can work among specified books
|
Modifier and Type | Class and Description |
---|---|
class |
AbstractBookAdv |
class |
BookImpl |
Modifier and Type | Method and Description |
---|---|
SBook |
TableImpl.getBook() |
SBook |
TableImpl.DummyTable.getBook() |
SBook |
SheetImpl.getBook() |
SBook |
SimpleBookSeriesImpl.getBook(java.lang.String name) |
SBook |
BookSeriesImpl.getBook(java.lang.String name) |
Modifier and Type | Method and Description |
---|---|
java.util.List<SBook> |
SimpleBookSeriesImpl.getBooks() |
java.util.List<SBook> |
BookSeriesImpl.getBooks() |
Modifier and Type | Method and Description |
---|---|
void |
BookSeriesBuilderImpl.buildBookSeries(SBook... books) |
void |
AutoFilterImpl.renameSheet(SBook book,
java.lang.String oldName,
java.lang.String newName) |
abstract void |
AbstractAutoFilterAdv.renameSheet(SBook book,
java.lang.String oldName,
java.lang.String newName) |
Modifier and Type | Method and Description |
---|---|
void |
BookSeriesBuilderImpl.buildBookSeries(java.util.Set<SBook> books) |
Constructor and Description |
---|
NamedStyleImpl(java.lang.String name,
boolean custom,
int builtinId,
SBook book,
int index) |
Modifier and Type | Method and Description |
---|---|
static ToHtml |
ToHtml.create(SBook wb,
java.io.OutputStream output)
Creates a new converter to HTML for the given workbook.
|
void |
HtmlExporter.export(SBook book,
java.io.File file) |
static void |
ToHtml.export(SBook wb,
java.io.OutputStream outputStream) |
void |
HtmlExporter.export(SBook workbook,
java.io.OutputStream outputStream)
Exports ZK Spreadsheet
SBook into another format written to a
OutputStream . |
static void |
ToHtml.export(SBook wb,
java.io.OutputStream outputStream,
boolean noHeader) |
Modifier and Type | Method and Description |
---|---|
void |
PdfExporter.export(SBook book,
java.io.File file) |
void |
PdfExporter.export(SBook workbook,
java.io.OutputStream outputStream)
Exports ZK Spreadsheet
Book into another format written to a
OutputStream . |
Modifier and Type | Method and Description |
---|---|
SBook |
EvalBook.getNBook() |
Modifier and Type | Method and Description |
---|---|
protected FormulaEngineImpl.FormulaAdjuster |
FormulaEngineImpl.getRenameSheetAdjuster(SBook targetBook,
java.lang.String oldSheetName,
java.lang.String newSheetName) |
protected FormulaEngineImpl.FormulaAdjuster |
FormulaEngineImpl.getReorderSheetAdjuster(SBook targetBook,
int oldIndex,
int newIndex) |
FormulaExpression |
FormulaEngineImpl.renameName(java.lang.String formula,
SBook targetBook,
int sheetIndex,
java.lang.String oldName,
java.lang.String newName,
FormulaParseContext context) |
FormulaExpression |
FormulaEngineImpl.renameName(java.lang.String formula,
SBook targetBook,
java.lang.String oldName,
java.lang.String newName,
FormulaParseContext context) |
FormulaExpression |
FormulaEngineImpl.renameNamePtgs(FormulaExpression fe,
SBook targetBook,
int sheetIndex,
java.lang.String oldName,
java.lang.String newName,
FormulaParseContext context) |
FormulaExpression |
FormulaEngineImpl.renameSheet(java.lang.String formula,
SBook targetBook,
java.lang.String oldSheetName,
java.lang.String newSheetName,
FormulaParseContext context) |
FormulaExpression |
FormulaEngineImpl.renameSheetPtgs(FormulaExpression fe,
SBook targetBook,
java.lang.String oldSheetName,
java.lang.String newSheetName,
FormulaParseContext context) |
FormulaExpression |
FormulaEngineImpl.renameTableNameTablePtgs(FormulaExpression fexpr,
SBook book,
java.lang.String oldName,
java.lang.String newName,
FormulaParseContext context) |
FormulaExpression |
FormulaEngineImpl.reorderSheetPtgs(FormulaExpression fexpr,
SBook targetBook,
int oldIndex,
int newIndex,
FormulaParseContext context) |
Constructor and Description |
---|
EvalBook(SBook book) |
ParsingBook(SBook book) |
Modifier and Type | Method and Description |
---|---|
SBook |
FormulaParseContext.getBook() |
SBook |
FormulaEvaluationContext.getBook() |
SBook |
FormulaClearContext.getBook() |
Modifier and Type | Method and Description |
---|---|
org.zkoss.xel.FunctionMapper |
EvaluationContributor.getFunctionMaper(SBook book) |
org.zkoss.xel.VariableResolver |
EvaluationContributor.getVariableResolver(SBook book) |
FormulaExpression |
FormulaEngine.renameName(java.lang.String formula,
SBook book,
int sheetIndex,
java.lang.String oldName,
java.lang.String newName,
FormulaParseContext context) |
FormulaExpression |
FormulaEngine.renameName(java.lang.String formula,
SBook book,
java.lang.String oldName,
java.lang.String newName,
FormulaParseContext context) |
FormulaExpression |
FormulaEngine.renameNamePtgs(FormulaExpression fexpr,
SBook book,
int sheetIndex,
java.lang.String oldName,
java.lang.String newName,
FormulaParseContext context) |
FormulaExpression |
FormulaEngine.renameSheet(java.lang.String formula,
SBook book,
java.lang.String oldName,
java.lang.String newName,
FormulaParseContext context) |
FormulaExpression |
FormulaEngine.renameSheetPtgs(FormulaExpression fexpr,
SBook book,
java.lang.String oldName,
java.lang.String newName,
FormulaParseContext context) |
FormulaExpression |
FormulaEngine.renameTableNameTablePtgs(FormulaExpression fexpr,
SBook book,
java.lang.String oldName,
java.lang.String newName,
FormulaParseContext context) |
FormulaExpression |
FormulaEngine.reorderSheetPtgs(FormulaExpression fexpr,
SBook book,
int oldIndex,
int newIndex,
FormulaParseContext context) |
Constructor and Description |
---|
FormulaClearContext(SBook book) |
FormulaEvaluationContext(SBook book,
Ref dependent) |
FormulaParseContext(SBook book,
Ref dependent) |
FormulaParseContext(SBook book,
SSheet sheet,
SCell cell,
java.lang.String sheetName,
Ref dependent) |
FormulaParseContext(SBook book,
SSheet sheet,
SCell cell,
java.lang.String sheetName,
Ref dependent,
java.util.Locale locale) |
Modifier and Type | Method and Description |
---|---|
SBook |
SImporter.imports(java.io.File file,
java.lang.String bookName)
Import book from a file
|
SBook |
SImporter.imports(java.io.InputStream is,
java.lang.String bookName)
Import book from a input stream
|
SBook |
SImporter.imports(java.net.URL url,
java.lang.String bookName)
Import book from a URL
|
Modifier and Type | Method and Description |
---|---|
void |
SExporter.export(SBook book,
java.io.File file)
Export a book
|
void |
SExporter.export(SBook book,
java.io.OutputStream fos)
Export a book
|
static SRange |
SRanges.range(SBook book)
|
Modifier and Type | Method and Description |
---|---|
static SCellStyle |
StyleUtil.cloneCellStyle(SBook book,
SCellStyle style) |
static SFont |
StyleUtil.getFontStyle(SBook book,
SCellStyle cellStyle,
SCellStyle tbCellStyle) |
void |
NotifyChangeHelper.notifySheetDelete(SBook book,
SSheet deletedSheet,
int deletedIndex) |
static void |
StyleUtil.setBackColor(SBook book,
CellStyleHolder holder,
java.lang.String htmlColor) |
static void |
StyleUtil.setBorder(SBook book,
CellStyleHolder holder,
java.lang.String color,
SBorder.BorderType linestyle) |
static void |
StyleUtil.setBorder(SBook book,
CellStyleHolder holder,
java.lang.String htmlColor,
SBorder.BorderType lineStyle,
short at) |
static void |
StyleUtil.setBorderBottom(SBook book,
CellStyleHolder holder,
java.lang.String color,
SBorder.BorderType linestyle) |
static void |
StyleUtil.setBorderLeft(SBook book,
CellStyleHolder holder,
java.lang.String color,
SBorder.BorderType linestyle) |
static void |
StyleUtil.setBorderRight(SBook book,
CellStyleHolder holder,
java.lang.String color,
SBorder.BorderType linestyle) |
static void |
StyleUtil.setBorderTop(SBook book,
CellStyleHolder holder,
java.lang.String color,
SBorder.BorderType linestyle) |
static void |
StyleUtil.setDataFormat(SBook book,
CellStyleHolder holder,
java.lang.String format) |
static void |
StyleUtil.setFillColor(SBook book,
CellStyleHolder holder,
java.lang.String htmlColor) |
static void |
StyleUtil.setFillOptions(SBook book,
CellStyleHolder holder,
java.lang.String bgColor,
java.lang.String fillColor,
SFill.FillPattern pattern) |
static void |
StyleUtil.setFontBoldWeight(SBook book,
CellStyleHolder holder,
SFont.Boldweight boldWeight) |
static void |
StyleUtil.setFontColor(SBook book,
CellStyleHolder holder,
java.lang.String color) |
static void |
StyleUtil.setFontHeightPoints(SBook book,
CellStyleHolder holder,
int fontHeightPoints) |
static void |
StyleUtil.setFontItalic(SBook book,
CellStyleHolder holder,
boolean italic) |
static void |
StyleUtil.setFontName(SBook book,
CellStyleHolder holder,
java.lang.String name) |
static void |
StyleUtil.setFontStrikethrough(SBook book,
CellStyleHolder holder,
boolean strikeout) |
static void |
StyleUtil.setFontTypeOffset(SBook book,
CellStyleHolder holder,
SFont.TypeOffset offset) |
static void |
StyleUtil.setFontUnderline(SBook book,
CellStyleHolder holder,
SFont.Underline underline) |
static boolean |
StyleUtil.setRichTextFontBoldweight(SBook book,
SCell cell,
SFont.Boldweight bold) |
static boolean |
StyleUtil.setRichTextFontColor(SBook book,
SCell cell,
java.lang.String htmlColor) |
static boolean |
StyleUtil.setRichTextFontHeightPoints(SBook book,
SCell cell,
int heightPoints) |
static boolean |
StyleUtil.setRichTextFontItalic(SBook book,
SCell cell,
boolean italic) |
static boolean |
StyleUtil.setRichTextFontName(SBook book,
SCell cell,
java.lang.String name) |
static boolean |
StyleUtil.setRichTextFontStrikeout(SBook book,
SCell cell,
boolean strike) |
static boolean |
StyleUtil.setRichTextFontTypeOffset(SBook book,
SCell cell,
SFont.TypeOffset offset) |
static boolean |
StyleUtil.setRichTextFontUnderline(SBook book,
SCell cell,
SFont.Underline underline) |
static void |
StyleUtil.setTextHAlign(SBook book,
CellStyleHolder holder,
SCellStyle.Alignment align) |
static void |
StyleUtil.setTextIndention(SBook book,
CellStyleHolder holder,
int indent) |
static void |
StyleUtil.setTextIndentionOffset(SBook book,
CellStyleHolder holder,
int offset) |
static void |
StyleUtil.setTextRotation(SBook book,
CellStyleHolder holder,
int rotation) |
static void |
StyleUtil.setTextVAlign(SBook book,
CellStyleHolder holder,
SCellStyle.VerticalAlignment valign) |
static void |
StyleUtil.setTextWrap(SBook book,
CellStyleHolder holder,
boolean wrap) |
Constructor and Description |
---|
RangeImpl(SBook book) |
Modifier and Type | Field and Description |
---|---|
protected SBook |
AbstractExcelImporter.book
target book model
|
Modifier and Type | Method and Description |
---|---|
SBook |
AbstractImporter.imports(java.io.File file,
java.lang.String bookName) |
SBook |
ExcelImportAdapter.imports(java.io.InputStream is,
java.lang.String bookName) |
SBook |
AbstractExcelImporter.imports(java.io.InputStream is,
java.lang.String bookName)
Import the model according to reversed dependency order among model
objects: book, sheet, defined name, cells, chart, pictures, validation.
|
SBook |
AbstractImporter.imports(java.net.URL url,
java.lang.String bookName) |
Modifier and Type | Method and Description |
---|---|
void |
AbstractExporter.export(SBook book,
java.io.File file) |
void |
AbstractExcelExporter.export(SBook book,
java.io.OutputStream fos)
Export the model according to reversed depended order: book, sheet,
defined name, cells, chart, pictures, validation.
|
protected void |
AbstractExcelExporter.exportNamedRange(SBook book) |
protected void |
AbstractExcelExporter.exportPictureData(SBook book) |
static java.lang.String |
AbstractExcelImporter.getBookType(SBook book)
Gets the book-type information ("xls" or "xlsx"), return null if not found
|
protected void |
ExcelXlsxImporter.setBookType(SBook book) |
protected void |
ExcelXlsImporter.setBookType(SBook book) |
protected abstract void |
AbstractExcelImporter.setBookType(SBook book) |
Modifier and Type | Method and Description |
---|---|
SBook |
Spreadsheet.getSBook()
Returns the book model of this Spreadsheet.
|
SBook |
Spreadsheet.getXBook()
Deprecated.
since 3.0.0 , use
Spreadsheet.getBook() |
Modifier and Type | Method and Description |
---|---|
void |
Spreadsheet.setSBook(SBook book)
Sets the book data model of this spread sheet.
|
void |
Spreadsheet.setXBook(SBook book)
Deprecated.
since 3.0.0 , use
Spreadsheet.setBook(Book) |
Modifier and Type | Method and Description |
---|---|
org.zkoss.xel.FunctionMapper |
ComponentEvaluationContributor.getFunctionMaper(SBook book) |
org.zkoss.xel.VariableResolver |
ComponentEvaluationContributor.getVariableResolver(SBook book) |
Modifier and Type | Method and Description |
---|---|
FormulaExpression |
FormulaEngineEx.renameNamePtgs(FormulaExpression fe,
SBook targetBook,
int sheetIndex,
java.lang.String oldName,
java.lang.String newName,
FormulaParseContext context) |
FormulaExpression |
FormulaEngineEx.renameSheetPtgs(FormulaExpression fe,
SBook targetBook,
java.lang.String oldSheetName,
java.lang.String newSheetName,
FormulaParseContext context) |
FormulaExpression |
FormulaEngineEx.renameTableNameTablePtgs(FormulaExpression fe,
SBook book,
java.lang.String oldName,
java.lang.String newName,
FormulaParseContext context) |
Copyright © 2005-2010 Potix Corporation. All Rights Reserved.