Request to expose the "Type" property to determine if external links have a valid path or not

Aspose.Cells Product Family
1

We are currently using Aspose.Cells 19.8.

In the Excel XLSX file (OOXML format) each external link is defined by two files located in the following folders within packed OOXML file:

  1. \xl\externalLinks
  2. \xl\externalLinks_rels

I am interested in getting the “Type” property from the files located in \xl\externalLinks_rels.
This is an example of the file contents in \xl\externalLinks_rels folder:Working external link:

<?xml version="1.0" encoding="UTF-8"?> <Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships"> <Relationship Id="rId1" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/externalLinkPath" Target="file:///\\CLIENT\P$\WINDOWS\Temporary%20Internet%20Files\OLK7372\A0121632.XLS" TargetMode="External" /> </Relationships>

Broken external link:

<?xml version="1.0" encoding="UTF-8"?> <Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships"> <Relationship Id="rId1" Type="http://schemas.microsoft.com/office/2006/relationships/xlExternalLinkPath/xlPathMissing" Target="Blackston_FI" TargetMode="External" /> </Relationships>

As You can see, the “Type” property is different in these two:

  1. Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/externalLinkPath"
  2. Type="http://schemas.microsoft.com/office/2006/relationships/xlExternalLinkPath/xlPathMissing"

I need this “Type” property exposed to easily determine if the external link has a valid path or not.

We also tested this using Aspose.Cells 22.4 and the “Type” property is not exposed in this version as well.

2

Aspose.Cells follows MS Excel standards and specifications when rendering/parsing MS Excel files. So, could you check if Type attribute is added for Excel files (XLSX) when you generate/create the file in MS Excel manually? If so, kindly do share your sample Excel file, we will check on how to do it via Aspose.Cells APIs.

3

@amjad.sahi

The Type attribute is added when the Excel file is created manually.

Here is how it looks in XML (line 4):

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships">
	<Relationship Id="rId1" 
		Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/externalLinkPath" 
		Target="ChildFile/Child.xlsx" 
		TargetMode="External"
	/>
</Relationships>

This XML is contained in \xl\externalLinks_rels\externalLink1.xml.rels within the OpenXML Excel structure.

I am attaching the test files created using Microsoft Excel Version 2108, build 14332.20145, 64-bit.

https://files.axiomint.com/external/file/1ng16616ac96307a34e88ab1d08a2dc436ed2

4

@vahem
We will investigate whether we can support it and give feedback soon.

5

@vikram.venugopal
We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSNET-55418

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

6

@vikram.venugopal,

This is to inform you that your issue (logged earlier as: CELLSNET-55418 - Expose the “Type” property to determine if external links have a valid path) has been resolved. The enhancement/fix will be included in our upcoming release (Aspose. Cells v24.4) that we plan to release in the second week of April 2024. You will be notified when the next version is released.

7

Thanks @amjad.sahi.

8

@vikram.venugopal,

You are welcome.

9

The issues you have found earlier (filed as CELLSNET-55418) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi