se.optimatika.jexcel
Class OnFileSpreadsheet

java.lang.Object
  se.optimatika.jexcel.OnFileSpreadsheet

All Implemented Interfaces:

Spreadsheet

public class OnFileSpreadsheet
extends Object
implements Spreadsheet

Constructor Summary

OnFileSpreadsheet(File aFile)

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	revert() Undo changes.
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()
void	writeToFile(File aFile)

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

OnFileSpreadsheet

public OnFileSpreadsheet(File aFile)

Method Detail

activateSheet

public void activateSheet(String aName)

Specified by:

activateSheet in interface Spreadsheet

getBooleanCellValue

public Boolean getBooleanCellValue()

Specified by:

getBooleanCellValue in interface Spreadsheet

getDateCellValue

public Date getDateCellValue()

Specified by:

getDateCellValue in interface Spreadsheet

getMatrixSheetValue

public BasicMatrix getMatrixSheetValue()

Specified by:

getMatrixSheetValue in interface Spreadsheet

getNumberCellValue

public Number getNumberCellValue()

Specified by:

getNumberCellValue in interface Spreadsheet

getSheetNames

public String[] getSheetNames()

Specified by:

getSheetNames in interface Spreadsheet

getStringCellValue

public String getStringCellValue()

Specified by:

getStringCellValue in interface Spreadsheet

goHome

public void goHome()

Specified by:

goHome in interface Spreadsheet

goTo

public void goTo(int aColumn,
                 int aRow)

Specified by:

goTo in interface Spreadsheet

goToFirstColumnOnNextRow

public void goToFirstColumnOnNextRow()

Specified by:

goToFirstColumnOnNextRow in interface Spreadsheet

goToFirstRowInNextColumn

public void goToFirstRowInNextColumn()

Specified by:

goToFirstRowInNextColumn in interface Spreadsheet

goToNextColumn

public void goToNextColumn()

Specified by:

goToNextColumn in interface Spreadsheet

goToNextRow

public void goToNextRow()

Specified by:

goToNextRow in interface Spreadsheet

revert

public void revert()

Undo changes. Revert to last saved file.

setBooleanCellValue

public void setBooleanCellValue(Boolean aCellValue)

Specified by:

setBooleanCellValue in interface Spreadsheet

setBooleanColumnValues

public void setBooleanColumnValues(List<Boolean> someColumnValues)

Specified by:

setBooleanColumnValues in interface Spreadsheet

setBooleanRowValues

public void setBooleanRowValues(List<Boolean> someRowValues)

Specified by:

setBooleanRowValues in interface Spreadsheet

setDateCellValue

public void setDateCellValue(Date aCellValue)

Specified by:

setDateCellValue in interface Spreadsheet

setDateColumnValues

public void setDateColumnValues(List<Date> someColumnValues)

Specified by:

setDateColumnValues in interface Spreadsheet

setDateRowValues

public void setDateRowValues(List<Date> someRowValues)

Specified by:

setDateRowValues in interface Spreadsheet

setMatrixSheetValue

public void setMatrixSheetValue(BasicMatrix aSheetValue)

Specified by:

setMatrixSheetValue in interface Spreadsheet

setNumberCellValue

public void setNumberCellValue(Number aCellValue)

Specified by:

setNumberCellValue in interface Spreadsheet

setNumberCellValue

public void setNumberCellValue(Number aCellValue,
                               String aPattern)

Specified by:

setNumberCellValue in interface Spreadsheet

setNumberColumnValues

public void setNumberColumnValues(List<Number> someColumnValues)

Specified by:

setNumberColumnValues in interface Spreadsheet

setNumberRowValues

public void setNumberRowValues(List<Number> someRowValues)

Specified by:

setNumberRowValues in interface Spreadsheet

setStringCellValue

public void setStringCellValue(String aCellValue)

Specified by:

setStringCellValue in interface Spreadsheet

setStringColumnValues

public void setStringColumnValues(List<String> someColumnValues)

Specified by:

setStringColumnValues in interface Spreadsheet

setStringRowValues

public void setStringRowValues(List<String> someRowValues)

Specified by:

setStringRowValues in interface Spreadsheet

setTableSheetValue

public void setTableSheetValue(Table aSheetValue)

Specified by:

setTableSheetValue in interface Spreadsheet

toByteArray

public byte[] toByteArray()

Specified by:

toByteArray in interface Spreadsheet

writeToFile

public void writeToFile()

writeToFile

public void writeToFile(File aFile)

Specified by:

writeToFile in interface Spreadsheet