Package | Description |
---|---|
io.keikai.api.model |
Keikai Spreadsheet Model API classes.
|
io.keikai.api.model.impl |
Keikai Spreadsheet Model API implementation classes, Internal use only
|
io.keikai.importer | |
io.keikai.model |
Keikai Spreadsheet Internal Book Model classes.
|
io.keikai.model.impl |
Keikai Spreadsheet Internal Book Model Implementation classes.
|
io.keikai.model.impl.html |
The exporter that convert Keikai Spreadsheet to HTML.
|
io.keikai.model.impl.pdf |
The exporter that convert Keikai Spreadsheet to PDF.
|
io.keikai.model.impl.sys |
Keikai Spreadsheet Internal Book Model Implementation classes.
|
io.keikai.model.impl.sys.formula |
Keikai Spreadsheet Internal Book Model Implementation classes.
|
io.keikai.model.sys.format |
Keikai Spreadsheet Internal Book Model Engines classes.
|
io.keikai.model.sys.formula |
Keikai Spreadsheet Internal Book Model Engines classes.
|
io.keikai.range |
Keikai Spreadsheet Internal Range API classes.
|
io.keikai.range.impl |
Keikai Spreadsheet Internal Range API Implementation classes.
|
io.keikai.range.impl.imexp |
Keikai Spreadsheet Internal Range API Implementation classes.
|
io.keikai.ui |
Defines UI Component class of Keikai Spreadsheet
|
io.keikai.ui.impl |
Classes for implementing Keikai Spreadsheet UI Components (implementation only).
|
io.keikaiex.formula |
Classes bridging Keikai Spreadsheet formula functions to ZK EL functions.
|
io.keikaiex.model.sys |
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 | Field and Description |
---|---|
protected SBook |
XlsxImporter.book
target book model
|
Modifier and Type | Method and Description |
---|---|
SBook |
XlsxImporter.imports(InputStream inputStream,
String bookName) |
Modifier and Type | Method and Description |
---|---|
protected void |
XlsxImporter.setBookType(SBook book) |
Modifier and Type | Method and Description |
---|---|
static SBook |
SBooks.createBook(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(String name)
Get the book by name;
|
Modifier and Type | Method and Description |
---|---|
List<SBook> |
SBookSeries.getBooks()
Gets the books list
|
Modifier and Type | Method and Description |
---|---|
abstract void |
SBookSeriesBuilder.buildBookSeries(SBook... books) |
static ModelEvent |
ModelEvents.createModelEvent(String name,
SBook book) |
static ModelEvent |
ModelEvents.createModelEvent(String name,
SBook book,
Map data)
Create a model event.
|
static ModelEvent |
ModelEvents.createModelEvent(String name,
SBook book,
SSheet sheet,
Map data) |
STableStyle |
STableStyleInfo.getTableStyle(SBook book)
Returns styles used in this TableStyleInfo associated with the
specified book.
|
Modifier and Type | Method and Description |
---|---|
abstract void |
SBookSeriesBuilder.buildBookSeries(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(String name) |
SBook |
BookSeriesImpl.getBook(String name) |
Modifier and Type | Method and Description |
---|---|
List<SBook> |
SimpleBookSeriesImpl.getBooks() |
List<SBook> |
BookSeriesImpl.getBooks() |
Modifier and Type | Method and Description |
---|---|
void |
BookSeriesBuilderImpl.buildBookSeries(SBook... books) |
ColorScaleImpl |
ColorScaleImpl.cloneColorScale(SBook book) |
DataBarImpl |
DataBarImpl.cloneDataBar(SBook book) |
STableStyle |
TableStyleInfoImpl.getTableStyle(SBook book) |
void |
AutoFilterImpl.renameSheet(SBook book,
String oldName,
String newName) |
abstract void |
AbstractAutoFilterAdv.renameSheet(SBook book,
String oldName,
String newName) |
Modifier and Type | Method and Description |
---|---|
void |
BookSeriesBuilderImpl.buildBookSeries(Set<SBook> books) |
Constructor and Description |
---|
NamedStyleImpl(String name,
boolean custom,
int builtinId,
SBook book,
int index) |
Modifier and Type | Field and Description |
---|---|
protected SBook |
HtmlExporter.wb |
Modifier and Type | Method and Description |
---|---|
static ToHtml |
ToHtml.create(SBook wb,
OutputStream output)
Creates a new converter to HTML for the given workbook.
|
void |
HtmlExporter.export(SBook book,
File file) |
static void |
ToHtml.export(SBook wb,
OutputStream outputStream) |
void |
HtmlExporter.export(SBook workbook,
OutputStream outputStream)
Exports Keikai Spreadsheet
SBook into another format written to a
OutputStream . |
static void |
ToHtml.export(SBook wb,
OutputStream outputStream,
boolean noHeader) |
Modifier and Type | Field and Description |
---|---|
protected SBook |
PdfExporter._wb |
Modifier and Type | Method and Description |
---|---|
void |
PdfExporter.export(SBook book,
File file) |
void |
PdfExporter.export(SBook workbook,
OutputStream outputStream)
Exports Keikai Spreadsheet
Book into another format written to a
OutputStream . |
Modifier and Type | Method and Description |
---|---|
STableStyle |
FormatEngineImpl.getExistTableStyle(SBook book,
String name) |
STableStyle |
FormatEngineImpl.getTableStyle(SBook book,
String name) |
Modifier and Type | Method and Description |
---|---|
SBook |
EvalBook.getNBook() |
Modifier and Type | Method and Description |
---|---|
protected FormulaEngineImpl.FormulaAdjuster |
FormulaEngineImpl.getRenameSheetAdjuster(SBook targetBook,
String oldSheetName,
String newSheetName) |
protected FormulaEngineImpl.FormulaAdjuster |
FormulaEngineImpl.getReorderSheetAdjuster(SBook targetBook,
int oldIndex,
int newIndex) |
FormulaExpression |
FormulaEngineImpl.renameName(String formula,
SBook targetBook,
int sheetIndex,
String oldName,
String newName,
FormulaParseContext context) |
FormulaExpression |
FormulaEngineImpl.renameName(String formula,
SBook targetBook,
String oldName,
String newName,
FormulaParseContext context) |
FormulaExpression |
FormulaEngineImpl.renameNamePtgs(FormulaExpression fe,
SBook targetBook,
int sheetIndex,
String oldName,
String newName,
FormulaParseContext context) |
FormulaExpression |
FormulaEngineImpl.renameSheet(String formula,
SBook targetBook,
String oldSheetName,
String newSheetName,
FormulaParseContext context) |
FormulaExpression |
FormulaEngineImpl.renameSheetPtgs(FormulaExpression fe,
SBook targetBook,
String oldSheetName,
String newSheetName,
FormulaParseContext context) |
FormulaExpression |
FormulaEngineImpl.renameTableNameTablePtgs(FormulaExpression fexpr,
SBook book,
String oldName,
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 |
---|---|
STableStyle |
FormatEngine.getExistTableStyle(SBook book,
String name)
Returns TableStyle of the specified name of the specified book if exists;
or return null if not exists.
|
STableStyle |
FormatEngine.getTableStyle(SBook book,
String name)
Returns TableStyle of the specified name of the specified 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(String formula,
SBook book,
int sheetIndex,
String oldName,
String newName,
FormulaParseContext context) |
FormulaExpression |
FormulaEngine.renameName(String formula,
SBook book,
String oldName,
String newName,
FormulaParseContext context) |
FormulaExpression |
FormulaEngine.renameNamePtgs(FormulaExpression fexpr,
SBook book,
int sheetIndex,
String oldName,
String newName,
FormulaParseContext context) |
FormulaExpression |
FormulaEngine.renameSheet(String formula,
SBook book,
String oldName,
String newName,
FormulaParseContext context) |
FormulaExpression |
FormulaEngine.renameSheetPtgs(FormulaExpression fexpr,
SBook book,
String oldName,
String newName,
FormulaParseContext context) |
FormulaExpression |
FormulaEngine.renameTableNameTablePtgs(FormulaExpression fexpr,
SBook book,
String oldName,
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,
String sheetName,
Ref dependent) |
FormulaParseContext(SBook book,
SSheet sheet,
SCell cell,
String sheetName,
Ref dependent,
Locale locale) |
Modifier and Type | Method and Description |
---|---|
SBook |
SImporter.imports(File file,
String bookName)
Import book from a file
|
SBook |
SImporter.imports(InputStream is,
String bookName)
Import book from a input stream
|
SBook |
SImporter.imports(URL url,
String bookName)
Import book from a URL
|
Modifier and Type | Method and Description |
---|---|
void |
SExporter.export(SBook book,
File file)
Export a book
|
void |
SExporter.export(SBook book,
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)
Deprecated.
|
static SFont |
StyleUtil.getFontStyle(SBook book,
SCellStyle cellStyle,
SCellStyle tbCellStyle,
SConditionalStyle cdStyle) |
void |
NotifyChangeHelper.notifySheetDelete(SBook book,
SSheet deletedSheet,
int deletedIndex) |
static void |
StyleUtil.setBackColor(SBook book,
CellStyleHolder holder,
String htmlColor) |
static void |
StyleUtil.setBorder(SBook book,
CellStyleHolder holder,
String color,
SBorder.BorderType linestyle) |
static void |
StyleUtil.setBorder(SBook book,
CellStyleHolder holder,
String htmlColor,
SBorder.BorderType lineStyle,
short at) |
static void |
StyleUtil.setBorderBottom(SBook book,
CellStyleHolder holder,
String color,
SBorder.BorderType linestyle) |
static void |
StyleUtil.setBorderLeft(SBook book,
CellStyleHolder holder,
String color,
SBorder.BorderType linestyle) |
static void |
StyleUtil.setBorderRight(SBook book,
CellStyleHolder holder,
String color,
SBorder.BorderType linestyle) |
static void |
StyleUtil.setBorderTop(SBook book,
CellStyleHolder holder,
String color,
SBorder.BorderType linestyle) |
static void |
StyleUtil.setDataFormat(SBook book,
CellStyleHolder holder,
String format) |
static void |
StyleUtil.setFillColor(SBook book,
CellStyleHolder holder,
String htmlColor) |
static void |
StyleUtil.setFillOptions(SBook book,
CellStyleHolder holder,
String bgColor,
String fillColor,
SFill.FillPattern pattern) |
static void |
StyleUtil.setFontBoldWeight(SBook book,
CellStyleHolder holder,
SFont.Boldweight boldWeight) |
static void |
StyleUtil.setFontColor(SBook book,
CellStyleHolder holder,
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,
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,
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,
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(File file,
String bookName) |
SBook |
ExcelImportAdapter.imports(InputStream is,
String bookName) |
SBook |
AbstractExcelImporter.imports(InputStream is,
String bookName)
Import the model according to reversed dependency order among model
objects: book, sheet, defined name, cells, chart, pictures, validation.
|
SBook |
AbstractImporter.imports(URL url,
String bookName) |
Modifier and Type | Method and Description |
---|---|
void |
AbstractExporter.export(SBook book,
File file) |
void |
AbstractExcelExporter.export(SBook book,
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 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,
String oldName,
String newName,
FormulaParseContext context) |
FormulaExpression |
FormulaEngineEx.renameSheetPtgs(FormulaExpression fe,
SBook targetBook,
String oldSheetName,
String newSheetName,
FormulaParseContext context) |
FormulaExpression |
FormulaEngineEx.renameTableNameTablePtgs(FormulaExpression fe,
SBook book,
String oldName,
String newName,
FormulaParseContext context) |
Modifier and Type | Method and Description |
---|---|
STableStyle |
FormatEngineEx.getExistTableStyle(SBook book,
String name) |
STableStyle |
FormatEngineEx.getTableStyle(SBook book,
String name) |
Copyright © 2020. All rights reserved.