com.extentech.ExtenXLS.web
Class FileWebWorkBook

java.lang.Object
  com.extentech.ExtenXLS.WorkBookHandle
      com.extentech.ExtenXLS.web.MemeWorkBook
          com.extentech.ExtenXLS.web.WebWorkBook
              com.extentech.ExtenXLS.web.FileWebWorkBook

All Implemented Interfaces:

Handle, WorkBook, com.extentech.toolkit.LogOutputter

public class FileWebWorkBook
extends WebWorkBook

------------------------------------------------------------

Author:

John McMahon :: [ Jul 31, 2008 ] :: Copyright ©2006 Extentech Inc.

Field Summary

Fields inherited from class com.extentech.ExtenXLS.web.MemeWorkBook

ACCESS_STATUS_PRIVATE, ACCESS_STATUS_PUBLIC, ACCESS_STATUS_SHARED

Fields inherited from class com.extentech.ExtenXLS.WorkBookHandle

CONVERTMULBLANKS

Fields inherited from interface com.extentech.ExtenXLS.WorkBook

ALLOWDUPES, CALCULATE_ALWAYS, CALCULATE_AUTO, CALCULATE_EXPLICIT, DEBUG_HIGH, DEBUG_LOW, DEBUG_MEDIUM, SHAREDUPES, STRING_ENCODING_AUTO, STRING_ENCODING_COMPRESSED, STRING_ENCODING_UNICODE

Constructor Summary

FileWebWorkBook(java.sql.Connection conn, int midi)

FileWebWorkBook(java.sql.Connection conn, int midi, java.io.File f)

Method Summary

void	deleteBook(WorkBook book, int memeid) ------------------------------------------------------------
WorkBook	getBook(int memeid) ------------------------------------------------------------
java.util.List	getRESTlog() ------------------------------------------------------------
java.io.File	getWorkBookFile() ------------------------------------------------------------
java.io.InputStream	getXMLStream(int memeid) ------------------------------------------------------------
void	saveBook(int memeid) ------------------------------------------------------------
void	setWorkBookFile(java.io.File w) ------------------------------------------------------------
int	storeNewBook() ------------------------------------------------------------
WorkBook	update() ------------------------------------------------------------

Methods inherited from class com.extentech.ExtenXLS.web.WebWorkBook

applyDiff, commit, convertDocumentToInputStream, getDiff, getDiffs, getLatestXML, getServerURL, getSession, getTempfile, incrementVersionNumber, init, isSaved, printDocument, revert, setOutputDir, setRESTlog, setSaved, setServerURL, setSession, setTempfile

Methods inherited from class com.extentech.ExtenXLS.web.MemeWorkBook

addUser, appendOutputDir, bindData, getAllDiffs, getConcurrentUsers, getConnection, getCryptPass, getDataFactory, getDatamapping, getDefaultFileString, getDescription, getLatestDiff, getMemeId, getMemeType, getMessageManager, getOutputDir, getOwnerId, getRESTEmit, getSharingAccess, isPublic, isStoreAsXML, isStoreBookAsFile, loadDataDefinition, loadDataDefinition, log, log, log, main, setConnection, setCryptPass, setDataFactory, setDatamapping, setDescription, setMemeId, setMemeType, setMessageManager, setOwnerId, setSharingAccess, setStoreAsXML, setStoreBookAsFile, storeDiff

Methods inherited from class com.extentech.ExtenXLS.WorkBookHandle

addProperty, addSheetFromWorkBook, addSheetFromWorkBookWithFormatting, addWorkSheet, addWorkSheet, calculateFormulas, close, copyChartToSheet, copyChartToSheet, copyWorkSheet, createChart, createNamedRange, createWorkSheet, createWorkSheet, deleteChart, finalize, getBytes, getCell, getCellRanges, getCells, getChart, getChartById, getCharts, getFactory, getFormats, getFormulaCalculationMode, getFormulaHandle, getImage, getImages, getIsExcel2007, getName, getNamedRange, getNamedRanges, getNoSheetWorkBook, getNumCells, getNumWorkSheets, getPivotTable, getPivotTables, getProperties, getProperty, getStats, getVersion, getWorkBook, getWorkingDirectory, getWorkSheet, getWorkSheet, getWorkSheets, getXLSVersionString, is1904, removeAllWorkSheets, reset, searchAndReplace, setDebugLevel, setDefaultColWidth, setDefaultRowHeight, setDupeStringMode, setFormulaCalculationMode, setName, setProperties, setProtected, setStringEncodingMode, toString, write, write, write, write, writeBytes, writeXLSXBytes

