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

All Methods Instance Methods Abstract Methods
Modifier and Type	Method and Description
`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)
```

Interface Spreadsheet

Method Summary

Method Detail

activateSheet

getBooleanCellValue

getDateCellValue

getMatrixSheetValue

getNumberCellValue

getSheetNames

getStringCellValue

goHome

goTo

goToFirstColumnOnNextRow

goToFirstRowInNextColumn

goToNextColumn

goToNextRow

setBooleanCellValue

setBooleanColumnValues

setBooleanRowValues

setDateCellValue

setDateColumnValues

setDateRowValues

setMatrixSheetValue

setNumberCellValue

setNumberCellValue

setNumberColumnValues

setNumberRowValues

setStringCellValue

setStringColumnValues

setStringRowValues

setTableSheetValue

toByteArray

writeToFile