Example:
# Open a file with external links workbook = Workbook("ExternalFormula.xlsx") # Change external link data source workbook.getWorksheets().getExternalLinks().get(0).setDataSource("Book2.xlsx")
Property Getters/Setters Summary | ||
---|---|---|
method | getCount() | |
Gets the number of elements actually contained in the collection. | ||
method | get(index) | |
Gets the |
Method Summary | ||
---|---|---|
method | add(directoryType, fileName, sheetNames) | |
Add an external link . | ||
method | add(fileName, sheetNames) | |
Adds an external link. |
Property Getters/Setters Detail |
---|
getCount : int | |
int getCount() |
get : ExternalLink | |
ExternalLink get(index) |
index
- The zero based index of the element.Method Detail |
---|
add | |
int add(fileName, sheetNames) |
fileName: String
- The external file name.sheetNames: String[]
- All sheet names of the external file.add | |
int add(directoryType, fileName, sheetNames) |
directoryType: int
- A fileName: String
- the file name.sheetNames: String[]
- All sheet names of the external file.