|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object | +--com.moyosoft.connector.ms.excel.Workbook
Constructor Summary | |
Workbook(Dispatch dispatch)
|
Method Summary | |
void |
acceptAllChanges()
|
void |
acceptAllChanges(java.lang.String when)
|
void |
acceptAllChanges(java.lang.String when,
java.lang.String who)
|
void |
acceptAllChanges(java.lang.String when,
java.lang.String who,
java.lang.String where)
|
void |
activate()
|
void |
addToFavorites()
|
void |
breakLink(java.lang.String name,
LinkType value)
|
boolean |
canCheckIn()
|
void |
changeFileAccess(FileAccess mode)
|
void |
changeFileAccess(FileAccess mode,
java.lang.String writePassword)
|
void |
changeFileAccess(FileAccess mode,
java.lang.String writePassword,
boolean notify)
|
void |
changeLink(java.lang.String name,
java.lang.String newName)
|
void |
changeLink(java.lang.String name,
java.lang.String newName,
LinkType value)
|
void |
checkIn()
|
void |
checkIn(boolean saveChanges)
|
void |
checkIn(boolean saveChanges,
java.lang.String comments)
|
void |
checkIn(boolean saveChanges,
java.lang.String comments,
boolean makePublic)
|
void |
close()
|
void |
close(boolean saveChanges)
|
void |
close(boolean saveChanges,
java.io.File file)
|
void |
close(boolean saveChanges,
java.io.File file,
boolean routeWorkbook)
|
void |
deleteNumberFormat(java.lang.String value)
|
void |
endReview()
|
boolean |
exclusiveAccess()
|
void |
followHyperlink(java.lang.String address)
|
void |
followHyperlink(java.lang.String address,
java.lang.String subAddress)
|
void |
followHyperlink(java.lang.String address,
java.lang.String subAddress,
boolean newWindow)
|
void |
followHyperlink(java.lang.String address,
java.lang.String subAddress,
boolean newWindow,
java.lang.String extraInfo)
|
void |
forwardMailer()
|
Chart |
getActiveChart()
|
Sheet |
getActiveSheet()
|
Worksheet |
getActiveWorksheet()
|
java.lang.String |
getAuthor()
|
int |
getAutoUpdateFrequency()
|
int |
getCalculationVersion()
|
int |
getChangeHistoryDuration()
|
Sheets |
getCharts()
|
java.lang.String |
getCodeName()
|
java.awt.Color |
getColor(int colorNumber)
Returns the palette's color at the specified index. |
int[] |
getColors()
Returns the palette of 56 colors, each represented by an RGB value. |
int |
getColorValue(int colorNumber)
Returns the palette's color value at the specified index. |
java.lang.String |
getComments()
|
SaveConflictResolution |
getConflictResolution()
|
CustomViews |
getCustomViews()
|
Sheets |
getDialogSheets()
|
Dispatch |
getDispatch()
|
DisplayDrawingObjects |
getDisplayDrawingObjects()
|
Sheets |
getExcel4IntlMacroSheets()
|
Sheets |
getExcel4MacroSheets()
|
FileFormat |
getFileFormat()
|
java.lang.String |
getFullName()
|
java.lang.String |
getFullNameURLEncoded()
|
java.lang.String |
getKeywords()
|
Sheets |
getModules()
|
java.lang.String |
getName()
|
Names |
getNames()
|
java.lang.String |
getPassword()
|
java.lang.String |
getPasswordEncryptionAlgorithm()
|
int |
getPasswordEncryptionKeyLength()
|
java.lang.String |
getPasswordEncryptionProvider()
|
java.lang.String |
getPath()
|
PublishObjects |
getPublishObjects()
|
int |
getRevisionNumber()
|
Sheets |
getSheets()
|
SmartTagOptions |
getSmartTagOptions()
|
Styles |
getStyles()
|
java.lang.String |
getSubject()
|
java.lang.String |
getTitle()
|
UpdateLinks |
getUpdateLinks()
|
WebOptions |
getWebOptions()
|
Windows |
getWindows()
|
Sheets |
getWorksheets()
|
java.lang.String |
getWritePassword()
|
java.lang.String |
getWriteReservedBy()
|
XmlMaps |
getXmlMaps()
|
XmlNamespaces |
getXmlNamespaces()
|
boolean |
hasMailer()
|
boolean |
hasPassword()
|
boolean |
hasRoutingSlip()
|
boolean |
isAcceptLabelsInFormulas()
|
boolean |
isAddin()
|
boolean |
isAutoUpdateSaveChanges()
|
boolean |
isCreateBackup()
|
boolean |
isDisplayInkComments()
|
boolean |
isEnableAutoRecover()
|
boolean |
isEnvelopeVisible()
|
boolean |
isHighlightChangesOnScreen()
|
boolean |
isInactiveListBorderVisible()
|
boolean |
isInplace()
|
boolean |
isKeepChangeHistory()
|
boolean |
isListChangesOnNewSheet()
|
boolean |
isMultiUserEditing()
|
boolean |
isPersonalViewListSettings()
|
boolean |
isPersonalViewPrintSettings()
|
boolean |
isPrecisionAsDisplayed()
|
boolean |
isReadOnly()
|
boolean |
isReadOnlyRecommended()
|
boolean |
isRemovePersonalInformation()
|
boolean |
isRouted()
|
boolean |
isSaved()
|
boolean |
isSaveLinkValues()
|
boolean |
isShowConflictHistory()
|
boolean |
isShowPivotTableFieldList()
|
boolean |
isTemplateRemoveExtData()
|
boolean |
isUpdateRemoteReferences()
|
boolean |
isUserControl()
|
boolean |
isUsing1904DateSystem()
|
boolean |
isVBASigned()
|
boolean |
isWriteReserved()
|
java.lang.String[] |
linkSources()
|
java.lang.String[] |
linkSources(Link linkType)
|
void |
mergeWorkbook(java.io.File file)
|
Window |
newWindow()
|
void |
openLinks(java.lang.String name)
|
void |
openLinks(java.lang.String name,
boolean readOnly)
|
void |
openLinks(java.lang.String name,
boolean readOnly,
Link type)
|
void |
printOut()
|
void |
printOut(int copies,
boolean preview,
boolean collate)
|
void |
printOut(int copies,
boolean preview,
java.lang.String activePrinter,
boolean printToFile,
boolean collate,
java.lang.String printToFilename)
|
void |
printOut(int fromPage,
int toPage,
int copies)
|
void |
printOut(int fromPage,
int toPage,
int copies,
boolean preview)
|
void |
printOut(int fromPage,
int toPage,
int copies,
boolean preview,
java.lang.String activePrinter)
|
void |
printOut(int fromPage,
int toPage,
int copies,
boolean preview,
java.lang.String activePrinter,
boolean printToFile,
boolean collate,
java.lang.String printToFilename)
|
void |
printPreview()
|
void |
protect()
|
void |
protect(java.lang.String password)
|
void |
purgeChangeHistoryNow(int days)
|
void |
purgeChangeHistoryNow(int days,
java.lang.String sharingPassword)
|
void |
recheckSmartTags()
|
void |
refreshAll()
|
void |
rejectAllChanges()
|
void |
rejectAllChanges(java.lang.String when)
|
void |
rejectAllChanges(java.lang.String when,
java.lang.String who)
|
void |
rejectAllChanges(java.lang.String when,
java.lang.String who,
java.lang.String where)
|
void |
reply()
|
void |
replyAll()
|
void |
resetColors()
|
void |
route()
|
void |
runAutoMacros(RunAutoMacro value)
|
void |
save()
|
void |
saveAs()
|
void |
saveAs(java.io.File file)
|
void |
saveAs(java.io.File file,
FileFormat fileFormat)
|
void |
saveAs(java.io.File file,
FileFormat fileFormat,
java.lang.String password)
|
void |
saveAs(java.io.File file,
FileFormat fileFormat,
java.lang.String password,
java.lang.String writeResPassword)
|
void |
saveAs(java.io.File file,
FileFormat fileFormat,
java.lang.String password,
java.lang.String writeResPassword,
boolean readOnlyRecommended)
|
void |
saveAs(java.io.File file,
FileFormat fileFormat,
java.lang.String password,
java.lang.String writeResPassword,
boolean readOnlyRecommended,
boolean createBackup)
|
void |
saveAs(java.io.File file,
FileFormat fileFormat,
java.lang.String password,
java.lang.String writeResPassword,
boolean readOnlyRecommended,
boolean createBackup,
SaveAsAccessMode accessMode)
|
void |
saveAs(java.io.File file,
FileFormat fileFormat,
java.lang.String password,
java.lang.String writeResPassword,
boolean readOnlyRecommended,
boolean createBackup,
SaveAsAccessMode accessMode,
SaveConflictResolution conflictResolution)
|
void |
saveAs(java.io.File file,
FileFormat fileFormat,
java.lang.String password,
java.lang.String writeResPassword,
boolean readOnlyRecommended,
boolean createBackup,
SaveAsAccessMode accessMode,
SaveConflictResolution conflictResolution,
boolean addToMru)
|
void |
saveAsXMLData(java.io.File file,
XmlMap value)
|
void |
saveCopyAs(java.io.File file)
|
void |
setAcceptLabelsInFormulas(boolean value)
|
void |
setAuthor(java.lang.String value)
|
void |
setAutoUpdateFrequency(int value)
|
void |
setAutoUpdateSaveChanges(boolean value)
|
void |
setChangeHistoryDuration(int value)
|
void |
setColor(int colorNumber,
java.awt.Color color)
Changes the palette's color at the specified index. |
void |
setColorValue(int colorNumber,
int color)
Changes the palette's color at the specified index. |
void |
setComments(java.lang.String value)
|
void |
setConflictResolution(SaveConflictResolution value)
|
void |
setDisplayDrawingObjects(DisplayDrawingObjects value)
|
void |
setDisplayInkComments(boolean value)
|
void |
setEnableAutoRecover(boolean value)
|
void |
setEnvelopeVisible(boolean value)
|
void |
setHasMailer(boolean value)
|
void |
setHasRoutingSlip(boolean value)
|
void |
setHighlightChangesOnScreen(boolean value)
|
void |
setInactiveListBorderVisible(boolean value)
|
void |
setIsAddin(boolean value)
|
void |
setKeepChangeHistory(boolean value)
|
void |
setKeywords(java.lang.String value)
|
void |
setLinkOnData(java.lang.String name)
|
void |
setLinkOnData(java.lang.String name,
java.lang.String procedure)
|
void |
setListChangesOnNewSheet(boolean value)
|
void |
setPassword(java.lang.String value)
|
void |
setPersonalViewListSettings(boolean value)
|
void |
setPersonalViewPrintSettings(boolean value)
|
void |
setPrecisionAsDisplayed(boolean value)
|
void |
setReadOnlyRecommended(boolean value)
|
void |
setRemovePersonalInformation(boolean value)
|
void |
setSaved(boolean value)
|
void |
setSaveLinkValues(boolean value)
|
void |
setShowConflictHistory(boolean value)
|
void |
setShowPivotTableFieldList(boolean value)
|
void |
setSubject(java.lang.String value)
|
void |
setTemplateRemoveExtData(boolean value)
|
void |
setTitle(java.lang.String value)
|
void |
setUpdateLinks(UpdateLinks value)
|
void |
setUpdateRemoteReferences(boolean value)
|
void |
setUserControl(boolean value)
|
void |
setUsing1904DateSystem(boolean value)
|
void |
setWritePassword(java.lang.String value)
|
void |
toggleFormsDesign()
|
void |
unprotect()
|
void |
unprotect(java.lang.String password)
|
void |
unprotectSharing()
|
void |
unprotectSharing(java.lang.String password)
|
void |
updateFromFile()
|
void |
updateLink()
|
void |
updateLink(java.lang.String name)
|
void |
updateLink(java.lang.String name,
LinkType type)
|
void |
webPagePreview()
|
XmlImportResult |
xmlImport(java.lang.String url,
XmlMap importMap)
|
XmlImportResult |
xmlImport(java.lang.String url,
XmlMap importMap,
boolean overwrite)
|
XmlImportResult |
xmlImport(java.lang.String url,
XmlMap importMap,
boolean overwrite,
Range destination)
|
XmlImportResult |
xmlImportXml(java.lang.String data,
XmlMap importMap)
|
XmlImportResult |
xmlImportXml(java.lang.String data,
XmlMap importMap,
boolean overwrite)
|
XmlImportResult |
xmlImportXml(java.lang.String data,
XmlMap importMap,
boolean overwrite,
Range destination)
|
Methods inherited from class java.lang.Object |
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
public Workbook(Dispatch dispatch)
Method Detail |
public Dispatch getDispatch()
public boolean isAcceptLabelsInFormulas()
public void setAcceptLabelsInFormulas(boolean value)
public void activate()
public Chart getActiveChart()
public Sheet getActiveSheet()
public Worksheet getActiveWorksheet()
public java.lang.String getAuthor()
public void setAuthor(java.lang.String value)
public int getAutoUpdateFrequency()
public void setAutoUpdateFrequency(int value)
public boolean isAutoUpdateSaveChanges()
public void setAutoUpdateSaveChanges(boolean value)
public int getChangeHistoryDuration()
public void setChangeHistoryDuration(int value)
public void changeFileAccess(FileAccess mode)
public void changeFileAccess(FileAccess mode, java.lang.String writePassword)
public void changeFileAccess(FileAccess mode, java.lang.String writePassword, boolean notify)
public void changeLink(java.lang.String name, java.lang.String newName)
public void changeLink(java.lang.String name, java.lang.String newName, LinkType value)
public Sheets getCharts()
public void close()
public void close(boolean saveChanges)
public void close(boolean saveChanges, java.io.File file)
public void close(boolean saveChanges, java.io.File file, boolean routeWorkbook)
public java.lang.String getCodeName()
public int[] getColors()
public java.awt.Color getColor(int colorNumber)
colorNumber
- The color index (from 1 to 56)public int getColorValue(int colorNumber)
colorNumber
- The color index (from 1 to 56)public void setColor(int colorNumber, java.awt.Color color)
colorNumber
- The color index (from 1 to 56)color
- The color to be set at the specified indexpublic void setColorValue(int colorNumber, int color)
colorNumber
- The color index (from 1 to 56)color
- The color value to be set at the specified indexpublic java.lang.String getComments()
public void setComments(java.lang.String value)
public SaveConflictResolution getConflictResolution()
public void setConflictResolution(SaveConflictResolution value)
public boolean isCreateBackup()
public boolean isUsing1904DateSystem()
public void setUsing1904DateSystem(boolean value)
public void deleteNumberFormat(java.lang.String value)
public Sheets getDialogSheets()
public DisplayDrawingObjects getDisplayDrawingObjects()
public void setDisplayDrawingObjects(DisplayDrawingObjects value)
public boolean exclusiveAccess()
public FileFormat getFileFormat()
public void forwardMailer()
public java.lang.String getFullName()
public boolean hasMailer()
public void setHasMailer(boolean value)
public boolean hasPassword()
public boolean hasRoutingSlip()
public void setHasRoutingSlip(boolean value)
public boolean isAddin()
public void setIsAddin(boolean value)
public java.lang.String getKeywords()
public void setKeywords(java.lang.String value)
public java.lang.String[] linkSources()
public java.lang.String[] linkSources(Link linkType)
public void mergeWorkbook(java.io.File file)
public Sheets getModules()
public boolean isMultiUserEditing()
public java.lang.String getName()
public Names getNames()
public Window newWindow()
public void openLinks(java.lang.String name)
public void openLinks(java.lang.String name, boolean readOnly)
public void openLinks(java.lang.String name, boolean readOnly, Link type)
public java.lang.String getPath()
public boolean isPersonalViewListSettings()
public void setPersonalViewListSettings(boolean value)
public boolean isPersonalViewPrintSettings()
public void setPersonalViewPrintSettings(boolean value)
public boolean isPrecisionAsDisplayed()
public void setPrecisionAsDisplayed(boolean value)
public void printPreview()
public boolean isReadOnly()
public void refreshAll()
public void reply()
public void replyAll()
public int getRevisionNumber()
public void route()
public boolean isRouted()
public void runAutoMacros(RunAutoMacro value)
public void save()
public void saveCopyAs(java.io.File file)
public boolean isSaved()
public void setSaved(boolean value)
public boolean isSaveLinkValues()
public void setSaveLinkValues(boolean value)
public void setLinkOnData(java.lang.String name)
public void setLinkOnData(java.lang.String name, java.lang.String procedure)
public Sheets getSheets()
public boolean isShowConflictHistory()
public void setShowConflictHistory(boolean value)
public Styles getStyles()
public java.lang.String getSubject()
public void setSubject(java.lang.String value)
public java.lang.String getTitle()
public void setTitle(java.lang.String value)
public void unprotect()
public void unprotect(java.lang.String password)
public void unprotectSharing()
public void unprotectSharing(java.lang.String password)
public void updateFromFile()
public void updateLink()
public void updateLink(java.lang.String name)
public void updateLink(java.lang.String name, LinkType type)
public boolean isUpdateRemoteReferences()
public void setUpdateRemoteReferences(boolean value)
public boolean isUserControl()
public void setUserControl(boolean value)
public CustomViews getCustomViews()
public Windows getWindows()
public Sheets getWorksheets()
public boolean isWriteReserved()
public java.lang.String getWriteReservedBy()
public Sheets getExcel4IntlMacroSheets()
public Sheets getExcel4MacroSheets()
public boolean isTemplateRemoveExtData()
public void setTemplateRemoveExtData(boolean value)
public boolean isHighlightChangesOnScreen()
public void setHighlightChangesOnScreen(boolean value)
public boolean isKeepChangeHistory()
public void setKeepChangeHistory(boolean value)
public boolean isListChangesOnNewSheet()
public void setListChangesOnNewSheet(boolean value)
public void purgeChangeHistoryNow(int days)
public void purgeChangeHistoryNow(int days, java.lang.String sharingPassword)
public void acceptAllChanges()
public void acceptAllChanges(java.lang.String when)
public void acceptAllChanges(java.lang.String when, java.lang.String who)
public void acceptAllChanges(java.lang.String when, java.lang.String who, java.lang.String where)
public void rejectAllChanges()
public void rejectAllChanges(java.lang.String when)
public void rejectAllChanges(java.lang.String when, java.lang.String who)
public void rejectAllChanges(java.lang.String when, java.lang.String who, java.lang.String where)
public void resetColors()
public void followHyperlink(java.lang.String address)
public void followHyperlink(java.lang.String address, java.lang.String subAddress)
public void followHyperlink(java.lang.String address, java.lang.String subAddress, boolean newWindow)
public void followHyperlink(java.lang.String address, java.lang.String subAddress, boolean newWindow, java.lang.String extraInfo)
public void addToFavorites()
public boolean isInplace()
public void printOut()
public void printOut(int fromPage, int toPage, int copies)
public void printOut(int fromPage, int toPage, int copies, boolean preview)
public void printOut(int fromPage, int toPage, int copies, boolean preview, java.lang.String activePrinter)
public void printOut(int fromPage, int toPage, int copies, boolean preview, java.lang.String activePrinter, boolean printToFile, boolean collate, java.lang.String printToFilename)
public void printOut(int copies, boolean preview, boolean collate)
public void printOut(int copies, boolean preview, java.lang.String activePrinter, boolean printToFile, boolean collate, java.lang.String printToFilename)
public void webPagePreview()
public PublishObjects getPublishObjects()
public WebOptions getWebOptions()
public boolean isEnvelopeVisible()
public void setEnvelopeVisible(boolean value)
public int getCalculationVersion()
public boolean isVBASigned()
public boolean isShowPivotTableFieldList()
public void setShowPivotTableFieldList(boolean value)
public UpdateLinks getUpdateLinks()
public void setUpdateLinks(UpdateLinks value)
public void breakLink(java.lang.String name, LinkType value)
public void saveAs()
public void saveAs(java.io.File file)
public void saveAs(java.io.File file, FileFormat fileFormat)
public void saveAs(java.io.File file, FileFormat fileFormat, java.lang.String password)
public void saveAs(java.io.File file, FileFormat fileFormat, java.lang.String password, java.lang.String writeResPassword)
public void saveAs(java.io.File file, FileFormat fileFormat, java.lang.String password, java.lang.String writeResPassword, boolean readOnlyRecommended)
public void saveAs(java.io.File file, FileFormat fileFormat, java.lang.String password, java.lang.String writeResPassword, boolean readOnlyRecommended, boolean createBackup)
public void saveAs(java.io.File file, FileFormat fileFormat, java.lang.String password, java.lang.String writeResPassword, boolean readOnlyRecommended, boolean createBackup, SaveAsAccessMode accessMode)
public void saveAs(java.io.File file, FileFormat fileFormat, java.lang.String password, java.lang.String writeResPassword, boolean readOnlyRecommended, boolean createBackup, SaveAsAccessMode accessMode, SaveConflictResolution conflictResolution)
public void saveAs(java.io.File file, FileFormat fileFormat, java.lang.String password, java.lang.String writeResPassword, boolean readOnlyRecommended, boolean createBackup, SaveAsAccessMode accessMode, SaveConflictResolution conflictResolution, boolean addToMru)
public boolean isEnableAutoRecover()
public void setEnableAutoRecover(boolean value)
public boolean isRemovePersonalInformation()
public void setRemovePersonalInformation(boolean value)
public java.lang.String getFullNameURLEncoded()
public void checkIn()
public void checkIn(boolean saveChanges)
public void checkIn(boolean saveChanges, java.lang.String comments)
public void checkIn(boolean saveChanges, java.lang.String comments, boolean makePublic)
public boolean canCheckIn()
public void endReview()
public java.lang.String getPassword()
public void setPassword(java.lang.String value)
public java.lang.String getWritePassword()
public void setWritePassword(java.lang.String value)
public java.lang.String getPasswordEncryptionProvider()
public java.lang.String getPasswordEncryptionAlgorithm()
public int getPasswordEncryptionKeyLength()
public boolean isReadOnlyRecommended()
public void setReadOnlyRecommended(boolean value)
public void protect()
public void protect(java.lang.String password)
public SmartTagOptions getSmartTagOptions()
public void recheckSmartTags()
public XmlNamespaces getXmlNamespaces()
public XmlMaps getXmlMaps()
public XmlImportResult xmlImport(java.lang.String url, XmlMap importMap)
public XmlImportResult xmlImport(java.lang.String url, XmlMap importMap, boolean overwrite)
public XmlImportResult xmlImport(java.lang.String url, XmlMap importMap, boolean overwrite, Range destination)
public boolean isInactiveListBorderVisible()
public void setInactiveListBorderVisible(boolean value)
public boolean isDisplayInkComments()
public void setDisplayInkComments(boolean value)
public XmlImportResult xmlImportXml(java.lang.String data, XmlMap importMap)
public XmlImportResult xmlImportXml(java.lang.String data, XmlMap importMap, boolean overwrite)
public XmlImportResult xmlImportXml(java.lang.String data, XmlMap importMap, boolean overwrite, Range destination)
public void saveAsXMLData(java.io.File file, XmlMap value)
public void toggleFormsDesign()
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |