Skip navigation links
A B C D E F G H I K L M N O P R S T U V W 

A

a1ToRef(String) - Static method in class com.keikai.util.Converter
 
abcToNum(String) - Static method in class com.keikai.util.Converter
Converts abc to number.
activate() - Method in interface com.keikai.client.api.Range
Select a cell or cells with this range.
addEventListener(String, RangeEventListener<? extends RangeEvent>) - Method in interface com.keikai.client.api.Spreadsheet
Adds the event listener
Alignment - Interface in com.keikai.client.api
An alignment interface
Alignment.Horizontal - Enum in com.keikai.client.api
Horizontal attributes that can be applied.
Alignment.ReadingOrder - Enum in com.keikai.client.api
ReadingOrder attributes that can be applied.
Alignment.Vertical - Enum in com.keikai.client.api
Vertical attributes that can be applied.
applyAutoFilter(int, Object, Range.AutoFilterOperator, Object, boolean) - Method in interface com.keikai.client.api.Range
Applies the auto filter to this range.
applyBorders(Borders) - Method in interface com.keikai.client.api.Range
Applies the borders for this range.
applyCellStyle(CellStyle) - Method in interface com.keikai.client.api.Range
Applies the cell style to remote data server.
applyColumnWidth(int) - Method in interface com.keikai.client.api.Range
Applies the column width of this range in character unit width.
applyColumnWidthPx(int) - Method in interface com.keikai.client.api.Range
Applies the column width of this range in pixels.
applyDataValidation(DataValidation) - Method in interface com.keikai.client.api.Range
Applies the data dataValidation
applyFill(Fill) - Method in interface com.keikai.client.api.Range
Applies the fill to this range.
applyFont(Font) - Method in interface com.keikai.client.api.Range
Applies the font to this range.
applyHorizontalAlignment(Alignment.Horizontal) - Method in interface com.keikai.client.api.Range
Applies the horizontal alignment for the given range.
applyNumberFormat(String) - Method in interface com.keikai.client.api.Range
Applies the number format to this range.
applyValue(Object) - Method in interface com.keikai.client.api.Range
Applies the range value.
applyValues(Object...) - Method in interface com.keikai.client.api.Range
Applies the range values.
applyVerticalAlignment(Alignment.Vertical) - Method in interface com.keikai.client.api.Range
Applies the vertical alignment.
applyWrapText(boolean) - Method in interface com.keikai.client.api.Range
Applies to enable or disable the wrap text.
areaToRef(int, int, int, int) - Static method in class com.keikai.util.Converter
 

B

Border - Interface in com.keikai.client.api
Represents the border of an object for Range or CellStyle to use.
Border.Style - Enum in com.keikai.client.api
Style attributes that can be applied.
Border.ThemeColor - Enum in com.keikai.client.api
ThemeColor attributes that can be applied.
Borders - Interface in com.keikai.client.api
A collection of borders that represent the four borders of a Range or CellStyle Object.
Borders.BorderIndex - Enum in com.keikai.client.api
BorderIndex attributes that can be applied.

C

CellMouseEvent - Class in com.keikai.client.api.event
Event that carries mouse x,y information and cell row,column information on click
CellMouseEvent(String, Set<Range>, int, int, int, int, int, int, Object) - Constructor for class com.keikai.client.api.event.CellMouseEvent
 
CellStyle - Interface in com.keikai.client.api
The CellStyle object contains all style attributes (font, number format, alignment, and so on) as properties.
CellValue - Interface in com.keikai.client.api
A cell value object.
clearAutoFilter() - Method in interface com.keikai.client.api.Range
Clears the auto filter
clearBorders() - Method in interface com.keikai.client.api.Range
Clears the borders for this range.
clearCellStyle() - Method in interface com.keikai.client.api.Range
Clears the cell style.
clearContents() - Method in interface com.keikai.client.api.Range
Clears formula/values of this range
clearDataValidation() - Method in interface com.keikai.client.api.Range
Clears the data validation
clearFill() - Method in interface com.keikai.client.api.Range
Clears the fill
clearFont() - Method in interface com.keikai.client.api.Range
Clears the font
close() - Method in interface com.keikai.client.api.Spreadsheet
Closes this client.
com.keikai.client - package com.keikai.client
 
com.keikai.client.api - package com.keikai.client.api
 
com.keikai.client.api.event - package com.keikai.client.api.event
 
com.keikai.util - package com.keikai.util
 
contains(Settings.Key) - Method in class com.keikai.client.api.Settings
 
Converter - Class in com.keikai.util
 
Converter() - Constructor for class com.keikai.util.Converter
 
convertTime(String) - Static method in class com.keikai.util.DateUtil
Converts a string of format "HH:MM" or "HH:MM:SS" to its (Excel) numeric equivalent
createAlignment() - Method in interface com.keikai.client.api.CellStyle
Creates a alignment.
createBorder() - Method in interface com.keikai.client.api.CellStyle
Creates a border
createBorders() - Method in interface com.keikai.client.api.CellStyle
createBorders(Borders.BorderIndex) - Method in interface com.keikai.client.api.Range
Creates the borders from the given border index.
createCellStyle() - Method in interface com.keikai.client.api.Range
Creates a cell style object.
createDataValidation() - Method in interface com.keikai.client.api.Range
Creates a data validation
createFont() - Method in interface com.keikai.client.api.CellStyle
Creates a font.
createFont() - Method in interface com.keikai.client.api.Range
Creates a font
createNumberFormat() - Method in interface com.keikai.client.api.CellStyle
Creates a number format
createPatternFill() - Method in interface com.keikai.client.api.CellStyle
Creates a pattern fill.
createPatternFill() - Method in interface com.keikai.client.api.Range
Creates a pattern fill.
createProtection() - Method in interface com.keikai.client.api.CellStyle
Creates a protection

