How to get table relationships in excel sheet

Aspose.Cells Product Family
1

Hi,
I have multiple tables in my excel sheet and i have defined relationship between those tables. I can get this relationship information using Interop.Excel as shown in below code.

private static List GetTableRelations(Microsoft.Office.Interop.Excel.Workbook myBook)
{
List relations = new List();
Microsoft.Office.Interop.Excel.Model model = myBook.Model;
Microsoft.Office.Interop.Excel.ModelRelationships relationships = model.ModelRelationships;
foreach (Microsoft.Office.Interop.Excel.ModelRelationship rel in relationships)
{
relations.Add(new Relationship()
{
PKTableName = rel.PrimaryKeyTable.Name,
PKColumnName = rel.PrimaryKeyColumn.Name,
FKTableName = rel.ForeignKeyTable.Name,
FKColumnName = rel.ForeignKeyColumn.Name
});
}
return relations;
}

I am not able to find similar classes in Aspose. How to get table relationships using aspose.cells?

Thanks,
Sanjay A.

2

@SanjayAswale,

I have logged the issue in our database for investigation. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSNET-46694 - Get table relationships in excel sheet

Also, could you please share your template file for our analysis.

3

Attached image shows how to add relationships in the Excel sheet.
Also attached (inside zip) is my sample Excel sheet for your reference.

ExcelTableRelationship.png (262.7 KB)
AgilePoint4.zip (46.2 KB)

Thanks,
Sanjay A.

4

@SanjayAswale,

Thank you. We will write back here once any feedback is ready to share.

5

Any updates on this ticket?

6

@SanjayAswale,
I am afraid that still no progress is made in this direction due to its complexity. We will write back here when any update will be ready to share.

We are sorry for the inconvenience caused to you.

7

@SanjayAswale,
We are looking into Data Model, we hope that we can support it in the next month.

8

Hi,
Any updates on this ticket?

9

@SanjayAswale,

The feature is not implemented yet. We will write back here once there is an update on it.

10

@SanjayAswale,

This is to inform you that your requested feature (Ticket ID: “CELLSNET-46694”) has been implemented. The fix/enhancement will be included in the next (upcoming) release (Aspose.Cells v24.11 package) that we plan to release in the first half of November 2024. You will be notified when new version is published.

11

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