GitHub
/
NPOI
7
0
Fork 0
Code Issues Pull Requests Projects Releases Wiki Activity
用于生成 Office 文件的 .NET 组件。
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
197 Commits
1 Branch
5 Tags
64 MiB
 
Branch: master
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'master'
${ noResults }
NPOI/test/NPOI.OpenXml4Net/TestRelationships.cs

467 lines
22 KiB
Raw Permalink Blame History

/* ====================================================================
Licensed to the Apache Software Foundation (ASF) under one or more
contributor license agreements. See the NOTICE file distributed with
this work for Additional information regarding copyright ownership.
The ASF licenses this file to You under the Apache License, Version 2.0
(the "License"); you may not use this file except in compliance with
the License. You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
==================================================================== */
using NPOI.Util;
using NPOI.OpenXml4Net.OPC;
using System;
using NUnit.Framework;
using TestCases.OpenXml4Net;
using System.IO;
using System.Net;
using System.Web;
using System.Text.RegularExpressions;
using NPOI.XWPF.UserModel;
namespace TestCases.OPC
{
[TestFixture]
public class TestRelationships {
private static String HYPERLINK_REL_TYPE =
"http://schemas.openxmlformats.org/officeDocument/2006/relationships/hyperlink";
private static String COMMENTS_REL_TYPE =
"http://schemas.openxmlformats.org/officeDocument/2006/relationships/comments";
private static String SHEET_WITH_COMMENTS =
"/xl/worksheets/sheet1.xml";
private static POILogger logger = POILogFactory.GetLogger(typeof(TestPackageCoreProperties));
/**
* Test relationships are correctly loaded. This at the moment fails (as of r499)
* whenever a document is loaded before its correspondig .rels file has been found.
* The code in this case assumes there are no relationships defined, but it should
* really look also for not yet loaded parts.
*/
[Test]
public void TestLoadRelationships() {
Stream is1 = OpenXml4NetTestDataSamples.OpenSampleStream("sample.xlsx");
OPCPackage pkg = OPCPackage.Open(is1);
logger.Log(POILogger.DEBUG, "1: " + pkg);
PackageRelationshipCollection rels = pkg.GetRelationshipsByType(PackageRelationshipTypes.CORE_DOCUMENT);
PackageRelationship coreDocRelationship = rels.GetRelationship(0);
PackagePart corePart = pkg.GetPart(coreDocRelationship);
String[] relIds = { "rId1", "rId2", "rId3" };
foreach (String relId in relIds) {
PackageRelationship rel = corePart.GetRelationship(relId);
Assert.IsNotNull(rel);
PackagePartName relName = PackagingUriHelper.CreatePartName(rel.TargetUri);
PackagePart sheetPart = pkg.GetPart(relName);
Assert.AreEqual(1, sheetPart.Relationships.Size, "Number of relationships1 for " + sheetPart.PartName);
}
}
/**
* Checks that we can fetch a collection of relations by
* type, then grab from within there by id
*/
[Test]
public void TestFetchFromCollection() {
Stream is1 = OpenXml4NetTestDataSamples.OpenSampleStream("ExcelWithHyperlinks.xlsx");
OPCPackage pkg = OPCPackage.Open(is1);
PackagePart sheet = pkg.GetPart(
PackagingUriHelper.CreatePartName(SHEET_WITH_COMMENTS));
Assert.IsNotNull(sheet);
Assert.IsTrue(sheet.HasRelationships);
Assert.AreEqual(6, sheet.Relationships.Size);
// Should have three hyperlinks, and one comment
PackageRelationshipCollection hyperlinks =
sheet.GetRelationshipsByType(HYPERLINK_REL_TYPE);
PackageRelationshipCollection comments =
sheet.GetRelationshipsByType(COMMENTS_REL_TYPE);
Assert.AreEqual(3, hyperlinks.Size);
Assert.AreEqual(1, comments.Size);
// Check we can Get bits out by id
// Hyperlinks are rId1, rId2 and rId3
// Comment is rId6
Assert.IsNotNull(hyperlinks.GetRelationshipByID("rId1"));
Assert.IsNotNull(hyperlinks.GetRelationshipByID("rId2"));
Assert.IsNotNull(hyperlinks.GetRelationshipByID("rId3"));
Assert.IsNull(hyperlinks.GetRelationshipByID("rId6"));
Assert.IsNull(comments.GetRelationshipByID("rId1"));
Assert.IsNull(comments.GetRelationshipByID("rId2"));
Assert.IsNull(comments.GetRelationshipByID("rId3"));
Assert.IsNotNull(comments.GetRelationshipByID("rId6"));
Assert.IsNotNull(sheet.GetRelationship("rId1"));
Assert.IsNotNull(sheet.GetRelationship("rId2"));
Assert.IsNotNull(sheet.GetRelationship("rId3"));
Assert.IsNotNull(sheet.GetRelationship("rId6"));
}
/**
* Excel uses relations on sheets to store the details of
* external hyperlinks. Check we can load these ok.
*/
[Test]
public void TestLoadExcelHyperlinkRelations() {
Stream is1 = OpenXml4NetTestDataSamples.OpenSampleStream("ExcelWithHyperlinks.xlsx");
OPCPackage pkg = OPCPackage.Open(is1);
PackagePart sheet = pkg.GetPart(
PackagingUriHelper.CreatePartName(SHEET_WITH_COMMENTS));
Assert.IsNotNull(sheet);
// rId1 is url
PackageRelationship url = sheet.GetRelationship("rId1");
Assert.IsNotNull(url);
Assert.AreEqual("rId1", url.Id);
Assert.AreEqual("/xl/worksheets/sheet1.xml", url.SourceUri.ToString());
Assert.AreEqual("http://poi.apache.org/", url.TargetUri.ToString());
// rId2 is file
PackageRelationship file = sheet.GetRelationship("rId2");
Assert.IsNotNull(file);
Assert.AreEqual("rId2", file.Id);
Assert.AreEqual("/xl/worksheets/sheet1.xml", file.SourceUri.ToString());
Assert.AreEqual("WithVariousData.xlsx", file.TargetUri.ToString());
// rId3 is mailto
PackageRelationship mailto = sheet.GetRelationship("rId3");
Assert.IsNotNull(mailto);
Assert.AreEqual("rId3", mailto.Id);
Assert.AreEqual("/xl/worksheets/sheet1.xml", mailto.SourceUri.ToString());
Assert.AreEqual("mailto:dev@poi.apache.org?subject=XSSF%20Hyperlinks", mailto.TargetUri.AbsoluteUri);
}
/*
* Excel uses relations on sheets to store the details of
* external hyperlinks. Check we can create these OK,
* then still read them later
*/
[Test]
public void TestCreateExcelHyperlinkRelations() {
String filepath = OpenXml4NetTestDataSamples.GetSampleFileName("ExcelWithHyperlinks.xlsx");
OPCPackage pkg = OPCPackage.Open(filepath, PackageAccess.READ_WRITE);
PackagePart sheet = pkg.GetPart(
PackagingUriHelper.CreatePartName(SHEET_WITH_COMMENTS));
Assert.IsNotNull(sheet);
Assert.AreEqual(3, sheet.GetRelationshipsByType(HYPERLINK_REL_TYPE).Size);
// Add three new ones
PackageRelationship openxml4j =
sheet.AddExternalRelationship("http://www.Openxml4j.org/", HYPERLINK_REL_TYPE);
PackageRelationship sf =
sheet.AddExternalRelationship("http://openxml4j.sf.net/", HYPERLINK_REL_TYPE);
PackageRelationship file =
sheet.AddExternalRelationship("MyDocument.docx", HYPERLINK_REL_TYPE);
// Check they were Added properly
Assert.IsNotNull(openxml4j);
Assert.IsNotNull(sf);
Assert.IsNotNull(file);
Assert.AreEqual(6, sheet.GetRelationshipsByType(HYPERLINK_REL_TYPE).Size);
Assert.AreEqual("http://www.openxml4j.org/", openxml4j.TargetUri.ToString());
Assert.AreEqual("/xl/worksheets/sheet1.xml", openxml4j.SourceUri.ToString());
Assert.AreEqual(HYPERLINK_REL_TYPE, openxml4j.RelationshipType);
Assert.AreEqual("http://openxml4j.sf.net/", sf.TargetUri.ToString());
Assert.AreEqual("/xl/worksheets/sheet1.xml", sf.SourceUri.ToString());
Assert.AreEqual(HYPERLINK_REL_TYPE, sf.RelationshipType);
Assert.AreEqual("MyDocument.docx", file.TargetUri.ToString());
Assert.AreEqual("/xl/worksheets/sheet1.xml", file.SourceUri.ToString());
Assert.AreEqual(HYPERLINK_REL_TYPE, file.RelationshipType);
// Will Get ids 7, 8 and 9, as we already have 1-6
Assert.AreEqual("rId7", openxml4j.Id);
Assert.AreEqual("rId8", sf.Id);
Assert.AreEqual("rId9", file.Id);
// Write out and re-load
MemoryStream baos = new MemoryStream();
pkg.Save(baos);
MemoryStream bais = new MemoryStream(baos.ToArray());
pkg = OPCPackage.Open(bais);
// use revert to not re-write the input file
pkg.Revert();
// Check again
sheet = pkg.GetPart(
PackagingUriHelper.CreatePartName(SHEET_WITH_COMMENTS));
Assert.AreEqual(6, sheet.GetRelationshipsByType(HYPERLINK_REL_TYPE).Size);
Assert.AreEqual("http://poi.apache.org/",
sheet.GetRelationship("rId1").TargetUri.ToString());
Assert.AreEqual("mailto:dev@poi.apache.org?subject=XSSF Hyperlinks",
sheet.GetRelationship("rId3").TargetUri.ToString());
Assert.AreEqual("http://www.openxml4j.org/",
sheet.GetRelationship("rId7").TargetUri.ToString());
Assert.AreEqual("http://openxml4j.sf.net/",
sheet.GetRelationship("rId8").TargetUri.ToString());
Assert.AreEqual("MyDocument.docx",
sheet.GetRelationship("rId9").TargetUri.ToString());
}
[Test]
public void TestCreateRelationsFromScratch() {
MemoryStream baos = new MemoryStream();
OPCPackage pkg = OPCPackage.Create(baos);
PackagePart partA =
pkg.CreatePart(PackagingUriHelper.CreatePartName("/partA"), "text/plain");
PackagePart partB =
pkg.CreatePart(PackagingUriHelper.CreatePartName("/partB"), "image/png");
Assert.IsNotNull(partA);
Assert.IsNotNull(partB);
// Internal
partA.AddRelationship(partB.PartName, TargetMode.Internal, "http://example/Rel");
// External
partA.AddExternalRelationship("http://poi.apache.org/", "http://example/poi");
partB.AddExternalRelationship("http://poi.apache.org/ss/", "http://example/poi/ss");
// Check as expected currently
Assert.AreEqual("/partB", partA.GetRelationship("rId1").TargetUri.ToString());
Assert.AreEqual("http://poi.apache.org/",
partA.GetRelationship("rId2").TargetUri.ToString());
Assert.AreEqual("http://poi.apache.org/ss/",
partB.GetRelationship("rId1").TargetUri.ToString());
// Save, and re-load
pkg.Close();
MemoryStream bais = new MemoryStream(baos.ToArray());
pkg = OPCPackage.Open(bais);
partA = pkg.GetPart(PackagingUriHelper.CreatePartName("/partA"));
partB = pkg.GetPart(PackagingUriHelper.CreatePartName("/partB"));
// Check the relations
Assert.AreEqual(2, partA.Relationships.Size);
Assert.AreEqual(1, partB.Relationships.Size);
Assert.AreEqual("/partB", partA.GetRelationship("rId1").TargetUri.OriginalString);
Assert.AreEqual("http://poi.apache.org/",
partA.GetRelationship("rId2").TargetUri.ToString());
Assert.AreEqual("http://poi.apache.org/ss/",
partB.GetRelationship("rId1").TargetUri.ToString());
// Check core too
Assert.AreEqual("/docProps/core.xml",
pkg.GetRelationshipsByType(
"http://schemas.openxmlformats.org/package/2006/relationships/metadata/core-properties").GetRelationship(0).TargetUri.ToString());
// Add some more
partB.AddExternalRelationship("http://poi.apache.org/new", "http://example/poi/new");
partB.AddExternalRelationship("http://poi.apache.org/alt", "http://example/poi/alt");
// Check the relations
Assert.AreEqual(2, partA.Relationships.Size);
Assert.AreEqual(3, partB.Relationships.Size);
Assert.AreEqual("/partB", partA.GetRelationship("rId1").TargetUri.OriginalString);
Assert.AreEqual("http://poi.apache.org/",
partA.GetRelationship("rId2").TargetUri.OriginalString);
Assert.AreEqual("http://poi.apache.org/ss/",
partB.GetRelationship("rId1").TargetUri.OriginalString);
Assert.AreEqual("http://poi.apache.org/new",
partB.GetRelationship("rId2").TargetUri.OriginalString);
Assert.AreEqual("http://poi.apache.org/alt",
partB.GetRelationship("rId3").TargetUri.OriginalString);
}
[Test]
public void TestTargetWithSpecialChars()
{
OPCPackage pkg;
String filepath = OpenXml4NetTestDataSamples.GetSampleFileName("50154.xlsx");
pkg = OPCPackage.Open(filepath);
Assert_50154(pkg);
MemoryStream baos = new MemoryStream();
pkg.Save(baos);
// use revert to not re-write the input file
pkg.Revert();
MemoryStream bais = new MemoryStream(baos.ToArray());
pkg = OPCPackage.Open(bais);
Assert_50154(pkg);
}
public void Assert_50154(OPCPackage pkg) {
Uri drawingUri = new Uri("/xl/drawings/drawing1.xml",UriKind.Relative);
PackagePart drawingPart = pkg.GetPart(PackagingUriHelper.CreatePartName(drawingUri));
PackageRelationshipCollection drawingRels = drawingPart.Relationships;
Assert.AreEqual(6, drawingRels.Size);
// expected one image
Assert.AreEqual(1, drawingPart.GetRelationshipsByType("http://schemas.openxmlformats.org/officeDocument/2006/relationships/image").Size);
// and three hyperlinks
Assert.AreEqual(5, drawingPart.GetRelationshipsByType("http://schemas.openxmlformats.org/officeDocument/2006/relationships/hyperlink").Size);
PackageRelationship rId1 = drawingPart.GetRelationship("rId1");
Uri parent = drawingPart.PartName.URI;
Uri rel1 = new Uri(Path.Combine(parent.ToString(),rId1.TargetUri.ToString()),UriKind.Relative);
Uri rel11 = PackagingUriHelper.RelativizeUri(drawingPart.PartName.URI, rId1.TargetUri);
Assert.AreEqual("'Another Sheet'!A1", WebUtility.UrlDecode(rel1.ToString().Split(new char[]{'#'})[1]));
Assert.AreEqual("'Another Sheet'!A1", WebUtility.UrlDecode(rel11.ToString().Split(new char[] { '#' })[1]));
PackageRelationship rId2 = drawingPart.GetRelationship("rId2");
Uri rel2 = PackagingUriHelper.RelativizeUri(drawingPart.PartName.URI, rId2.TargetUri);
Assert.AreEqual("../media/image1.png", rel2.OriginalString);
PackageRelationship rId3 = drawingPart.GetRelationship("rId3");
Uri rel3 = new Uri(Path.Combine(parent.ToString(), rId3.TargetUri.ToString()), UriKind.Relative);
Assert.AreEqual("#ThirdSheet!A1", rel3.OriginalString.Split(new char[] { '/' })[3]);
PackageRelationship rId4 = drawingPart.GetRelationship("rId4");
Uri rel4 = new Uri(Path.Combine(parent.ToString(), rId4.TargetUri.ToString()), UriKind.Relative);
Assert.AreEqual("#'\u0410\u043F\u0430\u0447\u0435 \u041F\u041E\u0418'!A1", WebUtility.UrlDecode(rel4.OriginalString.Split(new char[] { '/' })[3]));
PackageRelationship rId5 = drawingPart.GetRelationship("rId5");
Uri rel5 = new Uri(Path.Combine(parent.ToString(), rId5.TargetUri.ToString()), UriKind.Relative);
// back slashed have been Replaced with forward
//Assert.AreEqual("file:///D:/chan-chan.mp3", rel5.ToString());
PackageRelationship rId6 = drawingPart.GetRelationship("rId6");
Uri rel6 = new Uri(ResolveRelativePath(parent.ToString(), WebUtility.UrlDecode(rId6.TargetUri.ToString())), UriKind.Relative);
//Assert.AreEqual("../../../../../../../cygwin/home/yegor/dinom/&&&[access].2010-10-26.log", rel6.OriginalString);
//Assert.AreEqual("#'\u0410\u043F\u0430\u0447\u0435 \u041F\u041E\u0418'!A5", HttpUtility.UrlDecode(rel6.OriginalString.Split(new char[] { '/' })[3]));
}
public static string ResolveRelativePath(string referencePath, string relativePath)
{
return Path.GetFullPath(Path.Combine(referencePath, relativePath));
}
[Test]
public void TestSelfRelations_bug51187()
{
MemoryStream baos = new MemoryStream();
OPCPackage pkg = OPCPackage.Create(baos);
PackagePart partA =
pkg.CreatePart(PackagingUriHelper.CreatePartName("/partA"), "text/plain");
Assert.IsNotNull(partA);
// reference itself
PackageRelationship rel1 = partA.AddRelationship(partA.PartName, TargetMode.Internal, "partA");
// Save, and re-load
pkg.Close();
MemoryStream bais = new MemoryStream(baos.ToArray());
pkg = OPCPackage.Open(bais);
partA = pkg.GetPart(PackagingUriHelper.CreatePartName("/partA"));
// Check the relations
Assert.AreEqual(1, partA.Relationships.Size);
PackageRelationship rel2 = partA.Relationships.GetRelationship(0);
Assert.AreEqual(rel1.RelationshipType, rel2.RelationshipType);
Assert.AreEqual(rel1.Id, rel2.Id);
Assert.AreEqual(rel1.SourceUri, rel2.SourceUri);
Assert.AreEqual(rel1.TargetUri, rel2.TargetUri);
Assert.AreEqual(rel1.TargetMode, rel2.TargetMode);
}
[Test]
public void TestTrailingSpacesInURI_53282()
{
OPCPackage pkg = null;
using (Stream stream = OpenXml4NetTestDataSamples.OpenSampleStream("53282.xlsx"))
{
pkg = OPCPackage.Open(stream);
}
PackageRelationshipCollection sheetRels = pkg.GetPartsByName(new Regex("/xl/worksheets/sheet1.xml"))[0].Relationships;
Assert.AreEqual(3, sheetRels.Size);
PackageRelationship rId1 = sheetRels.GetRelationshipByID("rId1");
Assert.AreEqual(TargetMode.External, rId1.TargetMode);
Uri targetUri = rId1.TargetUri;
Assert.AreEqual("mailto:nobody@nowhere.uk%C2%A0", targetUri.OriginalString);
//Assert.AreEqual("nobody@nowhere.uk\u00A0", targetUri.OriginalString);
Console.WriteLine("how to get string \"nobody@nowhere.uk\\u00A0\"");
MemoryStream out1 = new MemoryStream();
pkg.Save(out1);
pkg = OPCPackage.Open(new ByteArrayInputStream(out1.ToArray()));
out1.Close();
sheetRels = pkg.GetPartsByName(new Regex("/xl/worksheets/sheet1.xml"))[(0)].Relationships;
Assert.AreEqual(3, sheetRels.Size);
rId1 = sheetRels.GetRelationshipByID("rId1");
Assert.AreEqual(TargetMode.External, rId1.TargetMode);
targetUri = rId1.TargetUri;
Assert.AreEqual("mailto:nobody@nowhere.uk%C2%A0", targetUri.OriginalString);
//Assert.AreEqual("nobody@nowhere.uk\u00A0", targetUri.Scheme);
}
[Test]
public void TestEntitiesInRels_56164()
{
Stream is1 = OpenXml4NetTestDataSamples.OpenSampleStream("PackageRelsHasEntities.ooxml");
OPCPackage p = OPCPackage.Open(is1);
is1.Close();
// Should have 3 root relationships
bool foundDocRel = false, foundCorePropRel = false, foundExtPropRel = false;
foreach (PackageRelationship pr in p.Relationships)
{
if (pr.RelationshipType.Equals(PackageRelationshipTypes.CORE_DOCUMENT))
foundDocRel = true;
if (pr.RelationshipType.Equals(PackageRelationshipTypes.CORE_PROPERTIES))
foundCorePropRel = true;
if (pr.RelationshipType.Equals(PackageRelationshipTypes.EXTENDED_PROPERTIES))
foundExtPropRel = true;
}
Assert.IsTrue(foundDocRel, "Core/Doc Relationship not found in " + p.Relationships);
Assert.IsTrue(foundCorePropRel, "Core Props Relationship not found in " + p.Relationships);
Assert.IsTrue(foundExtPropRel, "Ext Props Relationship not found in " + p.Relationships);
// Should have normal work parts
bool foundCoreProps = false, foundDocument = false, foundTheme1 = false;
foreach (PackagePart part in p.GetParts())
{
if (part.PartName.ToString().Equals("/docProps/core.xml"))
{
Assert.AreEqual(ContentTypes.CORE_PROPERTIES_PART, part.ContentType);
foundCoreProps = true;
}
if (part.PartName.ToString().Equals("/word/document.xml"))
{
Assert.AreEqual(XWPFRelation.DOCUMENT.ContentType, part.ContentType);
foundDocument = true;
}
if (part.PartName.ToString().Equals("/word/theme/theme1.xml"))
{
Assert.AreEqual(XWPFRelation.THEME.ContentType, part.ContentType);
foundTheme1 = true;
}
}
Assert.IsTrue(foundCoreProps, "Core not found in " + Arrays.ToString(p.GetParts().ToArray()));
Assert.IsTrue(foundDocument, "Document not found in " + Arrays.ToString(p.GetParts().ToArray()));
Assert.IsTrue(foundTheme1, "Theme1 not found in " + Arrays.ToString(p.GetParts().ToArray()));
}
}
}