D

DataValidation - Interface in com.keikai.client.api
A data validation interface
DataValidation.AlertStyle - Enum in com.keikai.client.api
AlertStyle attributes that can be applied.
DataValidation.Type - Enum in com.keikai.client.api
Type attributes that can be applied.
DateUtil - Class in com.keikai.util
Contains methods for dealing with Excel dates.
DAY_MILLISECONDS - Static variable in class com.keikai.util.DateUtil
 
DEFAULT_SETTINGS - Static variable in class com.keikai.client.api.Settings
The default settings.
delete(Range.DeleteShiftDirection) - Method in interface com.keikai.client.api.Range
Deletes cells of the range.
delete() - Method in interface com.keikai.client.api.Spreadsheet
Deletes the remote workbook and close this client.
deleteWorksheet(String) - Method in interface com.keikai.client.api.Workbook
Deletes a sheet with the given name.

E

Events - Class in com.keikai.client.api.event
 
Events() - Constructor for class com.keikai.client.api.event.Events
 
export(String, OutputStream) - Method in interface com.keikai.client.api.Spreadsheet
Exports the book from the given bookname to an output stream.
export(String, OutputStream, String) - Method in interface com.keikai.client.api.Spreadsheet
Exports the book from the given bookname to an output stream with the given format.

F

Fill - Interface in com.keikai.client.api
A fill interface for Pattern Fill and Gradient Fill
Fill.PatternFill - Interface in com.keikai.client.api
A Pattern Fill
Fill.PatternFill.PatternType - Enum in com.keikai.client.api
 
Font - Interface in com.keikai.client.api
A font interface
Font.Underline - Enum in com.keikai.client.api
Underline attributes that can be applied.
fromJSON(String, Class<T>) - Static method in class com.keikai.util.Converter
 

G

get(Settings.Key) - Method in class com.keikai.client.api.Settings
 
getA1Notation() - Method in interface com.keikai.client.api.Range
Returns the A1 notation from this range.
getActiveCell() - Method in class com.keikai.client.api.event.RangeSelectEvent
Returns the active cell of this range event.
getActiveSelection() - Method in class com.keikai.client.api.event.RangeSelectEvent
Returns the active selection of this range event.
getActiveWorkbook() - Method in interface com.keikai.client.api.Spreadsheet
Returns a String name of this active workbook in this spreadsheet client.
getActiveWorksheet() - Method in interface com.keikai.client.api.Spreadsheet
Returns an Integer index or a String name of this active worksheet in this spreadsheet client.
getActiveWorksheet() - Method in interface com.keikai.client.api.Workbook
Returns an Integer index or a String name of this active worksheet in this spreadsheet client.
getAlertStyle() - Method in interface com.keikai.client.api.DataValidation
Returns the alert style.
getAlignment() - Method in interface com.keikai.client.api.CellStyle
Returns the alignment
getBackgroundColor() - Method in interface com.keikai.client.api.Fill.PatternFill
Returns the background color
getBooleanValue() - Method in interface com.keikai.client.api.CellValue
Returns the boolean value of this cell.
getBorder(Borders.BorderIndex) - Method in interface com.keikai.client.api.Borders
Returns the border from the given border index.
getBorder(Borders.BorderIndex) - Method in interface com.keikai.client.api.CellStyle
Returns the single border from the given border index.
getBorderIndices() - Method in interface com.keikai.client.api.Borders
Returns the specified border indices.
getBorders() - Method in interface com.keikai.client.api.CellStyle
Returns the borders collection.
getBottom() - Method in class com.keikai.util.Ref
 
getButton() - Method in class com.keikai.client.api.event.CellMouseEvent
Returns a Number, representing which mouse button that was pressed when the mouse event occurred.
getCell(int, int) - Method in interface com.keikai.client.api.Range
 
getCellMouseEvent(String, Spreadsheet, JSONObject) - Static method in class com.keikai.client.api.event.CellMouseEvent
 
getCellValue() - Method in interface com.keikai.client.api.RangeValue
Returns the cell value from this range.
getCharset() - Method in interface com.keikai.client.api.Font
Returns the charset
getColor() - Method in interface com.keikai.client.api.Border
Returns the border color.
getColor() - Method in interface com.keikai.client.api.Borders
 
getColor() - Method in interface com.keikai.client.api.Font
Returns the color
getColorIndex() - Method in interface com.keikai.client.api.Border
Returns the border color index.
getColorIndex() - Method in interface com.keikai.client.api.Borders
 
getColumn() - Method in class com.keikai.client.api.event.RangeEvent
Returns the column position in the first range.
getColumn() - Method in interface com.keikai.client.api.Range
Returns the left column position for this range.
getColumnCount() - Method in class com.keikai.util.Ref
 
getColumnIndex() - Method in interface com.keikai.client.api.RangeValue
Returns the column index from this range.
getColumns() - Method in interface com.keikai.client.api.Range
Return the column part of this range.
getColumns(int) - Method in interface com.keikai.client.api.Range
Returns a Range that is n-th column(0-based) related to the first area of this range and in the range.
getCount() - Method in interface com.keikai.client.api.Range
Returns the count of cells of this range.
getCount() - Method in class com.keikai.util.Ref
 
