Overview  Package  Class   Use  Tree  Deprecated  Index  Help 
 PREV   NEXT FRAMES    NO FRAMES    

Uses of Interface
com.extentech.ExtenXLS.WorkBook

Packages that use WorkBook
com.extentech.ExtenXLS The ExtenXLS package contains the primary classes for working with spreadsheets. 
com.extentech.ExtenXLS.binder The ExtenXLS binder package contains the CellBinder API which automates mapping of data to spreadsheets. 
com.extentech.ExtenXLS.web The ExtenXLS.web package contains ExtenXLS Spreadsheet classes enhanced with web and database persistence capabilities. 
 

Uses of WorkBook in com.extentech.ExtenXLS
 

Classes in com.extentech.ExtenXLS that implement WorkBook
 class EncryptedWorkBookHandle
          EncryptedWorkBookHandle is a WorkBookHandle that manages encrypted files.
 class EncryptedWorkBookWritableParser
          EncryptedWorkBookWritableParser is a type of WorkBookWritableParser that handles encrypting the output file.
 class WorkBookHandle
          The WorkBookHandle provides a handle to the XLS file and includes convenience methods for working with the WorkSheets and Cell values within the XLS file.
 class WorkBookParser
          A READ-ONLY WorkBookHandle implementation which handles high-performance spreadsheet reading using a parse-event driven model.
 class WorkBookWritableParser
          A WorkBookHandle implementation which handles high-performance spreadsheet reading using a parse-event driven model.
 

Methods in com.extentech.ExtenXLS that return WorkBook
 WorkBook WorkSheet.getWorkBook()
           
 WorkBook CellRange.getWorkBook()
           
 WorkBook CellHandle.getWorkBook()
          returns the WorkBookHandle for this Cell
static WorkBook ExtenXLS.getXLS(java.lang.Object xmlsource)
          Convert an XML WorkBook file to BIFF8 (native XLS) WorkBook Input roughly conforms to XMLSS Spec.
static WorkBook ExtenXLS.getXLS(WorkBookHandle bk, java.lang.Object xmlsource)
          Convert an XML WorkBook file to BIFF8 (native XLS) WorkBook Input roughly conforms to XMLSS Spec.
static WorkBook ExtenXLS.getXLS(WorkBook bk, java.lang.Object xmlsource)
          Convert a WorkBook XML file to BIFF8 (native XLS) WorkBook Input roughly conforms to XMLSS Spec.
 

Methods in com.extentech.ExtenXLS with parameters of type WorkBook
static void ExtenXLS.dumpCSVtoSpreadsheet(java.io.File csv, WorkBook book, int sheetnum)
          simply read the csv into a workbook set the "com.extentech.extenxls.csvdelimiter" system property to change the delimiter aka: System.getProperties().setProperty("com.extentech.extenxls.csvdelimiter", "|");
static void ExtenXLS.dumpCSVtoSpreadsheet(java.io.InputStream csv, WorkBook book, int sheetnum)
          simply read the csv into a workbook set the "com.extentech.extenxls.csvdelimiter" system property to change the delimiter aka: System.getProperties().setProperty("com.extentech.extenxls.csvdelimiter", "|");
static org.json.JSONArray CellRange.getJSON(java.lang.String range, WorkBook wbh)
          return a JSON array of cell values for the given range
