se.optimatika.jexcel
Class OnFileSpreadsheet

java.lang.Object
  extended by 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