getDateValue() - Method in interface com.keikai.client.api.CellValue
Returns the date value of this cell.
getDoubleValue() - Method in interface com.keikai.client.api.CellValue
Returns the double value of this cell.
getErrorMessage() - Method in interface com.keikai.client.api.DataValidation
Returns the error message.
getErrorTitle() - Method in interface com.keikai.client.api.DataValidation
Returns the title of the data validation error dialog box.
getExcelDate(Date) - Static method in class com.keikai.util.DateUtil
Given a Date, converts it into a double representing its internal Excel representation, which is the number of days since 1/1/1900.
getExcelDate(Date, boolean) - Static method in class com.keikai.util.DateUtil
Given a Date, converts it into a double representing its internal Excel representation, which is the number of days since 1/1/1900.
getExcelDate(Calendar, boolean) - Static method in class com.keikai.util.DateUtil
Given a Date in the form of a Calendar, converts it into a double representing its internal Excel representation, which is the number of days since 1/1/1900.
getFamily() - Method in interface com.keikai.client.api.Font
Returns the family
getFill() - Method in interface com.keikai.client.api.CellStyle
Returns the fill
getFont() - Method in interface com.keikai.client.api.CellStyle
Returns the font
getForegroundColor() - Method in interface com.keikai.client.api.Fill.PatternFill
Returns the foreground color
getFormat() - Method in interface com.keikai.client.api.CellValue
Returns the format of this cell.
getFormat() - Method in interface com.keikai.client.api.NumberFormat
Returns the format
getFormula() - Method in interface com.keikai.client.api.CellValue
Returns the formula of this cell.
getFormula1() - Method in interface com.keikai.client.api.DataValidation
Returns the formula1 expression.
getHorizontal() - Method in interface com.keikai.client.api.Alignment
Returns the horizontal
getId() - Method in interface com.keikai.client.api.Spreadsheet
Returns the id of the unique keikai's Application
getIndent() - Method in interface com.keikai.client.api.Alignment
Returns the indent
getInputMessage() - Method in interface com.keikai.client.api.DataValidation
Returns the input message.
getInputTitle() - Method in interface com.keikai.client.api.DataValidation
Returns the title of the data validation input dialog box.
getJavaCalendar(double, boolean) - Static method in class com.keikai.util.DateUtil
Get EXCEL date as Java Calendar (with default time zone).
getJavaCalendar(double, boolean, TimeZone) - Static method in class com.keikai.util.DateUtil
Get EXCEL date as Java Calendar with given time zone.
getJavaCalendarUTC(double, boolean) - Static method in class com.keikai.util.DateUtil
Get EXCEL date as Java Calendar with UTC time zone.
getJavaDate(double, TimeZone) - Static method in class com.keikai.util.DateUtil
Given an Excel date with using 1900 date windowing, and converts it to a java.util.Date.
getJavaDate(double) - Static method in class com.keikai.util.DateUtil
Given an Excel date with using 1900 date windowing, and converts it to a java.util.Date.
getJavaDate(double, boolean, TimeZone) - Static method in class com.keikai.util.DateUtil
Given an Excel date with either 1900 or 1904 date windowing, converts it to a java.util.Date.
getJavaDate(double, boolean) - Static method in class com.keikai.util.DateUtil
Given an Excel date with either 1900 or 1904 date windowing, converts it to a java.util.Date.
getKeyCode() - Method in class com.keikai.client.api.event.RangeKeyEvent
Returns the keyCode;
getLastColumn() - Method in class com.keikai.client.api.event.RangeEvent
Returns the last column position in the first range.
getLastColumn() - Method in interface com.keikai.client.api.Range
Returns the end column position for this range.
getLastRow() - Method in class com.keikai.client.api.event.RangeEvent
Returns the last row position in the first range.
getLastRow() - Method in interface com.keikai.client.api.Range
Returns the end row position for this range.
getLeft() - Method in class com.keikai.util.Ref
 
getName() - Method in interface com.keikai.client.api.Font
Returns the name
getName() - Method in interface com.keikai.client.api.Workbook
Returns the name of this workbook.
getName() - Method in interface com.keikai.client.api.Worksheet
Returns the sheet name.
getNumberFormat() - Method in interface com.keikai.client.api.CellStyle
Returns the number format.
getPageX() - Method in class com.keikai.client.api.event.CellMouseEvent
Returns the horizontal coordinate of the mouse pointer relative to the whole document.
getPageY() - Method in class com.keikai.client.api.event.CellMouseEvent
Returns the vertical coordinate of the mouse pointer relative to the whole document.
getPatternType() - Method in interface com.keikai.client.api.Fill.PatternFill
Returns pattern type.
getProtection() - Method in interface com.keikai.client.api.CellStyle
Returns the protection.
getRange() - Method in class com.keikai.client.api.event.RangeEvent
Returns the first range, if any.
getRange(String) - Method in interface com.keikai.client.api.Spreadsheet
Returns the range proxy with the given A1 notation or R1C1 notation.
getRange(int, int) - Method in interface com.keikai.client.api.Spreadsheet
Returns the range proxy with the given row and column.
getRange(int, int, int, int) - Method in interface com.keikai.client.api.Spreadsheet
Returns the range proxy with the given row and column with the given number of the rows and columns
getRange(String) - Method in interface com.keikai.client.api.Workbook
Returns the range proxy with the given A1 notation or R1C1 notation.
getRange(int, int) - Method in interface com.keikai.client.api.Workbook
Returns the range proxy with the given row and column.
getRange(int, int, int, int) - Method in interface com.keikai.client.api.Workbook
Returns the range proxy with the given row and column with the given number of the rows and columns
getRange(String) - Method in interface com.keikai.client.api.Worksheet
Returns the range proxy with the given A1 notation or R1C1 notation.
getRange(int, int) - Method in interface com.keikai.client.api.Worksheet
Returns the range proxy with the given row and column.
getRange(int, int, int, int) - Method in interface com.keikai.client.api.Worksheet
Returns the range proxy with the given row and column with the given number of the rows and columns
getRangeEvent(String, Spreadsheet, String) - Static method in class com.keikai.client.api.event.RangeEvent
 
getRangeEvent(String, Spreadsheet, String, Object) - Static method in class com.keikai.client.api.event.RangeEvent
 
getRangeKeyEvent(String, Spreadsheet, Map) - Static method in class com.keikai.client.api.event.RangeKeyEvent
 
getRanges() - Method in class com.keikai.client.api.event.RangeEvent
 
getRangeSelectEvent(String, Spreadsheet, Map) - Static method in class com.keikai.client.api.event.RangeSelectEvent
 
getReadingOrder() - Method in interface com.keikai.client.api.Alignment
Returns the reading order.
getRelativeIndent() - Method in interface com.keikai.client.api.Alignment
Returns the relative indent.
getRight() - Method in class com.keikai.util.Ref
 
getRow() - Method in class com.keikai.client.api.event.RangeEvent
Returns the row position in the first range.
getRow() - Method in interface com.keikai.client.api.Range
Returns the top row position for this range.
getRowCount() - Method in class com.keikai.util.Ref
 
getRowIndex() - Method in interface com.keikai.client.api.RangeValue
Returns the row index from this range.
getRows() - Method in interface com.keikai.client.api.Range
Returns the row port of this range.
getRows(int) - Method in interface com.keikai.client.api.Range
Returns a Range that is n-th row(0-based) related to the first area of this range and in the range.
getScheme() - Method in interface com.keikai.client.api.Font
Returns the scheme
getSettings() - Method in interface com.keikai.client.api.Spreadsheet
Returns the settings of this spreadsheet
getSheetsCount() - Method in interface com.keikai.client.api.Workbook
Returns the count of the worksheets in this workbook.
getSize() - Method in interface com.keikai.client.api.Borders
Returns the size of the specified borders.
getSize() - Method in interface com.keikai.client.api.Font
Returns the size
getSpreadsheet() - Method in interface com.keikai.client.api.Range
 
getSpreadsheet() - Method in interface com.keikai.client.api.Workbook
Returns the spreadsheet client which holds this workbook.
getSpreadsheet() - Method in interface com.keikai.client.api.Worksheet
Returns the spreadsheet which holds this worksheet.
getStringValue() - Method in interface com.keikai.client.api.CellValue
Returns the string value of this cell.
getStyle() - Method in interface com.keikai.client.api.Border
Returns the border style.
getStyle() - Method in interface com.keikai.client.api.Borders
 
getTextRotation() - Method in interface com.keikai.client.api.Alignment
Returns the text rotation
getThemeColor() - Method in interface com.keikai.client.api.Border
Returns the border theme color.
getThemeColor() - Method in interface com.keikai.client.api.Borders
 
getTop() - Method in class com.keikai.util.Ref
 
getType() - Method in interface com.keikai.client.api.DataValidation
Returns the data validation type
getUnderline() - Method in interface com.keikai.client.api.Font
Returns the underline
getURI(String) - Method in interface com.keikai.client.api.Spreadsheet
Return the remote access URI for this client.
getValue() - Method in interface com.keikai.client.api.CellValue
Returns the raw value of this cell.
getValue() - Method in interface com.keikai.client.api.RangeValue
Returns the raw value from this range.
getVertical() - Method in interface com.keikai.client.api.Alignment
Returns the vertical
getX() - Method in class com.keikai.client.api.event.CellMouseEvent
Returns the horizontal coordinate of the mouse pointer relevant to the spreadsheet.
getY() - Method in class com.keikai.client.api.event.CellMouseEvent
Returns the vertical coordinate of the mouse pointer relevant to the spreadsheet.

H

HOURS_PER_DAY - Static variable in class com.keikai.util.DateUtil
 

I

imports(String, InputStream) - Method in interface com.keikai.client.api.Spreadsheet
Imports the given workbook to the current spreadsheet.
imports(String, File) - Method in interface com.keikai.client.api.Spreadsheet
Imports the given workbook to the current spreadsheet.
imports(String, URL) - Method in interface com.keikai.client.api.Spreadsheet
Imports the given workbook to the current spreadsheet.
insert(Range.InsertShiftDirection, Range.InsertFormatOrigin) - Method in interface com.keikai.client.api.Range
Insert cells to the range
insertWorksheet() - Method in interface com.keikai.client.api.Spreadsheet
Inserts a new sheet in the active workbook, with a default name.
insertWorksheet(String) - Method in interface com.keikai.client.api.Spreadsheet
Inserts a new sheet in the active workbook, with a given name.
insertWorksheet(int) - Method in interface com.keikai.client.api.Spreadsheet
Inserts a new sheet in the active workbook at the given index, with a default name.
insertWorksheet() - Method in interface com.keikai.client.api.Workbook
Inserts a new sheet in the workbook, with a default name.
insertWorksheet(String) - Method in interface com.keikai.client.api.Workbook
Inserts a new sheet in the workbook, with a given name.
insertWorksheet(int) - Method in interface com.keikai.client.api.Workbook
Inserts a new sheet in the workbook at the given index, with a default name.
isADateFormat(int, String) - Static method in class com.keikai.util.DateUtil
Given a format ID and its format String, will check to see if the format represents a date format or not.
isAltKey() - Method in class com.keikai.client.api.event.CellMouseEvent
Returns whether the alt key has pressed.
isAltKey() - Method in class com.keikai.client.api.event.RangeKeyEvent
Returns whether the alt key has pressed.
isBlank() - Method in interface com.keikai.client.api.CellValue
Returns whether it's a blank cell.
isBold() - Method in interface com.keikai.client.api.Font
Returns whether enable the bold or not
isCell() - Method in class com.keikai.util.Ref
 
