pub struct ExternalWorkbookLink {
pub target: String,
pub sheet_names: Vec<String>,
pub defined_names: Vec<(String, String)>,
}Expand description
A reference to another workbook, used by this workbook’s formulas (<externalReference> in
xl/workbook.xml’s <externalReferences>, plus a dedicated
xl/externalLinks/externalLinkN.xml part, CT_ExternalReference/CT_ExternalLink). Storage
only: this crate neither resolves the referenced workbook nor recomputes any formula against it
— a formula cell referencing this link (e.g. "[1]Feuil1!A1" or "'[Budget.xlsx]Feuil1'!A1")
is written/read as plain formula text like any other, this type only accounts for the link
itself (the part Excel needs to know the reference is legitimate and to cache a fallback value
while the other file is closed).
Fields§
§target: StringThe other workbook’s path/URL, written as an external (TargetMode="External") relationship
target on this link’s own xl/externalLinks/_rels/externalLinkN.xml.rels — same shape as
HyperlinkTarget::External. Can be an absolute path ("file:///C:/Budget.xlsx"), a
relative one ("Budget.xlsx"), or a URL.
sheet_names: Vec<String>The other workbook’s own sheet names, in order (<sheetNames>/<sheetName val="..">) —
Excel uses these to resolve [1]SheetName!.. formula references while the other file is
closed.
defined_names: Vec<(String, String)>Named ranges/constants defined in the other workbook that this one’s formulas reference, as
(name, refersTo text) pairs (<definedNames>/<definedName name=".." refersTo="..">).
Implementations§
Source§impl ExternalWorkbookLink
impl ExternalWorkbookLink
Sourcepub fn new(target: impl Into<String>) -> ExternalWorkbookLink
pub fn new(target: impl Into<String>) -> ExternalWorkbookLink
Creates an external workbook link with no sheet names/defined names yet.
Sourcepub fn with_sheet_name(self, name: impl Into<String>) -> ExternalWorkbookLink
pub fn with_sheet_name(self, name: impl Into<String>) -> ExternalWorkbookLink
Appends a sheet name and returns the link for chaining.
Sourcepub fn with_defined_name(
self,
name: impl Into<String>,
refers_to: impl Into<String>,
) -> ExternalWorkbookLink
pub fn with_defined_name( self, name: impl Into<String>, refers_to: impl Into<String>, ) -> ExternalWorkbookLink
Appends a defined name reference and returns the link for chaining.
Trait Implementations§
Source§impl Clone for ExternalWorkbookLink
impl Clone for ExternalWorkbookLink
Source§fn clone(&self) -> ExternalWorkbookLink
fn clone(&self) -> ExternalWorkbookLink
1.0.0 (const: unstable) · Source§fn clone_from(&mut self, source: &Self)
fn clone_from(&mut self, source: &Self)
source. Read more