ExternalLink

Inheritance: java.lang.Object

public class ExternalLink

Represents an external link in a workbook.

Example

         //Open a file with external links
         Workbook workbook = new Workbook("book1.xls");
 
         //Get External Link 
         ExternalLink externalLink = workbook.getWorksheets().getExternalLinks().get(0);
 
         //Change External Link's Data Source
         externalLink.setDataSource("d:\\link.xls");

Methods

MethodDescription
addExternalName(String text, String referTo)Adds an external name.
equals(Object arg0)
getClass()
getDataSource()Represents data source of the external link.
getOriginalDataSource()Represents stored data source of the external link.
getType()Gets the type of external link.
hashCode()
isReferred()Indicates whether this external link is referenced by others.
isVisible()Indicates whether this external link is visible in MS Excel.
notify()
notifyAll()
setDataSource(String value)Represents data source of the external link.
setOriginalDataSource(String value)Represents stored data source of the external link.
toString()
wait()
wait(long arg0)
wait(long arg0, int arg1)

addExternalName(String text, String referTo)

public void addExternalName(String text, String referTo)

Adds an external name.

Parameters:

ParameterTypeDescription
textjava.lang.StringThe text of the external name. If the external name belongs to a worksheet, the text should be as Sheet1!Text.
referTojava.lang.StringThe referTo of the external name. It must be a cell or the range.

equals(Object arg0)

public boolean equals(Object arg0)

Parameters:

ParameterTypeDescription
arg0java.lang.Object

Returns: boolean

getClass()

public final native Class<?> getClass()

Returns: java.lang.Class

getDataSource()

public String getDataSource()

Represents data source of the external link.

Returns: java.lang.String

getOriginalDataSource()

public String getOriginalDataSource()

Represents stored data source of the external link.

Returns: java.lang.String

getType()

public int getType()

Gets the type of external link.

See ExternalLinkType.

Returns: int

hashCode()

public native int hashCode()

Returns: int

isReferred()

public boolean isReferred()

Indicates whether this external link is referenced by others.

Returns: boolean

isVisible()

public boolean isVisible()

Indicates whether this external link is visible in MS Excel.

Returns: boolean

notify()

public final native void notify()

notifyAll()

public final native void notifyAll()

setDataSource(String value)

public void setDataSource(String value)

Represents data source of the external link.

Parameters:

ParameterTypeDescription
valuejava.lang.String

setOriginalDataSource(String value)

public void setOriginalDataSource(String value)

Represents stored data source of the external link.

Parameters:

ParameterTypeDescription
valuejava.lang.String

toString()

public String toString()

Returns: java.lang.String

wait()

public final void wait()

wait(long arg0)

public final native void wait(long arg0)

Parameters:

ParameterTypeDescription
arg0long

wait(long arg0, int arg1)

public final void wait(long arg0, int arg1)

Parameters:

ParameterTypeDescription
arg0long
arg1int