isCondense() - Method in interface com.keikai.client.api.Font
Returns whether enable the condense or not
isCtrlKey() - Method in class com.keikai.client.api.event.CellMouseEvent
Returns whether the ctrl key has pressed.
isCtrlKey() - Method in class com.keikai.client.api.event.RangeKeyEvent
Returns whether the ctrl key has pressed.
isError() - Method in interface com.keikai.client.api.CellValue
Returns whether it's an error value.
isExtend() - Method in interface com.keikai.client.api.Font
Returns whether enable the extend or not
isFormula() - Method in interface com.keikai.client.api.CellValue
Returns whether it's a formula cell.
isHidden() - Method in interface com.keikai.client.api.Protection
Returns whether is hidden or not.
isIgnoreBlank() - Method in interface com.keikai.client.api.DataValidation
Returns whether to ignore the blank
isInCellDropdown() - Method in interface com.keikai.client.api.DataValidation
Returns whether to display a drop-down list that contains acceptable values
isInternalDateFormat(int) - Static method in class com.keikai.util.DateUtil
Given a format ID this will check whether the format represents an internal excel date format or not.
isItalic() - Method in interface com.keikai.client.api.Font
Returns whether enable the italic or not
isJustifyLastLine() - Method in interface com.keikai.client.api.Alignment
Returns whether enable the justify last line or not
isLocked() - Method in interface com.keikai.client.api.Protection
Returns whether is locked or not.
isMetaKey() - Method in class com.keikai.client.api.event.CellMouseEvent
Returns whether the meta key has pressed.
isMetaKey() - Method in class com.keikai.client.api.event.RangeKeyEvent
Returns whether the meta key has pressed.
isNumber() - Method in interface com.keikai.client.api.CellValue
Returns whether it's a number value.
isOutline() - Method in interface com.keikai.client.api.Font
Returns whether enable the outline or not
isReady() - Method in interface com.keikai.client.api.Spreadsheet
Checks whether the spreadsheet client is available at the remote server.
isShadow() - Method in interface com.keikai.client.api.Font
Returns whether enable the shadow or not
isShiftKey() - Method in class com.keikai.client.api.event.CellMouseEvent
Returns whether the shift key has pressed.
isShiftKey() - Method in class com.keikai.client.api.event.RangeKeyEvent
Returns whether the shift key has pressed.
isShowError() - Method in interface com.keikai.client.api.DataValidation
Returns whether to show the error message message whenever the user enters invalid data.
isShowInput() - Method in interface com.keikai.client.api.DataValidation
Returns whether to show the input message whenever the user selects a cell in the data validation range.
isShrinkToFit() - Method in interface com.keikai.client.api.Alignment
Returns whether enable the shrink to fit
isStrike() - Method in interface com.keikai.client.api.Font
Returns whether enable the strike or not
isSubscript() - Method in interface com.keikai.client.api.Font
Returns whether enable the subscript or not
isSuperscript() - Method in interface com.keikai.client.api.Font
Returns whether enable the superscript or not
isText() - Method in interface com.keikai.client.api.CellValue
Return whether it's a string value.
isValidExcelDate(double) - Static method in class com.keikai.util.DateUtil
Given a double, checks if it is a valid Excel date.
isWrapText() - Method in interface com.keikai.client.api.Alignment
Returns whether enable the wrap text or not

K

Keikai - Class in com.keikai.client.api
Utilities to access Spreadsheet.
Keikai() - Constructor for class com.keikai.client.api.Keikai
 

L

loadActiveCell() - Method in interface com.keikai.client.api.Spreadsheet
Returns the current cell focus range from the UI client.
loadCellStyle() - Method in interface com.keikai.client.api.Range
Loads the cell style from the remote data server.
loadDataValidation() - Method in interface com.keikai.client.api.Range
Loads the data validation from the remote data server.
loadValue() - Method in interface com.keikai.client.api.Range
Returns the first range value from this range.
loadValues() - Method in interface com.keikai.client.api.Range
Returns the range values from this range.
loadWorkbook() - Method in interface com.keikai.client.api.Range
Returns the remote workbook which holds this range.
loadWorkbook() - Method in interface com.keikai.client.api.Spreadsheet
Returns the active workbook from the remote server.
loadWorkbook(String) - Method in interface com.keikai.client.api.Spreadsheet
Returns the workbook by the given name from the remote server.
loadWorkbook() - Method in interface com.keikai.client.api.Worksheet
Returns the remote workbook which holds this worksheet.
loadWorksheet() - Method in interface com.keikai.client.api.Range
Returns the remote worksheet which holds this range.
loadWorksheet() - Method in interface com.keikai.client.api.Spreadsheet
Returns the active worksheet from the remote server.
loadWorksheet(int) - Method in interface com.keikai.client.api.Spreadsheet
Returns the worksheet by the given index from the remote server.
loadWorksheet(String) - Method in interface com.keikai.client.api.Spreadsheet
Returns the worksheet by the given name from the remote server.
loadWorksheet() - Method in interface com.keikai.client.api.Workbook
Returns the active worksheet from the remote server.
loadWorksheet(int) - Method in interface com.keikai.client.api.Workbook
Returns the worksheet by the given index from the remote server.
loadWorksheet(String) - Method in interface com.keikai.client.api.Workbook
Returns the worksheet by the given name from the remote server.

M

Maps - Class in com.keikai.util
 
Maps() - Constructor for class com.keikai.util.Maps
 
MAX_COL - Static variable in interface com.keikai.client.api.Range
 
