Example:
//Open a file with external links $workbook = new cells\Workbook("book1.xls"); //Get External Link $externalLink = $workbook->getWorksheets()->getExternalLinks()->get(0); //Change External Link's Data Source $externalLink->setDataSource("link.xls");
Property Getters/Setters Summary | ||
---|---|---|
function | getDataSource() | |
function | setDataSource(value) | |
Represents data source of the external link. | ||
function | isReferred() | |
Indicates whether this external link is referenced by others. | ||
function | isVisible() | |
Indicates whether this external link is visible in MS Excel. | ||
function | getOriginalDataSource() | |
function | setOriginalDataSource(value) | |
Represents stored data source of the external link. | ||
function | getType() | |
Gets the type of external link. The value of the property is ExternalLinkType integer constant. |
Method Summary | ||
---|---|---|
function | addExternalName(text, referTo) | |
Adds an external name. |
Property Getters/Setters Detail |
---|
getType : Number | |
function getType() |
getOriginalDataSource/setOriginalDataSource : String | |
function getOriginalDataSource() / function setOriginalDataSource(value) |
getDataSource/setDataSource : String | |
function getDataSource() / function setDataSource(value) |
isReferred : boolean | |
function isReferred() |
isVisible : boolean | |
function isVisible() |
Method Detail |
---|
addExternalName | |
function addExternalName(text, referTo) |
text: String
- The text of the external name.
If the external name belongs to a worksheet, the text should be as Sheet1!Text.
referTo: String
- The referTo of the external name. It must be a cell or the range.