com.extentech.ExtenXLS.web
Class FileWebWorkBook

java.lang.Object
  com.extentech.ExtenXLS.DocumentHandle
      com.extentech.ExtenDOC.DocHandle
          com.extentech.ExtenXLS.web.MemeDocument
              com.extentech.ExtenXLS.web.MemeWorkBook
                  com.extentech.ExtenXLS.web.WebWorkBook
                      com.extentech.ExtenXLS.web.FileWebWorkBook

All Implemented Interfaces:

Document, Handle, WorkBook, com.extentech.toolkit.LogOutputter

public class FileWebWorkBook
extends WebWorkBook

The FileWorkBook class provides additional functionality to the WorkBookHandle class to allow it to participate in a Service-Oriented-Architecture. The additional functionality of the WebWorkBook relates to version and access control using a hosted architecture to provide for the security and versioning repository. The FileWebWorkBook uses a File as its data source.

Author:

John McMahon -- Copyright ©2010 Extentech Inc.

See Also:

WorkBook, WorkBookHandle, http://www.sheetster.com

Field Summary

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

ACCESS_STATUS_PRIVATE, ACCESS_STATUS_PUBLIC, ACCESS_STATUS_SHARED, FILE_TYPE_NATIVE, FILE_TYPE_XLS, FILE_TYPE_XLSX, FILE_TYPE_XMLSS, STORAGE_LOCATION_DB, STORAGE_LOCATION_FILESYSTEM, STORAGE_LOCATION_S3

Fields inherited from interface com.extentech.ExtenXLS.WorkBook

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

Constructor Summary

FileWebWorkBook(Connection conn, int midi)

FileWebWorkBook(Connection conn, int midi, File f)

Method Summary

void	deleteBook(WorkBook book, int memeid) Deletes the meme record
WorkBook	getBook(int memeid) retrieves XML bytes for database record ID and converts to XLS WorkBook
List	getRESTlog()
File	getWorkBookFile()
InputStream	getXMLStream(int memeid) retrieves XML bytes for database record ID
void	saveBook(int memeid)
void	setWorkBookFile(File w)

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

applyDiff, commit, convertDocumentToInputStream, getDiff, getDiffs, getLatestXML, incrementVersionNumber, init, printDocument, revertDiff

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

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

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

addUser, appendOutputDir, bindData, createPage, deleteDoc, documentStorageLocation, getAllDiffs, getBook, getConcurrentUsers, getConnection, getCryptPass, getDataFactory, getDatamapping, getDefaultFileString, getFileName, getLatestDiff, getMemeId, getMemeType, getMessageManager, getNumPages, getOutputDir, getOwnerId, getPages, getRESTEmit, getSaveAsFileType, getScript, getServerURL, getSession, getSharingAccess, getStorageLocation, getTempfile, isPublic, isSaved, load, loadDataDefinition, loadDataDefinition, log, log, log, main, revert, save, setConnection, setCryptPass, setDataFactory, setDatamapping, setMemeId, setMemeType, setMessageManager, setOutputDir, setOwnerId, setRESTlog, setSaveAsFileType, setSaved, setScript, setServerURL, setSession, setSharingAccess, setStorageLocation, setTempfile, setVal, store, storeDiff, storeNewDocument

Methods inherited from class com.extentech.ExtenDOC.DocHandle

getAllText, getFormatHandles, getPage, getParagraphs, getTextRangeHandles, getVersion, getXHTML, setFileName, setXHTML

Methods inherited from class com.extentech.ExtenXLS.DocumentHandle

getLEOFile

Methods inherited from class java.lang.Object

getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface com.extentech.ExtenXLS.WorkBook

addProperty, addSheetFromWorkBook, 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

Methods inherited from interface com.extentech.toolkit.LogOutputter

log, log, log

Constructor Detail

FileWebWorkBook

public FileWebWorkBook(Connection conn,
                       int midi)

FileWebWorkBook

public FileWebWorkBook(Connection conn,
                       int midi,
                       File f)

Method Detail

getWorkBookFile

public File getWorkBookFile()

Returns:

Returns the workBookFile.

setWorkBookFile

public void setWorkBookFile(File w)

Parameters:

workBookFile - The workBookFile to set.

getRESTlog

public List getRESTlog()

Overrides:

getRESTlog in class MemeDocument

Returns:

Returns the restlog.

See Also:

MemeDocument.getRESTlog()

deleteBook

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

Description copied from class: MemeDocument

Deletes the meme record

Overrides:

deleteBook in class MemeDocument

Parameters:

book - WorkBookHandle

memeid - int ID of this meme database record

Throws:

SQLException

See Also:

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

getBook

public WorkBook getBook(int memeid)
                 throws SQLException

Description copied from class: MemeDocument

retrieves XML bytes for database record ID and converts to XLS WorkBook

Overrides:

getBook in class MemeDocument

Returns:

WorkBookHandle

Throws:

SQLException

See Also:

MemeDocument.getBook(int)

getXMLStream

public InputStream getXMLStream(int memeid)
                         throws SQLException

Description copied from class: MemeDocument

retrieves XML bytes for database record ID

Overrides:

getXMLStream in class MemeDocument

Returns:

WorkBookHandle

Throws:

SQLException

See Also:

MemeDocument.getXMLStream(int)

saveBook

public void saveBook(int memeid)
              throws Exception

Throws:

Exception

See Also:

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