se.optimatika.jexcel
Interface Spreadsheet

All Known Implementing Classes:

AdaptingSpreadsheet, BlackLittermanSpreadsheet, DatabaseSpreadsheet, InMemorySpreadsheet, OnFileSpreadsheet

public interface Spreadsheet

A Spreadsheet actually refers to a collection of (spread)sheets. Just like a Workbook...

Author:

apete

Method Summary

void	activateSheet(String aName)
Boolean	getBooleanCellValue()
Date	getDateCellValue()
BasicMatrix	getMatrixSheetValue()
Number	getNumberCellValue()
String[]	getSheetNames()
String	getStringCellValue()
void	goHome()
void	goTo(int aColumn, int aRow)
void	goToFirstColumnOnNextRow()
void	goToFirstRowInNextColumn()
void	goToNextColumn()
void	goToNextRow()
void	setBooleanCellValue(Boolean aCellValue)
void	setBooleanColumnValues(List<Boolean> someColumnValues)
void	setBooleanRowValues(List<Boolean> someRowValues)
void	setDateCellValue(Date aCellValue)
void	setDateColumnValues(List<Date> someColumnValues)
void	setDateRowValues(List<Date> someRowValues)
void	setMatrixSheetValue(BasicMatrix aSheetValue)
void	setNumberCellValue(Number aCellValue)
void	setNumberCellValue(Number aCellValue, String aPattern)
void	setNumberColumnValues(List<Number> someColumnValues)
void	setNumberRowValues(List<Number> someRowValues)
void	setStringCellValue(String aCellValue)
void	setStringColumnValues(List<String> someColumnValues)
void	setStringRowValues(List<String> someRowValues)
void	setTableSheetValue(Table aSheetValue)
byte[]	toByteArray()
void	writeToFile(File aFile)

Method Detail

activateSheet

void activateSheet(String aName)

getBooleanCellValue

Boolean getBooleanCellValue()

getDateCellValue

Date getDateCellValue()

getMatrixSheetValue

BasicMatrix getMatrixSheetValue()

getNumberCellValue

Number getNumberCellValue()

getSheetNames

String[] getSheetNames()

getStringCellValue

String getStringCellValue()

goHome

void goHome()

goTo

void goTo(int aColumn,
          int aRow)

goToFirstColumnOnNextRow

void goToFirstColumnOnNextRow()

goToFirstRowInNextColumn

void goToFirstRowInNextColumn()

goToNextColumn

void goToNextColumn()

goToNextRow

void goToNextRow()

setBooleanCellValue

void setBooleanCellValue(Boolean aCellValue)

setBooleanColumnValues

void setBooleanColumnValues(List<Boolean> someColumnValues)

setBooleanRowValues

void setBooleanRowValues(List<Boolean> someRowValues)

setDateCellValue

void setDateCellValue(Date aCellValue)

setDateColumnValues

void setDateColumnValues(List<Date> someColumnValues)

setDateRowValues

void setDateRowValues(List<Date> someRowValues)

setMatrixSheetValue

void setMatrixSheetValue(BasicMatrix aSheetValue)

setNumberCellValue

void setNumberCellValue(Number aCellValue)

setNumberCellValue

void setNumberCellValue(Number aCellValue,
                        String aPattern)

setNumberColumnValues

void setNumberColumnValues(List<Number> someColumnValues)

setNumberRowValues

void setNumberRowValues(List<Number> someRowValues)

setStringCellValue

void setStringCellValue(String aCellValue)

setStringColumnValues

void setStringColumnValues(List<String> someColumnValues)

setStringRowValues

void setStringRowValues(List<String> someRowValues)

setTableSheetValue

void setTableSheetValue(Table aSheetValue)

toByteArray

byte[] toByteArray()

writeToFile

void writeToFile(File aFile)