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)
PKTableName = rel.PrimaryKeyTable.Name,
PKColumnName = rel.PrimaryKeyColumn.Name,
FKTableName = rel.ForeignKeyTable.Name,
FKColumnName = rel.ForeignKeyColumn.Name
I am not able to find similar classes in Aspose. How to get table relationships using aspose.cells?