static version
static java.io.File ExtenXLS.getPDF(WorkBook book)
          /** return a File object representing the Pdf interpretation of this workbook
static java.io.File ExtenXLS.getPDF(WorkBook book, double h, double w)
          /** return a File object representing the Pdf interpretation of this workbook
static java.lang.String ExtenXLS.getSheetXML(WorkBook mybook, java.lang.String sheetname)
          Get the XML for a worksheet
static java.lang.String ExtenXLS.getSheetXML(WorkBook mybook, java.lang.String sheetname, int maxrows, int maxcols)
          Get the XML for a worksheet Add the ability to return a maximum number of rows and cols -1 returns all cols/rows
static WorkBook ExtenXLS.getXLS(WorkBook bk, java.lang.Object xmlsource)
          Convert a WorkBook XML file to BIFF8 (native XLS) WorkBook Input roughly conforms to XMLSS Spec.
static java.lang.String ExtenXLS.getXML(WorkBook mybook)
          Convert a BIFF8 (native XLS) file to XML one sheet at a time.
static java.lang.String ExtenXLS.getXML(WorkBook mybook, java.lang.String sheetname)
          Convert a BIFF8 (native XLS) file to XML.
static java.lang.String ExtenXLS.getXML(WorkBook mybook, java.lang.String sheetname, int maxrows, int maxcols)
          Convert a BIFF8 (native XLS) file to XML.
static java.lang.String ExtenXLS.getXMLFragment(WorkBook mybook, java.lang.String fragspec)
          Retrieves an XML 'fragment' from the Specified WorkBook.
static void ExtenXLS.parseNBind(WorkBook bk, java.lang.Object input)
          Read in an XML stream and populate a WorkBook using the XML data therein.
 void CellRange.setWorkBook(WorkBook bk)
          attach the workbook for this CellRange
static void ExtenXLS.transform(java.io.OutputStream out, java.lang.String xslfile, WorkBook book, java.util.Map params)
          Transform a WorkBook into an output file type by applying an XSLT.
static org.jdom.Document ExtenXLS.transform(java.lang.String xslfile, WorkBook book)
          Transform a WorkBook into an output file type by applying an XSLT.
static org.jdom.Document ExtenXLS.transform(java.lang.String xslfile, WorkBook book, java.util.Map params)
          Transform a WorkBook into an output file type by applying an XSLT.
static void ExtenXLS.writeBookToFile(java.lang.String strFileName, WorkBook mybook)
          Write book to File using Buffered Output Stream
static void ExtenXLS.writeXML(WorkBook mybook, java.lang.String sheetname, java.io.OutputStream out)
          Convert a BIFF8 (native XLS) file to XML.
static void ExtenXLS.writeXML(WorkBook mybook, java.lang.String sheetname, java.io.OutputStream out, int maxrows, int maxcols)
          Convert a BIFF8 (native XLS) file to XML.
static void ExtenXLS.writeXML(WorkBook mybook, java.lang.String sheetname, java.io.OutputStream out, int maxrows, int maxcols, boolean convertToUnicodeFont)
          Convert a BIFF8 (native XLS) file to XML.
 

Constructors in com.extentech.ExtenXLS with parameters of type WorkBook
CellHandle(com.extentech.formats.XLS.BiffRec c, WorkBook myb)
          Public Constructor added for use in Bean-context ONLY.
CellRange(java.lang.String range, WorkBook bk)
          Constructor which creates a new CellRange from a String range
The String range must be in the format Sheet!CR:CR
For Example, "Sheet1!C9:I19"
CellRange(java.lang.String range, WorkBook bk, boolean c)
          Constructor which creates a new CellRange from a String range
The String range must be in the format Sheet!CR:CR
For Example, "Sheet1!C9:I19"
CellRange(java.lang.String range, WorkBook bk, boolean createblanks, boolean initcells)
          Constructor which creates a new CellRange from a String range
The String range must be in the format Sheet!CR:CR
For Example, "Sheet1!C9:I19"
ChartSeriesHandle(com.extentech.formats.XLS.charts.Series series, WorkBook wbk)
          Constructor, used internally.
FormatHandle(WorkBook book)
          Constructs a FormatHandle for the given WorkBook's default format.
FormatHandle(WorkBook workBook, int i)
          Jan 27, 2011
FormatHandle(WorkBook book, java.lang.String fontname, int fontstyle, int fontsize)
           
FormatHandle(WorkBook book, com.extentech.formats.XLS.Xf xfr)
          Constructs a FormatHandle for the given WorkBook and format record.
 

Uses of WorkBook in com.extentech.ExtenXLS.binder
 

Methods in com.extentech.ExtenXLS.binder that return WorkBook
 WorkBook ExtenXLSReportFactory.generateWorkBookHandle(java.util.Map vars)
          this method returns a WorkBookHandle populated with values from the CellBinder.
 WorkBook ExtenXLSReportFactory.generateWorkBookHandle(java.util.Map vars, boolean resettrackers)
          this method returns a WorkBookHandle populated with values from the CellBinder.
 WorkBook ExtenXLSReportFactory.getWorkBook()
           
 

Methods in com.extentech.ExtenXLS.binder with parameters of type WorkBook
 void SimpleCellBinder.findTokens(WorkBook bk)
          returns a list of all cells within the workbook containing the mapping tokens.
 byte[] XMLCellBinder.reverseMapToXML(WorkBook bk, RelationalObject xmlMappings)
          takes XML mapping file *based* on RDF Format and workbook and create XML based on cellrange elements in RDF and values in book reads in nodes where parambinding string is in the form of: leafnode|xx|xx:xx:Node-type[:subnode-type ...]]
 void ExtenXLSReportFactory.setWorkBook(WorkBook book)
           
 

Constructors in com.extentech.ExtenXLS.binder with parameters of type WorkBook
BeanBoundCellRange(java.lang.String range, WorkBook b, boolean createblanks)
           
CellBinder(WorkBook b, DataObject cn, com.extentech.toolkit.LogOutputter lgr)
          The CellBinder is responsible for managing the data bindings of a single connection (JDBC) with the Cells of a single com.extentech.ExtenXLS.WorkBook.
CellBinder(WorkBook b, com.extentech.toolkit.LogOutputter lgr)
          The CellBinder is responsible for managing the data bindings of a single connection (JDBC) with the Cells of a single com.extentech.ExtenXLS.WorkBook.
DataBoundCellRange(java.lang.String range, java.lang.String field, WorkBook b, boolean createblanks)
           
DataBoundCellRange(java.lang.String range, WorkBook b, boolean createblanks)
           
SimpleCellBinder(WorkBook book, SimpleDataObject dataObject)
          Constructor takes a workbook and dataobject and automatically maps the data.
 

Uses of WorkBook in com.extentech.ExtenXLS.web
 

Classes in com.extentech.ExtenXLS.web that implement WorkBook
 class MemeWorkBook
          This class provides Saving and Reconstituting WorkBooks as memes in the Extentech KB schema.
 class WebWorkBook
          The WebWorkBook class provides additional functionality to the WorkBookHandle class to allow it to participate in a Service-Oriented-Architecture.
 

Methods in com.extentech.ExtenXLS.web that return WorkBook
 WorkBook WebWorkBook.applyDiff(java.lang.StringBuffer diff)
          apply a single diff to a Document
 WorkBook MemeDocument.getBook(java.lang.Object memeid)
          Deprecated.  
 

Overview  Package  Class   Use  Tree  Deprecated  Index  Help 
 PREV   NEXT FRAMES    NO FRAMES    
Copyright © 2011 Extentech Inc. All Rights Reserved.