com.moyosoft.connector.ms.excel
Class Workbooks
java.lang.Object
|
+--java.util.AbstractCollection
|
+--com.moyosoft.connector.ms.excel.ExcelCollection
|
+--com.moyosoft.connector.ms.excel.Workbooks
- All Implemented Interfaces:
- java.util.Collection
- public class Workbooks
- extends ExcelCollection
|
Constructor Summary |
Workbooks(Dispatch dispatch)
|
|
Method Summary |
Workbook |
add()
|
Workbook |
add(java.lang.String templateFilename)
|
Workbook |
add(WBATemplate template)
|
boolean |
canCheckOut(java.io.File file)
|
void |
checkOut(java.io.File file)
|
void |
close()
|
int |
getCount()
|
Dispatch |
getDispatch()
|
Workbook |
getItem(int index)
|
Workbook |
getItem(java.lang.String name)
|
Workbook |
open(java.io.File file)
|
Workbook |
open(java.io.File file,
int updateLinks)
|
Workbook |
open(java.io.File file,
int updateLinks,
boolean readOnly)
|
Workbook |
open(java.io.File file,
int updateLinks,
boolean readOnly,
int format)
|
Workbook |
open(java.io.File file,
int updateLinks,
boolean readOnly,
int format,
java.lang.String password)
|
Workbook |
open(java.io.File file,
int updateLinks,
boolean readOnly,
int format,
java.lang.String password,
java.lang.String writeResPassword)
|
Workbook |
open(java.io.File file,
int updateLinks,
boolean readOnly,
int format,
java.lang.String password,
java.lang.String writeResPassword,
boolean ignoreReadOnlyRecommended)
|
Workbook |
open(java.io.File file,
int updateLinks,
boolean readOnly,
int format,
java.lang.String password,
java.lang.String writeResPassword,
boolean ignoreReadOnlyRecommended,
Platform origin)
|
Workbook |
open(java.io.File file,
int updateLinks,
boolean readOnly,
int format,
java.lang.String password,
java.lang.String writeResPassword,
boolean ignoreReadOnlyRecommended,
Platform origin,
java.lang.String delimiter)
|
Workbook |
open(java.io.File file,
int updateLinks,
boolean readOnly,
int format,
java.lang.String password,
java.lang.String writeResPassword,
boolean ignoreReadOnlyRecommended,
Platform origin,
java.lang.String delimiter,
boolean editable)
|
Workbook |
open(java.io.File file,
int updateLinks,
boolean readOnly,
int format,
java.lang.String password,
java.lang.String writeResPassword,
boolean ignoreReadOnlyRecommended,
Platform origin,
java.lang.String delimiter,
boolean editable,
boolean notify)
|
Workbook |
open(java.io.File file,
int updateLinks,
boolean readOnly,
int format,
java.lang.String password,
java.lang.String writeResPassword,
boolean ignoreReadOnlyRecommended,
Platform origin,
java.lang.String delimiter,
boolean editable,
boolean notify,
int converter)
|
Workbook |
open(java.io.File file,
int updateLinks,
boolean readOnly,
int format,
java.lang.String password,
java.lang.String writeResPassword,
boolean ignoreReadOnlyRecommended,
Platform origin,
java.lang.String delimiter,
boolean editable,
boolean notify,
int converter,
boolean addToMru)
|
Workbook |
open(java.io.File file,
int updateLinks,
boolean readOnly,
int format,
java.lang.String password,
java.lang.String writeResPassword,
boolean ignoreReadOnlyRecommended,
Platform origin,
java.lang.String delimiter,
boolean editable,
boolean notify,
int converter,
boolean addToMru,
boolean local)
|
Workbook |
open(java.io.File file,
int updateLinks,
boolean readOnly,
int format,
java.lang.String password,
java.lang.String writeResPassword,
boolean ignoreReadOnlyRecommended,
Platform origin,
java.lang.String delimiter,
boolean editable,
boolean notify,
int converter,
boolean addToMru,
boolean local,
CorruptLoad corruptLoad)
|
Workbook |
openDatabase(java.io.File file)
|
void |
openText(java.io.File file)
|
void |
openText(java.io.File file,
Platform origin)
|
void |
openText(java.io.File file,
Platform origin,
int startRow)
|
void |
openText(java.io.File file,
Platform origin,
int startRow,
TextParsingType dataType)
|
void |
openText(java.io.File file,
Platform origin,
int startRow,
TextParsingType dataType,
TextQualifier textQualifier)
|
void |
openText(java.io.File file,
Platform origin,
int startRow,
TextParsingType dataType,
TextQualifier textQualifier,
boolean consecutiveDelimiter)
|
void |
openText(java.io.File file,
Platform origin,
int startRow,
TextParsingType dataType,
TextQualifier textQualifier,
boolean consecutiveDelimiter,
boolean tab)
|
void |
openText(java.io.File file,
Platform origin,
int startRow,
TextParsingType dataType,
TextQualifier textQualifier,
boolean consecutiveDelimiter,
boolean tab,
boolean semicolon)
|
void |
openText(java.io.File file,
Platform origin,
int startRow,
TextParsingType dataType,
TextQualifier textQualifier,
boolean consecutiveDelimiter,
boolean tab,
boolean semicolon,
boolean comma)
|
void |
openText(java.io.File file,
Platform origin,
int startRow,
TextParsingType dataType,
TextQualifier textQualifier,
boolean consecutiveDelimiter,
boolean tab,
boolean semicolon,
boolean comma,
boolean space)
|
void |
openText(java.io.File file,
Platform origin,
int startRow,
TextParsingType dataType,
TextQualifier textQualifier,
boolean consecutiveDelimiter,
boolean tab,
boolean semicolon,
boolean comma,
boolean space,
boolean other)
|
void |
openText(java.io.File file,
Platform origin,
int startRow,
TextParsingType dataType,
TextQualifier textQualifier,
boolean consecutiveDelimiter,
boolean tab,
boolean semicolon,
boolean comma,
boolean space,
boolean other,
java.lang.String otherChar)
|
Workbook |
openXML(java.io.File file)
|
Workbook |
openXML(java.io.File file,
XmlLoadOption loadOption)
|
| Methods inherited from class java.util.AbstractCollection |
add, addAll, clear, contains, containsAll, isEmpty, removeAll, retainAll, toArray, toArray, toString |
| Methods inherited from class java.lang.Object |
equals, getClass, hashCode, notify, notifyAll, wait, wait, wait |
| Methods inherited from interface java.util.Collection |
equals, hashCode |
Workbooks
public Workbooks(Dispatch dispatch)
getDispatch
public Dispatch getDispatch()
- Overrides:
getDispatch in class ExcelCollection
add
public Workbook add()
add
public Workbook add(java.lang.String templateFilename)
add
public Workbook add(WBATemplate template)
close
public void close()
getCount
public int getCount()
getItem
public Workbook getItem(int index)
getItem
public Workbook getItem(java.lang.String name)
open
public Workbook open(java.io.File file)
open
public Workbook open(java.io.File file,
int updateLinks)
open
public Workbook open(java.io.File file,
int updateLinks,
boolean readOnly)
open
public Workbook open(java.io.File file,
int updateLinks,
boolean readOnly,
int format)
open
public Workbook open(java.io.File file,
int updateLinks,
boolean readOnly,
int format,
java.lang.String password)
open
public Workbook open(java.io.File file,
int updateLinks,
boolean readOnly,
int format,
java.lang.String password,
java.lang.String writeResPassword)
open
public Workbook open(java.io.File file,
int updateLinks,
boolean readOnly,
int format,
java.lang.String password,
java.lang.String writeResPassword,
boolean ignoreReadOnlyRecommended)
open
public Workbook open(java.io.File file,
int updateLinks,
boolean readOnly,
int format,
java.lang.String password,
java.lang.String writeResPassword,
boolean ignoreReadOnlyRecommended,
Platform origin)
open
public Workbook open(java.io.File file,
int updateLinks,
boolean readOnly,
int format,
java.lang.String password,
java.lang.String writeResPassword,
boolean ignoreReadOnlyRecommended,
Platform origin,
java.lang.String delimiter)
open
public Workbook open(java.io.File file,
int updateLinks,
boolean readOnly,
int format,
java.lang.String password,
java.lang.String writeResPassword,
boolean ignoreReadOnlyRecommended,
Platform origin,
java.lang.String delimiter,
boolean editable)
open
public Workbook open(java.io.File file,
int updateLinks,
boolean readOnly,
int format,
java.lang.String password,
java.lang.String writeResPassword,
boolean ignoreReadOnlyRecommended,
Platform origin,
java.lang.String delimiter,
boolean editable,
boolean notify)
open
public Workbook open(java.io.File file,
int updateLinks,
boolean readOnly,
int format,
java.lang.String password,
java.lang.String writeResPassword,
boolean ignoreReadOnlyRecommended,
Platform origin,
java.lang.String delimiter,
boolean editable,
boolean notify,
int converter)
open
public Workbook open(java.io.File file,
int updateLinks,
boolean readOnly,
int format,
java.lang.String password,
java.lang.String writeResPassword,
boolean ignoreReadOnlyRecommended,
Platform origin,
java.lang.String delimiter,
boolean editable,
boolean notify,
int converter,
boolean addToMru)
open
public Workbook open(java.io.File file,
int updateLinks,
boolean readOnly,
int format,
java.lang.String password,
java.lang.String writeResPassword,
boolean ignoreReadOnlyRecommended,
Platform origin,
java.lang.String delimiter,
boolean editable,
boolean notify,
int converter,
boolean addToMru,
boolean local)
open
public Workbook open(java.io.File file,
int updateLinks,
boolean readOnly,
int format,
java.lang.String password,
java.lang.String writeResPassword,
boolean ignoreReadOnlyRecommended,
Platform origin,
java.lang.String delimiter,
boolean editable,
boolean notify,
int converter,
boolean addToMru,
boolean local,
CorruptLoad corruptLoad)
openText
public void openText(java.io.File file)
openText
public void openText(java.io.File file,
Platform origin)
openText
public void openText(java.io.File file,
Platform origin,
int startRow)
openText
public void openText(java.io.File file,
Platform origin,
int startRow,
TextParsingType dataType)
openText
public void openText(java.io.File file,
Platform origin,
int startRow,
TextParsingType dataType,
TextQualifier textQualifier)
openText
public void openText(java.io.File file,
Platform origin,
int startRow,
TextParsingType dataType,
TextQualifier textQualifier,
boolean consecutiveDelimiter)
openText
public void openText(java.io.File file,
Platform origin,
int startRow,
TextParsingType dataType,
TextQualifier textQualifier,
boolean consecutiveDelimiter,
boolean tab)
openText
public void openText(java.io.File file,
Platform origin,
int startRow,
TextParsingType dataType,
TextQualifier textQualifier,
boolean consecutiveDelimiter,
boolean tab,
boolean semicolon)
openText
public void openText(java.io.File file,
Platform origin,
int startRow,
TextParsingType dataType,
TextQualifier textQualifier,
boolean consecutiveDelimiter,
boolean tab,
boolean semicolon,
boolean comma)
openText
public void openText(java.io.File file,
Platform origin,
int startRow,
TextParsingType dataType,
TextQualifier textQualifier,
boolean consecutiveDelimiter,
boolean tab,
boolean semicolon,
boolean comma,
boolean space)
openText
public void openText(java.io.File file,
Platform origin,
int startRow,
TextParsingType dataType,
TextQualifier textQualifier,
boolean consecutiveDelimiter,
boolean tab,
boolean semicolon,
boolean comma,
boolean space,
boolean other)
openText
public void openText(java.io.File file,
Platform origin,
int startRow,
TextParsingType dataType,
TextQualifier textQualifier,
boolean consecutiveDelimiter,
boolean tab,
boolean semicolon,
boolean comma,
boolean space,
boolean other,
java.lang.String otherChar)
openDatabase
public Workbook openDatabase(java.io.File file)
checkOut
public void checkOut(java.io.File file)
canCheckOut
public boolean canCheckOut(java.io.File file)
openXML
public Workbook openXML(java.io.File file)
openXML
public Workbook openXML(java.io.File file,
XmlLoadOption loadOption)