MAX_ROW - Static variable in interface com.keikai.client.api.Range
 
MINUTES_PER_HOUR - Static variable in class com.keikai.util.DateUtil
 

N

newClient(String) - Static method in class com.keikai.client.api.Keikai
Creates a spreadsheet client from the given address
newClient(String, Settings) - Static method in class com.keikai.client.api.Keikai
Creates a spreadsheet client from the given address and settings.
newClient(String, String) - Static method in class com.keikai.client.api.Keikai
Creates a spreadsheet client from the given address and app id.
newClient(String, String, Settings) - Static method in class com.keikai.client.api.Keikai
Create a spreadshhet client from the given address, app id, and settings.
NULL_INTEGER - Static variable in class com.keikai.client.api.Settings
The null integer value for current keikai system.
NumberFormat - Interface in com.keikai.client.api
A number format interface
numToAbc(int) - Static method in class com.keikai.util.Converter
Converts 0-based index to abc.

O

ON_ADD_SELECTION - Static variable in class com.keikai.client.api.event.Events
 
ON_CELL_CLICK - Static variable in class com.keikai.client.api.event.Events
 
ON_CELL_DOUBLE_CLICK - Static variable in class com.keikai.client.api.event.Events
 
ON_CELL_RIGHT_CLICK - Static variable in class com.keikai.client.api.event.Events
 
ON_KEY_DOWN - Static variable in class com.keikai.client.api.event.Events
 
ON_KEY_UP - Static variable in class com.keikai.client.api.event.Events
 
ON_MOVE_FOCUS - Static variable in class com.keikai.client.api.event.Events
 
ON_NEW_SELECTION - Static variable in class com.keikai.client.api.event.Events
 
ON_UPDATE_SELECTION - Static variable in class com.keikai.client.api.event.Events
 
onEvent(T) - Method in interface com.keikai.client.api.event.RangeEventListener
 

P

parseYYYYMMDDDate(String) - Static method in class com.keikai.util.DateUtil
Converts a string of format "YYYY/MM/DD" to its (Excel) numeric equivalent
Protection - Interface in com.keikai.client.api
A protection object to represents a locked and hidden states for a CellStyle.

R

Range - Interface in com.keikai.client.api
A range can be a single cell in a worksheet or a range of cells in a worksheet.
Range.AutoFilterOperator - Enum in com.keikai.client.api
AutoFilterOperator attributes, that can be applied.
Range.DeleteShiftDirection - Enum in com.keikai.client.api
DeleteShiftDirection attributes, that can be applied.
Range.InsertFormatOrigin - Enum in com.keikai.client.api
InsertFormatOrigin attributes, that can be applied.
Range.InsertShiftDirection - Enum in com.keikai.client.api
InsertShiftDirection attributes, that can be applied.
RangeEvent - Class in com.keikai.client.api.event
A range event is sent when a user interacts with the UI
RangeEvent(String, Set<Range>, Object) - Constructor for class com.keikai.client.api.event.RangeEvent
 
RangeEventListener<T extends RangeEvent> - Interface in com.keikai.client.api.event
 
RangeKeyEvent - Class in com.keikai.client.api.event
A key event sent when a user press a key on the UI client.
RangeKeyEvent(String, Set<Range>, int, int, Object) - Constructor for class com.keikai.client.api.event.RangeKeyEvent
 
RangeSelectEvent - Class in com.keikai.client.api.event
A selection event sent when a user select a range on the UI client.
RangeSelectEvent(String, Set<Range>, Range, Range, Object) - Constructor for class com.keikai.client.api.event.RangeSelectEvent
 
rangeToA1(int, int) - Static method in class com.keikai.util.Converter
Converts a range to A1 notation.
rangeToRef(int, int) - Static method in class com.keikai.util.Converter
 
RangeValue - Interface in com.keikai.client.api
A range value (Immutable)
ready(Runnable) - Method in interface com.keikai.client.api.Spreadsheet
Executes the callback as soon as this spreadsheet client becomes available to handle a job at the remote server.
ready() - Method in interface com.keikai.client.api.Spreadsheet
Returns a future to apply a callback when this spreadsheet becomes available to handle a job at the remote server.
Ref - Class in com.keikai.util
Ref is a reference for cell or range with 4 value : top(top row), left(left column), bottom(last row) and right(last column).
refToA1(Ref) - Static method in class com.keikai.util.Converter
 
remove(Settings.Key) - Method in class com.keikai.client.api.Settings
 
removeEventListener(String, RangeEventListener<? extends RangeEvent>) - Method in interface com.keikai.client.api.Spreadsheet
Removes the event listener

S

SECONDS_PER_DAY - Static variable in class com.keikai.util.DateUtil
 
SECONDS_PER_MINUTE - Static variable in class com.keikai.util.DateUtil
 
set(Settings.Key, Object) - Method in class com.keikai.client.api.Settings
 
