public void BasicRead()
{
XSSFWorkbook wb = XSSFTestDataSamples.OpenSampleWorkbook("ref-56737.xlsx");
Assert.IsNotNull(wb.ExternalLinksTable);
IName name = null;
Assert.AreEqual(1, wb.ExternalLinksTable.Count);
ExternalLinksTable links = wb.ExternalLinksTable[0];
Assert.AreEqual(3, links.SheetNames.Count);
Assert.AreEqual(2, links.DefinedNames.Count);
Assert.AreEqual("Uses", links.SheetNames[(0)]);
Assert.AreEqual("Defines", links.SheetNames[(1)]);
Assert.AreEqual("56737", links.SheetNames[(2)]);
name = links.DefinedNames[(0)];
Assert.AreEqual("NR_Global_B2", name.NameName);
Assert.AreEqual(-1, name.SheetIndex);
Assert.AreEqual(null, name.SheetName);
Assert.AreEqual("'Defines'!$B$2", name.RefersToFormula);
name = links.DefinedNames[(1)];
Assert.AreEqual("NR_To_A1", name.NameName);
Assert.AreEqual(1, name.SheetIndex);
Assert.AreEqual("Defines", name.SheetName);
Assert.AreEqual("'Defines'!$A$1", name.RefersToFormula);
Assert.AreEqual("56737.xlsx", links.LinkedFileName);
}
public void readWithReferencesToTwoExternalBooks()
{
XSSFWorkbook wb = XSSFTestDataSamples.OpenSampleWorkbook("ref2-56737.xlsx");
Assert.IsNotNull(wb.ExternalLinksTable);
IName name = null;
Assert.AreEqual(2, wb.ExternalLinksTable.Count);
// Check the first one, links to 56737.xlsx
ExternalLinksTable links = wb.ExternalLinksTable[0];
Assert.AreEqual("56737.xlsx", links.LinkedFileName);
Assert.AreEqual(3, links.SheetNames.Count);
Assert.AreEqual(2, links.DefinedNames.Count);
Assert.AreEqual("Uses", links.SheetNames[0]);
Assert.AreEqual("Defines", links.SheetNames[1]);
Assert.AreEqual("56737", links.SheetNames[2]);
name = links.DefinedNames[0];
Assert.AreEqual("NR_Global_B2", name.NameName);
Assert.AreEqual(-1, name.SheetIndex);
Assert.AreEqual(null, name.SheetName);
Assert.AreEqual("'Defines'!$B$2", name.RefersToFormula);
name = links.DefinedNames[1];
Assert.AreEqual("NR_To_A1", name.NameName);
Assert.AreEqual(1, name.SheetIndex);
Assert.AreEqual("Defines", name.SheetName);
Assert.AreEqual("'Defines'!$A$1", name.RefersToFormula);
// Check the second one, links to 56737.xls, slightly differently
links = wb.ExternalLinksTable[1];
Assert.AreEqual("56737.xls", links.LinkedFileName);
Assert.AreEqual(2, links.SheetNames.Count);
Assert.AreEqual(2, links.DefinedNames.Count);
Assert.AreEqual("Uses", links.SheetNames[0]);
Assert.AreEqual("Defines", links.SheetNames[1]);
name = links.DefinedNames[0];
Assert.AreEqual("NR_Global_B2", name.NameName);
Assert.AreEqual(-1, name.SheetIndex);
Assert.AreEqual(null, name.SheetName);
Assert.AreEqual("'Defines'!$B$2", name.RefersToFormula);
name = links.DefinedNames[1];
Assert.AreEqual("NR_To_A1", name.NameName);
Assert.AreEqual(1, name.SheetIndex);
Assert.AreEqual("Defines", name.SheetName);
Assert.AreEqual("'Defines'!$A$1", name.RefersToFormula);
}
public void BasicReadWriteRead()
{
XSSFWorkbook wb = XSSFTestDataSamples.OpenSampleWorkbook("ref-56737.xlsx");
IName name = wb.ExternalLinksTable[0].DefinedNames[(1)];
name.NameName = (/*setter*/ "Testing");
name.RefersToFormula = (/*setter*/ "$A$1");
wb = XSSFTestDataSamples.WriteOutAndReadBack(wb) as XSSFWorkbook;
Assert.AreEqual(1, wb.ExternalLinksTable.Count);
ExternalLinksTable links = wb.ExternalLinksTable[(0)];
name = links.DefinedNames[(0)];
Assert.AreEqual("NR_Global_B2", name.NameName);
Assert.AreEqual(-1, name.SheetIndex);
Assert.AreEqual(null, name.SheetName);
Assert.AreEqual("'Defines'!$B$2", name.RefersToFormula);
name = links.DefinedNames[(1)];
Assert.AreEqual("Testing", name.NameName);
Assert.AreEqual(1, name.SheetIndex);
Assert.AreEqual("Defines", name.SheetName);
Assert.AreEqual("$A$1", name.RefersToFormula);
}
protected internal ExternalName(CT_ExternalDefinedName name, ExternalLinksTable externalLinkTable)
{
this.name = name;
this.externalLinkTable = externalLinkTable;
}
protected internal ExternalName(CT_ExternalDefinedName name, ExternalLinksTable externalLinkTable)
{
this.name = name;
this.externalLinkTable = externalLinkTable;
}