Methods inherited from class java.lang.Object

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

Methods inherited from interface com.extentech.ExtenXLS.WorkBook

addProperty, addSheetFromWorkBook, addWorkSheet, addWorkSheet, calculateFormulas, copyChartToSheet, copyChartToSheet, copyWorkSheet, createWorkSheet, getBytes, getCell, getCells, getChart, getCharts, getFormats, getFormulaCalculationMode, getName, getNamedRange, getNamedRanges, getNoSheetWorkBook, getNumCells, getPivotTable, getPivotTables, getProperty, getWorkBook, getWorkingDirectory, getWorkSheet, getWorkSheet, getWorkSheets, removeAllWorkSheets, reset, setDebugLevel, setDefaultColWidth, setDefaultRowHeight, setDupeStringMode, setFormulaCalculationMode, setName, setProtected, setStringEncodingMode, toString, writeBytes

Constructor Detail

FileWebWorkBook

public FileWebWorkBook(java.sql.Connection conn,
                       int midi)

FileWebWorkBook

public FileWebWorkBook(java.sql.Connection conn,
                       int midi,
                       java.io.File f)

Method Detail

getWorkBookFile

public java.io.File getWorkBookFile()

------------------------------------------------------------

Returns:

Returns the workBookFile.

setWorkBookFile

public void setWorkBookFile(java.io.File w)

------------------------------------------------------------

Parameters:

workBookFile - The workBookFile to set.

getRESTlog

public java.util.List getRESTlog()

------------------------------------------------------------

Overrides:

getRESTlog in class WebWorkBook

Returns:

Returns the restlog.

See Also:

WebWorkBook.getRESTlog()

storeNewBook

public int storeNewBook()
                 throws java.sql.SQLException

------------------------------------------------------------

Overrides:

storeNewBook in class WebWorkBook

Throws:

java.sql.SQLException

See Also:

com.extentech.ExtenXLS.web.WebWorkBook#storeBook(com.extentech.ExtenXLS.WorkBook)

update

public WorkBook update()

------------------------------------------------------------

Overrides:

update in class WebWorkBook

Returns:

new WorkBook

See Also:

WebWorkBook.update()

deleteBook

public void deleteBook(WorkBook book,
                       int memeid)
                throws java.sql.SQLException

------------------------------------------------------------

Overrides:

deleteBook in class MemeWorkBook

Parameters:

book - WorkBookHandle

memeid - int ID of this meme database record

Throws:

java.sql.SQLException

See Also:

MemeWorkBook.deleteBook(com.extentech.ExtenXLS.WorkBook, int)

getBook

public WorkBook getBook(int memeid)
                 throws java.sql.SQLException

------------------------------------------------------------

Overrides:

getBook in class MemeWorkBook

Returns:

WorkBookHandle

Throws:

java.sql.SQLException

See Also:

MemeWorkBook.getBook(int)

getXMLStream

public java.io.InputStream getXMLStream(int memeid)
                                 throws java.sql.SQLException

------------------------------------------------------------

Overrides:

getXMLStream in class MemeWorkBook

Returns:

WorkBookHandle

Throws:

java.sql.SQLException

See Also:

MemeWorkBook.getXMLStream(int)

saveBook

public void saveBook(int memeid)
              throws java.lang.Exception

------------------------------------------------------------

Overrides:

saveBook in class MemeWorkBook

Parameters:

memeid - int ID of this meme database record

Throws:

java.sql.SQLException

java.lang.Exception

See Also:

com.extentech.ExtenXLS.web.MemeWorkBook#saveBook(com.extentech.ExtenXLS.WorkBook, int)