setActiveWorkbook(String) - Method in interface com.keikai.client.api.Spreadsheet
Sets the active workbook with the given name.
setActiveWorksheet(int) - Method in interface com.keikai.client.api.Spreadsheet
Sets the active worksheet with the given index.
setActiveWorksheet(String) - Method in interface com.keikai.client.api.Spreadsheet
Sets the active worksheet with the given name.
setActiveWorksheet(Object) - Method in interface com.keikai.client.api.Spreadsheet
Sets the active worksheet with the given name or index.
setActiveWorksheet(int) - Method in interface com.keikai.client.api.Workbook
Sets the active worksheet with the given index.
setActiveWorksheet(String) - Method in interface com.keikai.client.api.Workbook
Sets the active worksheet with the given name.
setActiveWorksheet(Object) - Method in interface com.keikai.client.api.Workbook
Sets the active worksheet with the given name or index.
setAlertStyle(DataValidation.AlertStyle) - Method in interface com.keikai.client.api.DataValidation
Sets the alert style.
setAlignment(Alignment) - Method in interface com.keikai.client.api.CellStyle
Sets the alignment
setBackgroundColor(String) - Method in interface com.keikai.client.api.Fill.PatternFill
Sets background color
setBold(boolean) - Method in interface com.keikai.client.api.Font
Sets to enable the bold or not
setBorder(Borders.BorderIndex, Border) - Method in interface com.keikai.client.api.Borders
Sets the border to the given border index.
setBorder(Borders.BorderIndex, Border) - Method in interface com.keikai.client.api.CellStyle
Sets the single border with the given border index
setBorders(Borders) - Method in interface com.keikai.client.api.CellStyle
Sets the borders collection, this will replace the existing borders, if any.
setCalendar(Calendar, int, int, boolean) - Static method in class com.keikai.util.DateUtil
 
setCharset(int) - Method in interface com.keikai.client.api.Font
Sets the charset
setColor(String) - Method in interface com.keikai.client.api.Border
Sets the border color.
setColor(int) - Method in interface com.keikai.client.api.Border
Sets the border color index
setColor(String) - Method in interface com.keikai.client.api.Borders
Sets the border color.
setColor(int) - Method in interface com.keikai.client.api.Borders
Sets the border color index.
setColor(String) - Method in interface com.keikai.client.api.Font
Sets the color
setColor(String) - Method in interface com.keikai.client.api.Stop
 
setCondense(boolean) - Method in interface com.keikai.client.api.Font
Sets to enable the condense or not
setErrorMessage(String) - Method in interface com.keikai.client.api.DataValidation
Sets the error message.
setErrorTitle(String) - Method in interface com.keikai.client.api.DataValidation
Sets the title of the data validation error dialog box.
setExtend(boolean) - Method in interface com.keikai.client.api.Font
Sets to enable the extend or not
setFamily(int) - Method in interface com.keikai.client.api.Font
Sets the family
setFill(Fill) - Method in interface com.keikai.client.api.CellStyle
Sets the fill
setFont(Font) - Method in interface com.keikai.client.api.CellStyle
Sets the font
setForegroundColor(String) - Method in interface com.keikai.client.api.Fill.PatternFill
Sets foreground color
setFormat(String) - Method in interface com.keikai.client.api.NumberFormat
Sets the format
setFormula1(String) - Method in interface com.keikai.client.api.DataValidation
Sets the formula1 expression.
setHidden(boolean) - Method in interface com.keikai.client.api.Protection
Sets to be hidden or not.
setHorizontal(Alignment.Horizontal) - Method in interface com.keikai.client.api.Alignment
Sets the horizontal
setIgnoreBlank(boolean) - Method in interface com.keikai.client.api.DataValidation
Sets to ignore the blank
setInCellDropdown(boolean) - Method in interface com.keikai.client.api.DataValidation
Sets to display a drop-down list that contains acceptable values
setIndent(int) - Method in interface com.keikai.client.api.Alignment
Sets the indent
setInputMessage(String) - Method in interface com.keikai.client.api.DataValidation
Sets the input message.
setInputTitle(String) - Method in interface com.keikai.client.api.DataValidation
Sets the title of the data validation input dialog box.
setItalic(boolean) - Method in interface com.keikai.client.api.Font
Sets to enable the italic or not
setJustifyLastLine(boolean) - Method in interface com.keikai.client.api.Alignment
Sets to enable the justify last line
setLocked(boolean) - Method in interface com.keikai.client.api.Protection
Sets to be locked or not.
setName(String) - Method in interface com.keikai.client.api.Font
Sets the name
setNumberFormat(NumberFormat) - Method in interface com.keikai.client.api.CellStyle
Sets the number format.
setOutline(boolean) - Method in interface com.keikai.client.api.Font
Sets to enable the outline or not
setPatternType(Fill.PatternFill.PatternType) - Method in interface com.keikai.client.api.Fill.PatternFill
Sets pattern type
setPivotButton(boolean) - Method in interface com.keikai.client.api.CellStyle
Sets to enable or disable the pivot button
setPosition(int) - Method in interface com.keikai.client.api.Stop
 
setProtection(Protection) - Method in interface com.keikai.client.api.CellStyle
Sets the protection.
setQuotePrefix(boolean) - Method in interface com.keikai.client.api.CellStyle
Sets to enable or disable the quote prefix.
setReadingOrder(Alignment.ReadingOrder) - Method in interface com.keikai.client.api.Alignment
Sets the reading order.
setRelativeIndent(int) - Method in interface com.keikai.client.api.Alignment
Sets the relative indent.
setScheme(String) - Method in interface com.keikai.client.api.Font
Sets the scheme
setShadow(boolean) - Method in interface com.keikai.client.api.Font
Sets to enable the shadow or not
setSheetVisible(String) - Method in interface com.keikai.client.api.Spreadsheet
Sets the visibility of this active worksheet.
setShowError(boolean) - Method in interface com.keikai.client.api.DataValidation
Sets to show the error message message whenever the user enters invalid data.
setShowInput(boolean) - Method in interface com.keikai.client.api.DataValidation
Sets to show the input message whenever the user selects a cell in the data validation range.
setShrinkToFit(boolean) - Method in interface com.keikai.client.api.Alignment
Sets to enable the shrink to fit
setSize(int) - Method in interface com.keikai.client.api.Font
Sets the size
setStrike(boolean) - Method in interface com.keikai.client.api.Font
sets to enable the strike or not
setStyle(Border.Style) - Method in interface com.keikai.client.api.Border
Sets the border style.
setStyle(Border.Style) - Method in interface com.keikai.client.api.Borders
Sets the border style.
setSubscript(boolean) - Method in interface com.keikai.client.api.Font
Sets to enable the subscript or not
setSuperscript(boolean) - Method in interface com.keikai.client.api.Font
Sets to enable the superscript or not
setTextRotation(int) - Method in interface com.keikai.client.api.Alignment
Sets the text rotation
setThemeColor(Border.ThemeColor) - Method in interface com.keikai.client.api.Border
Sets the border theme color.
setThemeColor(Border.ThemeColor) - Method in interface com.keikai.client.api.Borders
Sets the border theme color.
Settings - Class in com.keikai.client.api
A Keikai Spreadsheet client settings
Settings() - Constructor for class com.keikai.client.api.Settings
 
Settings.Key - Enum in com.keikai.client.api
The setting keys
setType(DataValidation.Type) - Method in interface com.keikai.client.api.DataValidation
Sets the data validation type (only supports DataValidation.Type.List)
setUnderline(Font.Underline) - Method in interface com.keikai.client.api.Font
Sets the underline
setVertical(Alignment.Vertical) - Method in interface com.keikai.client.api.Alignment
Sets the vertical
setVisible(Worksheet.Visibility) - Method in interface com.keikai.client.api.Worksheet
Sets the visibility of this sheet.
setWrapText(boolean) - Method in interface com.keikai.client.api.Alignment
Sets to enable the wrap text
Spreadsheet - Interface in com.keikai.client.api
A Keikai Spreadsheet client interface.
Stop - Interface in com.keikai.client.api
 

T

toJSON(Object) - Static method in class com.keikai.util.Converter
 
toJSONString() - Method in enum com.keikai.client.api.Alignment.Horizontal
 
toJSONString() - Method in enum com.keikai.client.api.Alignment.ReadingOrder
 
toJSONString() - Method in enum com.keikai.client.api.Alignment.Vertical
 
toJSONString() - Method in enum com.keikai.client.api.Border.Style
 
toJSONString() - Method in enum com.keikai.client.api.Border.ThemeColor
 
toJSONString() - Method in enum com.keikai.client.api.Borders.BorderIndex
 
toJSONString() - Method in enum com.keikai.client.api.DataValidation.AlertStyle
 
toJSONString() - Method in enum com.keikai.client.api.DataValidation.Type
 
toJSONString() - Method in enum com.keikai.client.api.Fill.PatternFill.PatternType
 
toJSONString() - Method in enum com.keikai.client.api.Font.Underline
 
toJSONString() - Method in enum com.keikai.client.api.Range.AutoFilterOperator
 
toJSONString() - Method in enum com.keikai.client.api.Range.DeleteShiftDirection
 
toJSONString() - Method in enum com.keikai.client.api.Range.InsertFormatOrigin
 
toJSONString() - Method in enum com.keikai.client.api.Range.InsertShiftDirection
 
toJSONString() - Method in enum com.keikai.client.api.Worksheet.Visibility
 
toMap(Object...) - Static method in class com.keikai.util.Maps
 
toString() - Method in class com.keikai.client.api.event.RangeEvent
 
toString() - Method in class com.keikai.util.Ref
 

U

UID - Static variable in class com.keikai.client.Version
 

V

valueOf(String) - Static method in enum com.keikai.client.api.Alignment.Horizontal
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.keikai.client.api.Alignment.ReadingOrder
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.keikai.client.api.Alignment.Vertical
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.keikai.client.api.Border.Style
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.keikai.client.api.Border.ThemeColor
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.keikai.client.api.Borders.BorderIndex
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.keikai.client.api.DataValidation.AlertStyle
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.keikai.client.api.DataValidation.Type
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.keikai.client.api.Fill.PatternFill.PatternType
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.keikai.client.api.Font.Underline
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.keikai.client.api.Range.AutoFilterOperator
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.keikai.client.api.Range.DeleteShiftDirection
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.keikai.client.api.Range.InsertFormatOrigin
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.keikai.client.api.Range.InsertShiftDirection
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.keikai.client.api.Settings.Key
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.keikai.client.api.Worksheet.Visibility
Returns the enum constant of this type with the specified name.
values() - Static method in enum com.keikai.client.api.Alignment.Horizontal
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.keikai.client.api.Alignment.ReadingOrder
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.keikai.client.api.Alignment.Vertical
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.keikai.client.api.Border.Style
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.keikai.client.api.Border.ThemeColor
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.keikai.client.api.Borders.BorderIndex
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.keikai.client.api.DataValidation.AlertStyle
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.keikai.client.api.DataValidation.Type
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.keikai.client.api.Fill.PatternFill.PatternType
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.keikai.client.api.Font.Underline
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.keikai.client.api.Range.AutoFilterOperator
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.keikai.client.api.Range.DeleteShiftDirection
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.keikai.client.api.Range.InsertFormatOrigin
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.keikai.client.api.Range.InsertShiftDirection
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.keikai.client.api.Settings.Key
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.keikai.client.api.Worksheet.Visibility
Returns an array containing the constants of this enum type, in the order they are declared.
Version - Class in com.keikai.client
 
Version() - Constructor for class com.keikai.client.Version
 

W

Workbook - Interface in com.keikai.client.api
A workbook represents a book in a spreadsheet.
Worksheet - Interface in com.keikai.client.api
A worksheet represents a sheet in a workbook.
Worksheet.Visibility - Enum in com.keikai.client.api
Visibility attributes that can be applied.
A B C D E F G H I K L M N O P R S T U V W 
Skip navigation links

Copyright © 2017. All rights reserved.